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

Program Deactivation

P: 6
Hi everyone, I have a need to deactivate a msaccess app after a certain date (table lookup field). How can I modify which startup form based on date?

Thanks !
Mar 14 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 112
One way to do this, although it could it be defeated by someone who knew what they were doing, is create a function that is run from the autoexec macro. For Example
Expand|Select|Wrap|Line Numbers
  1. If Now > then SOMEDATE then
  2.    docmd.openform "Relevant Form"
  3. Else
  4.    docmd.openform "Other Form"
  5. end if
  6.  
Mar 15 '08 #2

P: 6
Well Thank you! That worked!
Mar 19 '08 #3

Post your reply

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