Suppress welcome page when in design view? 1

[yoshe]

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:

http://www.tek-tips.com/viewthread.cfm?qid=686356

Thanks for any suggestions.

 

[Remou]

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?

 

[yoshe]

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.

 

[Remou]

Very roughly, then.

Add a variable to a module like so:

Option Compare Database
Option Explicit

Const gvarDesign=False

In your code that opens the screen:

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.

 

[yoshe]

Works - thanks!!