Macro Question 1

[JeremyAnderson]

Ok so I writting my frist Macro in Access and I want it to auto respond to all pop ups with Yes. How would I do this?

 

[fneily]

SetWarnings set bottom parameter to No
At end of macro, reset to Yes

 

[JeremyAnderson]

Thank you very much!!! That worked beautifully.

Next Question: Im doing a query as part of this macro and I need it to prompt the user for a date range to query against. What should i use as the criteria for the query?

 

[PHV]

Simply have a parametized query !

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JeremyAnderson]

Also: Is it possible to create a report based on multiple queries? If so how, as I have been unable to do so. Sorry for the basic questions. I just am very unfamiliar with Access.

 

[CLMooreJr]

Sure, you can have a query within a query, and run the report off of that.

 

[fneily]

For your date range prompt, on the criteria line underneath your date field you can use the Between function with two parameter prompts. EG.
Between [Enter a Start Date] And [Enter an End date]
prompts go from left to right so first it will ask for a start date then the end date and then run the query.