Show form only, all else hidden

[timothyl]

Hello, Is it possible to have only a form showing and nothing else off Access visible using 2003, tried with the stuff in the tool section, but if possible could not get it to happen. Thanks

 

[Mr. B]

The options in the Tools/Startup dialog box should get you what you want. Uncheck all options and specify your form as the startup form and when you open the database you will see nothing but your form and a basic menu at the top. If you want to remove even that menu, you can create a custom menu (with nothing in it but an Exit option) and specify that menu in the startup options.

While this does work to produce the results you describe as what you want, you need to know that if the user knows to hold down the shift key when opening the database, they will again have all of the normal options available to them.

If you really want to have your application to the point that the user cannot have other options to work with, look into creating an mde type file and have your users use the mde file and not an mdb file.

 

[timothyl]

Mr. B, I apologize for how long it has taken me to express my gratitude for you response, Thank you that helped

 

[Mr. B]

timothyl,

You are quite welcome. Gald to help.

 

[rana1978]

Hi B..

How can I create an MDE file

Cheers

 

[Mr. B]

There is an option under Tools/Database Utilities called "Make MDE File .."

Depending on the version of Access you are using, you may have to convert your file format to your current version before you can use this option. Although normally ther is no problem and your original file is safe and not affected at all, for saftey sake, be sure to make a backup copy of your database before attempting to creating the MDE.

Just keep in mind that if you find that you need to make modifications to your from end (mde), you will have to make your modifications in your original file (mdb) and create a new mde.