Data Entry Form

[Jayniesgottagun]

I have created a data entry form that will only allow a new record. It's a
quick and dirty trouble ticket. Control Box, MinMax Buttons, Close Button
disabled (they either submit the ticket or cancel). In the startup options,
I only have the status bar and special keys checked.

So, here is my question. Ideally, I would like to have only the form open -
no Access window, just the form. My users are operating in an emergency
service environment and I don't want them to have to do anything extra to
complete the trouble ticket. I realize I would be better served using an
app development environment, but I have to work with what I have, which is
Access2003. I know precious little about VBA but am learning as I go.

Thanks in advance, JGG

 

[Al Campagna]

Jayne,
Some of the things you can do to "secure" a form/app...
Select Tools/Startup...
1. DisplayForm/Page = Your FormName... Access opens to that form.
2. Hide Database Window = YES... that will hide the Access screen.
3. Allow ToolBar menu changes = NO... that will not allow Menu Customizing by the
user.
4. Allow ShortCut Menu Bars = NO... no right click menus available to users
5. Allow Full Menus = NO
Create your own MenuBar for the form with just the functions you need (If any). Hide
all others.
Make the form's Exit button on the form Close Access itself (DoCmd.Quit instead of
DoCmd.Close), and customize
Make the form PopUp and Modal, and hide the Max/Min and control buttons.

Using some, or all of these options can secure your form/application from user
interference.

 

[Jayniesgottagun]

Thanks Al,

This, for the most part works for me. I think I'm going to have to end up
making the jump to vb to just run an executable.

 

[Al Campagna]

Jaynie,
You wrote...

making the jump to vb to just run an executable.

But, even with an "executable" (not sure what you mean by that), you'll still have to
"mix and match" my various suggestions to secure your application and objects from user
interference.

Don't forget to consider an MDE file instead of MDB. That will prevent any "design"
changes.