Pop up forms

[StephenSLR]

I'd like a have it so that soon as Access is opened a form pops up, how do I do this?

s

 

[jaydwest]

Do you mean that whenever you open Access, you want to open the same database?

Do you want to allow the user to open Access from anywhere, like start menu or desktop, or can you live with a single preprogrammed shortcut that will open Access and a Database at the same time?

 

[StephenSLR]

Do you mean that whenever you open Access, you want to open the same database?

Sorry, I mean when a person opens a particular database file, a pop up 'form' appears then they can enter the values into the form, select command buttons, etc.

So that a novice doesn't have to go into the objects dialog box and select the wrong form, etc.

s

 

[jaydwest]

On the MS Access Toolbar, choose Tools | Startup| and enter the name of the popup form in the Display Form/Page field. You may also want to prevent users from viewing the Database Window by clicking Display Database Window Off.

Good Luck

 

[StephenSLR]

cheers for that.

s

 

[StephenSLR]

You may also want to prevent users from viewing the Database Window by clicking Display Database Window Off.

This works great but how do I get back into the Database window now that I want to modify something?

It has locked me out.

Can it be password set to stop others modifying the database?

s

 

[jaydwest]

You do not have to click of the Show Database Window off. Or if you do, and you want to work on the Datatabase Window. Close the Database, and then open it again, this time holding the {Shift} Key down. This will open the database without running any code.

Good Luck