By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,608 Members | 1,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,608 IT Pros & Developers. It's quick & easy.

create a table containing all form names/captions

P: 76
Is it possible to create a table containing all the forms names/captions?

For example: fields: FormId, FormName

Each time a new form is created it should be added either to the list under FormName or even each form as field with the name of the form as the field name.

Nov 21 '11 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 446
Why bother? All forms names are stored in the system table MSysObjects otherwise Access would not work.

You can list them anytime by looping through the Forms collection.
Browse help on how to do this
Nov 22 '11 #2

Expert Mod 15k+
P: 31,709
Without punctuation this isn't very clear (plural or possessive is important here) what you're trying to ask for.

All I can tell you until it is asked properly is that there already exist (hidden/system) tables in your database where such items are already maintained.
Nov 22 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.