Shortcut & Pre-sized Window Form

[uneek78]

I plan on having a form that my users could use to save information into. I've gotten the shortcut to work, but not exactly like I want. I would like to know what ways others use. I am attempting:

- A shortcut for the form
- Pre-sized form window that can't be resized by users
- When it opens for nothing none of the DB to open along with it
- When it's closed for all windows including the background access window to close

Once again, I've gotten this stuff to work before but never perfectly. I am curious how everybody deals with these things.

 

[Chrism2]

For the shortcut, a simple bit of VBA in the OnClick element of a button:

DoCmd.OpenForm("YourForm")

Create your form in design mode as you need - sized accordingly.

In the form Properties, under Format

Border Style = Thin

and under Other

Pop Up = Yes
Modal = Yes

Not too sure what you mean by the last point.... but when you close the Modal form, control of the rest of the Access DB will be restored.