Generating records from forms - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Generating records from forms

Willem Els

3 years ago

Hi Richard,

Do you have VBA code to scrape all the forms in the DB and make a list of the following.

Button / Label
Name
Caption
Tag
Form name

	Scott Axton @Reply 3 years ago
In the Code Vault: Loop Thru Controls on a Form You would have to specify what you want to do with that information yourself. Also see: Access Developer 22

	Kevin Robertson @Reply 3 years ago
Here is an example with the values added to a List Box. I added the Form Name, the Control Name, and the Control Type (Buttons and Labels only). Note: if you have a lot of forms and have to loop through them all AND loop through all the controls on every form it may take a while to run.

	Kevin Robertson @Reply 3 years ago

	Willem Els OP @Reply 3 years ago
Thanks for the help

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View