open table

[ilham]

Hi,
I am in access,please anybody help me,i want to ask,
How to simplify coding for opening to many tables in one time?


I want to reduce waiting run time for user ..

Please Help me
...Thank You

[ranman256]

your question makes no sense.
open a table with the command....
docmd.opentable "tablename"

[ilham]

sorry maybe i make it clear here,

let says i have many table...table 1,table 2,........table20.

how if i want to do openrecordset with this all table in same time.

i means if i open one by one and get the data from this table one by one..and close it one by one.

the runtime will be longer.

Please help me..Thank You

[JoeM]

You could create a Macro using the ranman256's OpenTable action to open up all the tables you want with a single click.
Though, it seems like a rather odd request.
What is the purpose of doing so? Is the data related?
If so, and you want to view all the data for one person/entity, consider using a query, where you link the tables you want and return the data you want in a single object, or perhaps use Subforms to return records related to another single record.

[orange]

ilham,

See this article
http://www.utteraccess.com/wiki/inde..._for_Beginners