forms as VBA

A

another pvp

I assume that forms and reports in Access are stored not as images but as
VBA code although that is not made visible to the programmer. If that is
true, IS there a way I could edit a form (or report) in its VBA incarnation?

One reason for this question is that I want to globally change the name of
some forms' controls in that form and in VBA modules and subs and
functions all in one operation.

Many thanks.
 
A

Albert D. Kallal

You can certainly export the forms design into a meta code.

in the debug window, type:

saveastext acForm,"form1","c:\hold\form1.txt"

You can use loadfromText to reverse this process.

For sure the built in search and replace can function globally (all code in
forms, reports, modules) ...but, it don't function globally on controls

It would certanly be a good deal of work to setup you coding idea.....
 
D

Dirk Goldgar

another pvp said:
I assume that forms and reports in Access are stored not as images
but as VBA code although that is not made visible to the programmer.
If that is true, IS there a way I could edit a form (or report) in
its VBA incarnation?

One reason for this question is that I want to globally change the
name of some forms' controls in that form and in VBA modules and subs
and
functions all in one operation.

Many thanks.

Note: I posted a reply to this message where you posted it
independently in another newsgroup. That's called "multiposting", and
it's generally frowned on because others don't know what answers have
already been given, and so they duplicate the effort. Also it's harder
for you to keep track of the various replies, and it's harder for later
readers of the question, who may be looking for the same answer, to
learn what they need.

In most cases a single, well-chosen newsgroup will do. If your question
really is relevant to more than one newsgroup, the approved technique is
to "crosspost" it instead, by listing multiple newsgroups in the To: or
Newsgroups: line of a single message. If you do that, the message and
any replies will appear in all the listed newsgroups automatically,
which is beneficial to all concerned.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top