Opening with Form

[admin etc]

Does anyone know how I can open a database file and have a form menu open up
automatically as a front end and hide the back tables and queries? I know you
use to be able to do it in the older versions of Access but not sure with
Access 2007

Also does anyone know if I can refresh a query by opening a form or do you
have to refresh each query individually?

thanks

 

[Jeff Boyce]

Yes.

Click on the Office emblem ('belt buckle'). Select Access Options (bottom
of screen).

You can set which form to use on startup, and you can hide the NAV pane.

Of course, the users would still be able to use the Ribbon and re-open the
NAV pane, so your users had better be pretty sophisticated and trained
Access users, or you'll also need to build/use a custom Ribbon...

Regards

Jeff Boyce
Microsoft Office/Access MVP