How to make a Database Form open

[rovman]

Good evening everyone I have built a database and setup my Queeries and Reports and setup my securities. What I want to do is make the Form open from a short cut. I can create the short cut with the security privilages but after the proper name and password is entered I want it to open straight into the Form. How do I get my database to do this?





Lloyd

[RuralGuy]

Either use the AutoExec macro or the Setup screen. http://www.btabdevelopment.com/ts/03startup

[rovman]

Thank you very much that helped a lot.

[RuralGuy]

You're welcome. Glad we could help.

[rovman]

well I went in and setup Access 2007 to open the form upon opening and when it opens it goes to a blank page then I have to hit the enter button again and the form comes up. I can not find anything to stop Access from acting like this!!!!!! any suggestions?

[RuralGuy]

How about when you open the db while holding down a <SHIFT> key? Are the results the same? Do you have an AutoExec macro defined?

[rovman]

I have never setup an Autoexc. macro before. The db still opens the same way if I hold the shift key and open.

[rovman]

Having built the database in Access 2002 and then using 2007 to run it with, could this be an issue?

[RuralGuy]

How did you implement the security you mentioned in post #1?

[rovman]

After I built the data base and all the fetures I wanted into it here at home on 2002 I took it to work and opened it up on my work computer and saved it there. Then using using 2007 I built the security for each user and myself. Users having restricted abilities and myself having full access.

[RuralGuy]

Once the user has logged in, how are you getting to the next form? What code do you use?

[rovman]

Currently once you login the database opens to a blank screen you then hit the "Enter" button and the forms comes up. It should come up into the form without hitting the enter button. As the form opens it runs a On Open "maximize" event. I tried putting a "Open form" Macro in the On Open but did not change the way it opens. I can get the data base to open like I want in 2002 and 2003 but not in 2007 and above.

[RuralGuy]

Do you get the same results when you open that form from the development window? How are you opening the form from your Login code?

[rovman]

Yes if I open MS Access and then open the form from there it opens the same way. I am unsure were to open to see the login code. When I set security I use the wizard and then go back in under User and Group Permissions and setup what people are able to do.

[RuralGuy]

Look in the OnOpen or OnLoad events of that for and see if there is anything there. Comment it out if there is and see if that helps. Are you talking about the User Level Security that was built into ac2003?