Forcing database to open i Data sheet view

[Guest]

I am very novice at this so please bare with me. I have a database that was
pre built. I can get it to open directly to the database however it always
opens in FORM VIEW. I want it to open in DATA SHEET VIEW. Using Access
2007. thanks for any help.

 

[Guest]

If you are opening the form directly, set it's default open mode to Datasheet.

If you are opening the form using VBA code, then include the optional View
argument. For example:

DoCmd.OpenForm "Customers", View:=acFormDS

If you are opening the form using a macro, then set the View to Datasheet.

Note: I assume all this will work in A2007, but at the moment, I'm working
with a copy of A2003 myself.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

Thank you for the quick response. I am clicking on the .mdb file directly.
That inturn opens Access 2007 and the database. However, it always opens the
form view. We don't use the form view only the data sheet for direct data
entry. Does that give you enough info to help me out? Thanks again, JIM

 

[Guest]

Hi Jim,

Yes, it does give enough information, however, I'm at a bit of a
disadvantage right now, since I do not have Access 2007 available at the
moment.

In Access 2003, you would either set the startup form via Tools > Startup...
menu, or by using an Autoexec macro. Try to find the equivalent of Tools >
Startup in A2007. I suspect if you click on the Office Button thingy in the
upper left corner, then click on Access Options, that you will find it
somewhere. As long as you specify the correct form, and it's default open
mode is set to Datasheet, that should do it for you.

If you have a macro specifically named Autoexec, then you can set your
startup form there as well. You should pick one method, either by specifying
a startup form or using an Autoexec macro, but don't try to use both methods
in the same database.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________