Thanks Graham! AHA CurrentProject... hmmmm.
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Graham Mandeno
Sent: Thursday, June 28, 2012 4:03 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] forms collection to get names by indexing like tabldefs
Hi Liz
You can use the Forms collection for all _open_ forms, and the CurrentProject.AllForms collection for (as the name suggests :-) _all_ the forms in the database, whether open or not.
Members of the Forms collection are Form objects.
Members of the AllForms collection are AccessObject objects.
Both of these objects have a .Name property.
Both collections have a .Count property and start indexing at 0, and both may be enumerated using a loop counter or a "For Each" loop.
Incidentally, you can also use the CurrentProject collections for other object types: AllReports, AllMacros and AllModules. Note that there are no AllTables or AllQueries collections - for these you use CurrentDb.TableDefs and CurrentDb.QueryDefs, respectively.
Best wishes,
Graham
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Tidak ada komentar:
Posting Komentar