Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress welcome page when in design view? 1

Status
Not open for further replies.

yoshe

Technical User
Jan 12, 2007
36
US
Hello,
I have a welcome page for people doing data entry, with the rest of the database hidden. This welcome page pops back up when the user closes the form, and the user exits the database through a button click on this page. Is there any way to stop this page from popping up when I myself go to design view of the form? Really annoying because it sits on top of the design view. I have used the method in the 4th post in this thread:

Thanks for any suggestions.
 
Do you open the database when you are designing using the shift bypass?
How about a global design variable that you can set to true?
 
Remou, yes I go in using shift. Initially it's ok, but if I go into datasheet view to test and then back into design view, that's when the welcome page pops up.
Please elaborate on global design variable - I'm not very advanced. Thanks.
 
Very roughly, then.

Add a variable to a module like so:

Code:
Option Compare Database
Option Explicit

Const gvarDesign=False

In your code that opens the screen:

Code:
If gvarDesign=True Then Exit Sub

When you open the db to do design work, simply change "Const gvarDesign=False" to "Const gvarDesign=True". Make sure you change it back when you have finished working.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top