Date triggering an input cwalrus 28.09.2006 21:04:01 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.

Re: Date triggering an input "Arvin Meyer [MVP]" <a[ at ]m.com> 29.09.2006 00:47:06 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 "cwalrus" <cwalrus[ at ]discussions.microsoft.com> wrote in message news:1ED7DA7B-1071-40E3-8158-D483B272F4B7[ at ]microsoft.com... [Quoted Text] > 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.