Help! Referencing containers!tables specific item without looping

[Jozef]

Hi Folks!

I'm trying to reference a specific table using the containers collection.
I'm trying to use my help file to find out more about how to accomplish
this, but for some reason, when I double click on the topic, the page won't
open.

Right now I'm trying to loop through each document until the document name
equals what I'm looking for. What is the syntax for referencing a specific
document without having to loop through all the documents in the collection?
Thanks!

[Allen Browne]

You can use the document name as the index for the collection:
? dbEngine(0)(0).Containers!Forms.Documents("Form1") .Name

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jozef" <[e-mail]> wrote in message
news:Qyuif.216037$ir4.126895@edtnps90...

Hi Folks!

I'm trying to reference a specific table using the containers collection.
I'm trying to use my help file to find out more about how to accomplish
this, but for some reason, when I double click on the topic, the page
won't open.

Right now I'm trying to loop through each document until the document name
equals what I'm looking for. What is the syntax for referencing a
specific document without having to loop through all the documents in the
collection?
Thanks!

[Tom van Stiphout]

On Mon, 28 Nov 2005 11:23:19 +0800, "Allen Browne"
<Al*********@SeeSig.Invalid> wrote:

What Allen said, or:
? dbEngine(0)(0).Containers("Forms").Documents("Form 1").Name

-Tom.

You can use the document name as the index for the collection:
? dbEngine(0)(0).Containers!Forms.Documents("Form1") .Name

[Jozef]

Thanks guys! Appreciate it!

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:vc********************************@4ax.com...

On Mon, 28 Nov 2005 11:23:19 +0800, "Allen Browne"
<Al*********@SeeSig.Invalid> wrote:

What Allen said, or:
? dbEngine(0)(0).Containers("Forms").Documents("Form 1").Name

-Tom.

You can use the document name as the index for the collection:
? dbEngine(0)(0).Containers!Forms.Documents("Form1") .Name