Creating a macro to run multiple queries using one customer ID
Mar 14 2007, 02:45 PM
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.
Mar 14 2007, 03:59 PM
UA Editor + Utterly Certified
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..?
|Search Top Lo-Fi||29th March 2017 - 12:06 PM|