Instructions for use of Position Request Form.

[AJOLSON]

I am designing a form that I want the user to interface with. Functionally I
want it to do the following.

1. The form to open up when the user opens the program .
2. The user can only interact with that form. So there is only a minimize
button and a close button.
3. there is now toolbars so all the user sees it the form and the only
choise they have are to input on the form or close the form.


Now I know how to do the first two. Startup for the form to open and set
the properties for the minimize and maximize buttons. However I am clueless
to making it so no toolbars appear. Not only do I not want them to not
appear I don’t want the user to be able to make them appear on there own
either. All I want is for the user to be able to open the form interact with
it then close the form.

Can anyone help me to achieve this?

Thanks
Andy

 

[MikeJohnB]

You don't say which version of Access you are using? However, you can do
nearly all you want from the Tools\Startup menu (Access 2k3) Set the form you
want to open as the Display Form/Page. You can then un check the Allow Full
Menus, Allow Default Shortcut Menus and the other options. You have to be
carefull, if you uncheck the allow Access Special Keys, then even you wont be
able to display any of the menus for later editing. You should only do this
trial on a copy of your database. Keep a copy with these options unset so you
can edit for future. If you don't want to disable the allow Access Special
Keys, then you can always view the menus by holding down the shift key as you
open the database.

If you are using Access 2007, then you can do exactly the same but you find
this option from clicking on the windows globe, Top Left Hand corner of the
open database. From the drop down menu, select Access Options button at the
bottom of the pop up window. Select Current Database from the left hand side
of the popup screen. This is where you set all the options for opening the
database, the form to display "display form" drop down box and all the
various menu display (Or not to display) settings are there also.

The only thing left to do is set the maximise of the desired form in the
properties of the form as it opens. (Form Properties, On Load event)

Private Sub Form_load()
DoCmd.Maximise
'DoCmd.Gotorecord,,AcNewRecord '(if required)
End Sub

If you want to set focus to a specific control

Private Sub Form_Open()
DoCmd.GotoControl "yourcontrolname"
End Sub

I hope this helps you?????

Regards

 

[AJOLSON]

I am using 2003 and have this working about 99% the way I want it to.

I have uncecked all the boxes within the start up section (execpt speical
Keys) and most of what I did not want them to see is gone. Also within
properties of the form I only am allowing them to close the form no minmizing
or maxiizing, I take care of the maxiizing / new record on form load (in
startup). Much like you sugested.

However the last piece of the pie is the toolbar at the top

the on that says

File Edit Inset Records Windows Help

I cant get that to go away.

Any sugestions.

Thanks for the help

Andy

 

[AJOLSON]

Bingo, that did the trick. Thanks

Andy

Try this:

Create a custom toolbar with just File | Exit. Then in the startup dialog
you've been using, change the Menu Bar from 'default' to the new toolbar
you've created.

I am using 2003 and have this working about 99% the way I want it to.

I have uncecked all the boxes within the start up section (execpt speical
Keys) and most of what I did not want them to see is gone. Also within
properties of the form I only am allowing them to close the form no minmizing
or maxiizing, I take care of the maxiizing / new record on form load (in
startup). Much like you sugested.

However the last piece of the pie is the toolbar at the top

the on that says

File Edit Inset Records Windows Help

I cant get that to go away.

Any sugestions.

Thanks for the help

Andy

You don't say which version of Access you are using? However, you can do
nearly all you want from the Tools\Startup menu (Access 2k3) Set the form you

[quoted text clipped - 53 lines]

Thanks
Andy

 

[MikeJohnB]

Glad you got to the bottom of it AJ

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Bingo, that did the trick. Thanks

Andy

Try this:

Create a custom toolbar with just File | Exit. Then in the startup dialog
you've been using, change the Menu Bar from 'default' to the new toolbar
you've created.

I am using 2003 and have this working about 99% the way I want it to.

I have uncecked all the boxes within the start up section (execpt speical
Keys) and most of what I did not want them to see is gone. Also within
properties of the form I only am allowing them to close the form no minmizing
or maxiizing, I take care of the maxiizing / new record on form load (in
startup). Much like you sugested.

However the last piece of the pie is the toolbar at the top

the on that says

File Edit Inset Records Windows Help

I cant get that to go away.

Any sugestions.

Thanks for the help

Andy

You don't say which version of Access you are using? However, you can do
nearly all you want from the Tools\Startup menu (Access 2k3) Set the form you
[quoted text clipped - 53 lines]
Thanks
Andy