ACCESS FEED: RE: [MS_AccessPros] forms collection to get names by indexing like tabldefs

Kamis, 28 Juni 2012

RE: [MS_AccessPros] forms collection to get names by indexing like tabldefs

Thanks Crystal!

Is the type translating to "form" and the flag... what is the flag referring to?

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 Crystal
Sent: Thursday, June 28, 2012 4:04 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] forms collection to get names by indexing like tabldefs

Hi Liz,

forms:
SELECT MSysObjects.Name, MSysObjects.DateCreate, MSysObjects.DateUpdate
FROM MSysObjects
WHERE ((MSysObjects.Type=-32768) AND (Left([Name],4)<>"MSys") AND (MSysObjects.Flags=0))

Warm Regards,
Crystal

*
(: have an awesome day :)
*

________________________________
From: Liz Ravenwood

Pros, Is there a way to get the form name like one gets table names through cycling through some kind of formdefs.count in the currentdb?

Liz Ravenwood

[Non-text portions of this message have been removed]

------------------------------------

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.