Date triggering an input

[Guest]

Is there a way to get Access to prompt the user to input the month end stock
price after the month ends? For example, if someone opens the database on
10/1/06 or later, I'd like the db to prompt them to input the stock price on
9/30/06. If the stock price has already been entered then I'd like no prompt
to occur.

 

[Arvin Meyer [MVP]]

You're in luck. I just posted a query like that at the AccessMVP website 2
0r 3 days ago. Have a look at:

http://www.accessmvp.com/Arvin/OncePerMonth.zip

It runs once per month, just add your message.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com