By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

Surpressing parameter box

P: 55
with exporting forms. So here is the situation:

I have a forms/subforms, which I use to view data. This data is also being exported via access 2003 macros to excel 2003. Because I have a bounded form, where I can select different Account Numbers ( ie. 10, 20, 30, etc.) when I go to export these Account numbers with their data. Access is requesting me to enter a Parameter value. I already have the criteria I want, so I do not need to enter a parameter value. I realize I could copy the original query and exclude the bounded subform, or I could just click okay through it, however, I'd rather not do it.

Is there a way to block Access from requesting parameter values?
Aug 6 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,383
Please use a more descriptive title next time. I changed it for you this time.

No, you can't surpress the parameter box, you'll have to use a different query.
Aug 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.