i would like a linked datasheet (table) to open once access is opened. how do i do this?
+1
A:
Create a form with your linked table as it's record source. Set the form to open automatically at database startup.
Edit: If you really, really feel you need to open the table directly instead of using a form ... look at DoCmd.OpenTable You could put your DoCmd.OpenTable statement in an autoexec macro. Then it should run every time you open the database.
HansUp
2010-09-22 17:46:05
@hansup cant i just open the table?
i am a girl
2010-09-22 17:46:33
You mean open the table in datasheet view? Why? Forms are the "proper" way for user interaction with data.
HansUp
2010-09-22 17:48:48
@hansup yes i just need the datasheet, i need a form at all
i am a girl
2010-09-22 17:50:44
@hansup thank you very much, but that is the problem. can you walk me through the autoexec? i created the macro, where should i be putting the DoCmd function/?
i am a girl
2010-09-22 18:03:50
OK. I seldom do macros. Looks like create a new macro, choose OpenTable in the Actions column and add your table name in the Table Name box. Doesn't that work? You must save the macro with the name autoexec.
HansUp
2010-09-22 18:25:27
A table datasheet is not a proper user interface for end users. Don't do this. It is a mistake. You will regret it and you'll run into problems. Take @HansUp's advice instead.
David-W-Fenton
2010-09-23 21:31:30