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

don't show reminders form on startup

P: n/a
How can I make a checkbox that says "Do not show this again at startup"
on my reminder form?
Thanks!

--
name: Mark S.
email: hu********@hotmail.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
You would open the form in design mode. Use the toolbox to place a checkbox on the form
and change the caption of its label to "Do not show this again at startup".

Now for what I think you really wanted. To get this to work, create a table with a field
for this checkbox. It will be a one record, one field table. In the OnLoad event of your
startup form, check the value of this field (DLookup will work for this) and if it is
True, cancel the load of the form. Give the user another method to reenable this if they
want (either another way to open the form so they can uncheck the box or some other way to
reset it.)

Also, do you want a different form to show if this one doesn't? If so, you may need 2
fields in the table, one to hold the name of the next startup form also. You would call
this 2nd form from the startup form's load event if the value of the check field is true.

--
Wayne Morgan
Microsoft Access MVP
"mark s" <hu********@hotmail.com> wrote in message
news:3f*********************@news.frii.net...
How can I make a checkbox that says "Do not show this again at startup"
on my reminder form?
Thanks!...get rewarded for it!

Nov 12 '05 #2

P: n/a
Another way to do this is to reverse engineer the method shown in the sample Northwind.mdb
database. See the form and module named "Startup".

________________________________________

"Wayne Morgan" <co***************************@hotmail.com> wrote in message
news:ea******************@newssvr32.news.prodigy.c om...
You would open the form in design mode. Use the toolbox to place a checkbox on the form
and change the caption of its label to "Do not show this again at startup".

Now for what I think you really wanted. To get this to work, create a table with a field
for this checkbox. It will be a one record, one field table. In the OnLoad event of your
startup form, check the value of this field (DLookup will work for this) and if it is
True, cancel the load of the form. Give the user another method to reenable this if they
want (either another way to open the form so they can uncheck the box or some other way to
reset it.)

Also, do you want a different form to show if this one doesn't? If so, you may need 2
fields in the table, one to hold the name of the next startup form also. You would call
this 2nd form from the startup form's load event if the value of the check field is true.

--
Wayne Morgan
Microsoft Access MVP
________________________________________

"mark s" <hu********@hotmail.com> wrote in message
news:3f*********************@news.frii.net...

How can I make a checkbox that says "Do not show this again at startup"
on my reminder form?
Thanks!
Nov 12 '05 #3

P: n/a
How do I use "DLookup"?

--
name: Mark S.
email: hu********@hotmail.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #4

P: n/a
Try Lookup the Help :)
Patrick

On 09 Nov 2003 13:20:55 GMT, mark s <hu********@hotmail.com> wrote:
How do I use "DLookup"?


Nov 12 '05 #5

P: n/a
http://www.mvps.org/access/general/gen0018.htm

______________________________________

"Patrick" <in**@businessformat.co.uk> wrote in message
news:bl********************************@4ax.com...

Try Lookup the Help :)
Patrick

On 09 Nov 2003 13:20:55 GMT, mark s <hu********@hotmail.com> wrote:
How do I use "DLookup"?

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.