Simple Question?

[AcceSs-AbLe]

Hi Everyone,

I have a simple question. My db will be entirely form driven, however, I want to grant certain users access to the "database window"(F11 Key). I am using a "bootleg" process to accomplish this, simply, I have a link to the db window and a text box prompts for a password and as long as the password matches the one in code, it will load the main db window.

To get to the main point, I can't find the VBA command that opens the Database Window.

Thank you for your help!!

 

[mdmilner]

Think you mean alt+F11
I think you're looking for:

DoCmd.OpenModule modulename_here

And, have you ever thought about using the built in security wizard?

Tools-Security-(different options here)

You can force logins to the mdb with each login granted specific rights to work with all the objects, including the code modules, in the database.

Mike