Database startup

[organicpatti]

Is there a way to have an icon on my desktop that I could click to open my
database switchboard without the access program window opening also?
I would like the user to not be able to see and use the File,Edit,View,Format,
etc. options and all other tools. I want the user to just see my switchboard
and use the forms and reports it opens. All my forms have their own command
buttons.

 

[J. Goddard]

Hi -

A form (or any MS Access object for that matter) always opens in the MS
Access program window - that's how MS Access works (unless you have the
edition to create .exe files).

Having said that, you can prevent a menu bar from displaying with a form
by setting the menu bar property of the form to "=1" (no quotes).
There are other ways to keep users out of "native" access:

- set the form's shortcut menu property to "No" (prevents the
right-click shortcut menus)
- in Tools-Startup, unselect "allow toolbar/menu changes"
- in tools-startup, unselect "display database window"
- set the modal property of forms to "Yes" (F11 doesn't work for a modal
form)
- make sure that the Form Close also closes the application

Not all of these are applicable in all cases of course, and you have to
be sure that you don't lock yourself out, too!

I use some of these - we all have users who know just enough to be
dangerous.

HTH

John

 

[fredg]

Is there a way to have an icon on my desktop that I could click to open my
database switchboard without the access program window opening also?
I would like the user to not be able to see and use the File,Edit,View,Format,
etc. options and all other tools. I want the user to just see my switchboard
and use the forms and reports it opens. All my forms have their own command
buttons.

Click on Tools + StartUp.
Enter the Switchboard form name in the Display Form/Page box.
Uncheck the Display Database Window check box.
Uncheck the Allow Full Menus, Allow Default Shortcut Menus, and the
Allow Built-in Toolbars check boxes.
Uncheck the Allow Access Special Keys check box.

Close the database.
To open the database with the tool bars and menus, etc., showing you
will have to hold down the shift key when you open the database

See Access help for more information.

 

[organicpatti via AccessMonster.com]

Hi J
The .exe files is the answer I was looking for. Thanks so much for your help.

OrganicPatti

 

[organicpatti via AccessMonster.com]

Thanks so much for the breakdown
OrganicPatti

Click on Tools + StartUp.
Enter the Switchboard form name in the Display Form/Page box.
Uncheck the Display Database Window check box.
Uncheck the Allow Full Menus, Allow Default Shortcut Menus, and the
Allow Built-in Toolbars check boxes.
Uncheck the Allow Access Special Keys check box.

Close the database.
To open the database with the tool bars and menus, etc., showing you
will have to hold down the shift key when you open the database

See Access help for more information.

 

[Duane Hookom]

You can't create an exe with Access. You can create a run-time version of
Access but it works with a standard mdb or mde (or other similar Access
extensions).

 

[fredg]

Hi Fred,

I was hoping you could help me. I wanted to prevent the use of the menus in
Access so I tried deselecting "Allow Full Menus" in the Startup dialog box.
Unfortunately, I did not restrict the Edit menu like I wanted but I can no
longer see the Tools menu to change this option back.

I tried your solution of holding the shift key while opening the database
but it didn't seem to work. Can you please elaborate on this or advise
another way to access the Startup dialog box again?

My end goal is simply to prevent users from deleting records. I thought I
would be able to disable the Edit menu to do this but obviously, I was
mistaken. Please advise.

Sincerely,
Jim

You probably unchecked the 'Display Database Window' check box in the
Start Up dialog box.

To open the database and bypass the StartUp selections, either

1) Hold down the Shift Key while opening the database
OR...
2) open the database and then press F11