Access Data to Excel or Word Form

Is there a way to export data to an excel or word form, similar to a mail merge in Word? I will be extracting data to a .txt file, link it to Access and isolate the data I need via queries, then merge the data to a form in Word or Excel. I know how to connect a query to an excel spreadsheet but this is something I’ve never done before.

I’m trying to create an audit process where data is exported from our system, link it to access, and then data is exported to a form that can be handed out to individuals.

submitted by /u/regmeyster
[link] [comments]

Posted on

Report/month

Report/month

HI guys ,

Im sure that for you its something very simple but for me is quite difficult

I Created a querry from a table which is giving me the date and month of a booking

my question : I need to create a report for each month ,do I need to create more querries or can I modify a report to show just a specific month and save it

I will be better to have this report at the end of each month automatically if any possibility

what do you think ?Can you help me ?

I will apreciate guys thanks

https://i.redd.it/j5hdyt69u1p21.png

submitted by /u/costicano
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

Report/month

Report/month

HI guys ,

Im sure that for you its something very simple but for me is quite difficult

I Created a querry from a table which is giving me the date and month of a booking

my question : I need to create a report for each month ,do I need to create more querries or can I modify a report to show just a specific month and save it

I will be better to have this report at the end of each month automatically if any possibility

what do you think ?Can you help me ?

I will apreciate guys thanks

https://i.redd.it/j5hdyt69u1p21.png

submitted by /u/costicano
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

Beginner needing help

I have a few questions about how to do an if statement and reference other cells . eg. a. If the Employment Type is “Full Time”, then Hourly Rate = Base Rate b. If the Employment Type is “Casual”, then Hourly Rate = 1.25 x Base Rate

I understand excel but this goes right over my head 🙁

submitted by /u/ChaosAngelAsh
[link] [comments]

Posted on

Insert many records into table from Multiple Items Form (MS Access 2016)

Insert many records into table from Multiple Items Form (MS Access 2016)

I have a multiple value form: sbfrmTests_multi
Please ignore sbfrm – at present that is the name, but it has no parent right now.*

Form use:

Select tests and insert them into a template with the same templateID.

I have a static table: tblTests

  • A table of tests, to populate the selection options (Checkboxes) on sbfrmTests_multi

I have a data entry table: TestRecord

  • A table to hold the templateID and the tests selected from sbfrmTests_multi

Help requested:

Insert records into other table based on selection.

  • When you select the available options, the form returns with the tests selected
  • Need: Insert one field from the form results, and two unbound textboxes, into table TestRecord, from ALL displayed records based on the selection
  • Unbound textbox one is the SAME for all: this is the template ID
  • Unbound textbox two needs to be different for each row – right now it updates ALL rows when I enter the top value
  • Have another form (TBA) that I can enter constantly changing data into for a report.
    • If I select “Template 1” I want it to pull the tests from TestRecord that have “1” as the template ID, then assign an additional value that will change every time I use that form
    • This is based on the previously selected tests associated to template 1.
      • (Create the template, select the tests for that template)
      • (Create the unique report, based on that template, and enter the test results for that particular day)
  • I’m only referencing this if it changes the way THIS form must be laid out.
  • I have a VBA macro that inserts the desired fields into the table, but only inserts the FIRST row

The form’s data source is a Select Totals query (to prevent duplicate records):

1SELECT DISTINCTROW Testing.testid, Testing.TestCategory, Testing.Test, Max(Testing.TestMethod) AS MaxOfTestMethod, Max(Testing.NPN) AS MaxOfNPN, Max(Testing.Cosmetic) AS MaxOfCosmetic, Max(TestRecord.TemplateID) AS MaxOfTemplateID, Max(TestRecord.TestRecordID) AS MaxOfTestRecordID FROM Testing, CoATemplate, TestRecord GROUP BY Testing.testid, Testing.TestCategory, Testing.Test HAVING (((Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_hm] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_hma] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_mb] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_mb2] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_pe] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_rs] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_pc] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_me] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_bo] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_ad1] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_ad2] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_wa] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_cu1] Or (Testing.TestCategory)=[forms]![sbfrmTests_multi]![t_cu2])) ORDER BY Testing.TestCategory, Testing.Test; 

I added two unbound textboxes to the form: (TemplateID_1) that will eventually auto-populate from a parent form (header), (TemplateID_2) in the data field entry of the multiple items form.

TemplateID_2 updates to = TemplateID_1 (working as desired).

What I need is a command button to insert all visible records from the multi-select form into another table.

So if I select test a, b and c, the multiple items form shows test a,b, and c – and templateID updates to be the same for all the results that display.

I need help inserted all displayed records on the form into table: TestRecord.

I can only get the first row to insert with a command button right now.

I’m sorry for the convoluted questions and truly appreciate any help! 🙂 <3

https://i.redd.it/544xyk3n9p931.jpg

submitted by /u/rssnroulette
[link] [comments]

Posted on

List Update with Entered Text

I have a table with a field which has a short text list created by the lookup wizard where I entered the drop down values. The user is not limited by the list and can therefore input their own values. When a user inputs their own value or a value thats not in the list, the input does not get added to the list. I am trying to make it so the input (if not in the list already) will add to the list for future use.

Example: User goes to the name field and wants to find John Smith. name is not in the list so user inputs “John Smith” and saves the record. A new record is made and the user wants to find John Smith and it was automatically added from when they manually entered it in before.

submitted by /u/spartyon11
[link] [comments]

Posted on