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

Welcome Guest ( Log In | Register )

> Creating a macro to run multiple queries using one customer ID    
 
   
MikeLBall
post Mar 14 2007, 02:45 PM
Post#1


New Member
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
Replies
Larry Larsen
post Mar 14 2007, 03:59 PM
Post#2


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


Hi
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:
=Forms!YourFormname!YourClientID
Q: Why so many queries..?
thumbup.gif
Go to the top of the page
 

Posts in this topic



RSSSearch   Top   Lo-Fi    28th January 2015 - 01:12 PM