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

Calling queries from MacroVBA - where query has a parametercriteria

P: n/a
I am trying to automate some tasks in Access 2000:

Currently I have a few parameter queries to select the information I
want.

i.e. I have a Select query with >=[Enter Date:] as a criteria in a date
field, in effect giving me only the dates I am interested in.

My question is: is it possible to make either a macro, or use VBA, to
run such a query AND provide the criteria. Say I made a form where I
enter the date in a field on the form, and then click a button to run
the select criteria above. Is that possible?

Thanks for any help,

Espen

Feb 24 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hello,

Just edit the select query criteria to reference the
text field on your form. Then when you click the
button on the form to run the query you should
get your end result.

i.e. = [Forms]![FormNameHere]![DateFieldNameHere]

Have a good weekend.

Regards

Feb 24 '06 #2

P: n/a
Excellent. It works like a charm.

Thank you very much!

Feb 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.