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

finding form control names

P: n/a
I need to disable all controls on a form at startup. How can I get this
information from the comands collection using ADO?


Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
ADO will give you access to the fields in the form's RecordSource, but not
to the controls on the form.

Loop through the form's Controls collection, and set the Disabled property
if the control has one: some don't, e.g. lines, command buttons, and labels,
so you will need to use error handling. In general, only the controls with a
Control Source property need to be disabled.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Mike" <mw******@swin.edu.au> wrote in message
news:3f********@news.cc.swin.edu.au...
I need to disable all controls on a form at startup. How can I get this
information from the comands collection using ADO?

Nov 12 '05 #2

P: n/a


Hi Allen,

Thanks for your reply. Can you tell me what I need to do to loop through
the controls using ADO. I have done this using DAO but want to move onto
ADO.

Thanks for your time again.

Mike

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

P: n/a
Hi,

Thanks for your reply. Can you tell me what I need to do to loop through
the controls using ADO. I have done this using DAO but want to move onto
ADO.

Thanks for your time again.
"Mike" <mw******@swin.edu.au> wrote in message
news:3f********@news.cc.swin.edu.au...
I need to disable all controls on a form at startup. How can I get this
information from the comands collection using ADO?

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.