Results 1 to 2 of 2

Merging 9 Query Runs into 1 Macro Run

  1. #1
    Miskondukt is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2017
    Posts
    21

    Merging 9 Query Runs into 1 Macro Run


    lo all o/

    I have nine queries I run that where I have each prompting to enter in start/end dates, how can I merge these into one macro with only being prompted once to enter in the date range?
    Click image for larger version. 

Name:	AccessMacro1.png 
Views:	9 
Size:	9.6 KB 
ID:	37134

    Thanks for the assist!

  2. #2
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    1,823
    You don't say what method you use to fire these off, but if done from a form, you could fill in the dates in textboxes on the form. Then a command button could execute the queries.
    Each query would have to be modified to get the dates off the form.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 06-04-2016, 01:59 PM
  2. Query Runs Extremely Slow
    By eagerlearner in forum Queries
    Replies: 1
    Last Post: 10-30-2014, 05:44 AM
  3. Missing records when query runs
    By SydB in forum Queries
    Replies: 6
    Last Post: 06-28-2014, 12:43 PM
  4. Replies: 1
    Last Post: 03-11-2014, 08:29 AM
  5. Macro that runs when access closes
    By kdbailey in forum Macros
    Replies: 10
    Last Post: 02-01-2014, 11:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums