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



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,460
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


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 20th December 2014 - 06:39 PM