table

[Jody]

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


simple ? can it be done ?

 

[Nick Coe \(UK\)]

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


simple ? can it be done ?

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
----

 

[Jody]

hey thanks it works.


i dunno, its not my database

 

[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

 

[John Vinson]

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


simple ? can it be done ?

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