X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Creating a macro to run multiple queries using one customer ID    
post Mar 14 2007, 02:45 PM

Posts: 2
Joined: 14-March 07

Help me please! I need to create a macro that will run 30 queries for one criteria, a customer ID code. Each of these queries when run alone prompt the user to enter a customer ID. I would like to make a Macro that would ask for this ID once and then run all the relevant queries. it would also be nice if any queries that did not bring back any info would not come up. Is this possible? Can anyone help me? I have a basic knowledge of Access but am not sure how to create this. thank you
Edited by: MikeLBall on Wed Mar 14 15:46:42 EDT 2007.
Go to the top of the page
Start new topic
Larry Larsen
post Mar 14 2007, 03:59 PM

UA Editor + Utterly Certified
Posts: 23,675
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)

Welcome to Utter Access Forums
o remove the need to enter that amount of criteria or that amount of times, your best option would be to use a form where the user selects the client name(id) then use some vba(macro's are limited.. no error's) to run each query.
Your query criteria would look similar to this:
Q: Why so many queries..?
Go to the top of the page

Posts in this topic

Custom Search
RSSSearch   Top   Lo-Fi    1st December 2015 - 07:53 AM