table

J

Jody

I want a certain table to open up when I open the database, automatically..


simple ? can it be done ?
 
N

Nick Coe \(UK\)

Jody said:
I want a certain table to open up when I open the
database,
automatically..


simple ? can it be done ?
Click to expand...

Read up on the AutoExec macro and DoCmd in Acces help.

Forms are the best way to view data in the underlying table,
it's what they're for...

If all you want to do is open a table why bother with
Access..? Why not use Excel?

--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/
Download Free Copy
----
 
D

Dave M

Make a form in datasheet view based on the table, and then select it as the
one to present first in the Tools | Startup options
 
J

John Vinson

I want a certain table to open up when I open the database, automatically..


simple ? can it be done ?
Click to expand...

Base a Form on the table (table datasheets should generally NOT be
used for data viewing or editing), and use the Tools... Startup panel
to specify that this form should open on startup.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top