What is the code to create a list of the controls on a closed form in the
current database?

Thanks!

Steve

On Sat, 11 Oct 2008 17:52:16 -0400, "Steve" <nonsense (AT) nomsense (DOT) com>
wrote:

There is no easy way to do that.

-Tom.
Microsoft Access MVP

Thanks for responding, Tom!

What is the hard way?

Steve


"Tom van Stiphout" <tom7744.no.spam (AT) cox (DOT) net> wrote

"Steve" <nonsense (AT) nomsense (DOT) com> wrote:

You open the form in design view. However that only works for MDBs. You can see
Rick Fisher's Find and Replace work this way.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Thanks for responding, Tony!

What is the code for getting the list of the controls once you have the form
open in design view? You can't use:
For each Ctl In Forms("MyForm").Controls
because the Forms collection doesn't exist when no forms are open.

Further, If whatever you know works for MDBs, does it work for ACCDBs?

Steve



"Tony Toews [MVP]" <ttoews (AT) telusplanet (DOT) net> wrote

On Sat, 11 Oct 2008 20:57:42 -0400, "Steve" <nonsense (AT) nomsense (DOT) com>
wrote:

Why would it NOT work in accdb? That's about database storage, not the
forms package.

Dim ctl As Control
Dim strFormName As String

strFormName = "_test1"
DoCmd.OpenForm strFormName, acDesign
For Each ctl In Forms(strFormName)
Debug.Print ctl.Name
Next
DoCmd.Close acForm, strFormName

-Tom.
Microsoft Access MVP

On Oct 11, 5:52*pm, "Steve" <nonse... (AT) nomsense (DOT) com> wrote:
Save the form as text. Parse the text file. Piece of cake. I'd do it
if I could think of any use for it at all. But I can't.

On Oct 11, 4:52 pm, "Steve" <nonse... (AT) nomsense (DOT) com> wrote:
Not quite the answer you asked for but might this work?

If you were to open the form from a program, but set it as hidden,
then you would be able to get an object with a collection of all the
controls. Once you have gotten from that what you want (made a list,
whatever) you could close the form?

On Sat, 11 Oct 2008 17:52:16 -0400, "Steve" <nonsense (AT) nomsense (DOT) com> wrote:

Depending on your version of Access, see the documentation on the AllForms
collection in VBA help.
--

John W. Vinson [MVP]

MikeB <MPBrede (AT) gmail (DOT) com> wrote:

Trouble is some forms may have external dependencies such as a combo box query based
on another form. That will likely cause an error message to come up when the form
opens that you can't get around.

Thus open the form in design view.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/