Restoring VBA code to a form

[Lou_Reed]

I accidentally erased all of the VBA code for one of my forms.



That is okay. I have a backup of the db with that form included.

Now I know that I cannot just do a wholesale copy of the form's VBA code
since many of the subprograms are associated with a button on the form.

That cannot be ignored.

So I just find a button on the codeless form, then go to
design view and press f4. That will bring up the properties of the button
and immediately tell me (when pressing the event tab) whether or not
the button has VBA code associated with it. Then decide on action and
get the first and last lines of VBA code for the button; then go to the backup db get the
complete code for that button and copy and paste into the existing db right
at the point where the two lines (first and last) are located.

Then with a little editing and you have got it. The VBA code is associated with that button.

That works most of the time.

However, in the backup db on the form discussed I have noticed that the are some sub programs
in VBA code that do not seem to obviously have a button associated with them.

It is easy to find the VBA code associated with the button, but how do you find the button
associated with the VBA code? That is the reverse.

I just have some orphan sub programs whose names end in click that I assume are associated
with a button. I just need to find that button.

How do I do it?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[ranman256]

the best way is to make a db copy often.
restore the entire FE db.

you can extract only the code to text files, but its just as easy to open an old db, get the event code,
and paste into the broken db. Sort of a lose-lose situation.

[John_G]

I just have some orphan sub programs whose names end in click that I assume are associated
with a button. I just need to find that button.

The first part of the subprogram name gives the name of the form control, and the second part is the name of the event. Spaces are replaced with Underscores (_).

So, for a sub called MOS_Search_Text_AfterUpdate, this is the code for the After Update event of a control called MOS_Search_Text. (I actually used the underscores in the control name. You cannot change this Sub naming convention - it is how MS Access associates VBA code with events.

As for "finding" the control, the only way I know of is to just look for it in form design view - I don't think Access can point it out to you.

[Lou_Reed]

you can extract only the code to text files, but its just as easy to open an old db, get the event code,
 and paste into the broken db.  Sort of a lose-lose situation.

If I do that the code is not associated with a button. It must be associated with a button or other control
for it to operate when the button is activated.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[CJ_London]

So, for a sub called MOS_Search_Text_AfterUpdate, this is the code for the After Update event of a control called MOS_Search_Text.

this is one of the reasons for not using spaces because the sub could be associated with a control called 'MOS Search Text'

[John_G]

If I do that the code is not associated with a button. It must be associated with a button or other control
for it to operate when the button is activated.

As long as the names of the buttons on both forms are the same, it is a quick fix. Just go in to the events properties for the button control on the new form, click the ... button, and select "Code Builder". Access will link the existing code to that button.

[Lou_Reed]

Yes it will, but would it not be easier to let MS Access 2010 put in the first and last lines of the sub then you can paste the remaining code
and do some editing and there you have it.

It just seems so much easier this way.

Respectfully.

Lou Reed

[John_G]

That works just as well, especially if control names have changed, in which case you have to be careful you don't refer to the old name somewhere.

[pbaldy]

As for "finding" the control, the only way I know of is to just look for it in form design view - I don't think Access can point it out to you.

There is a way actually. With a form/report in design view and the properties window open, there's a dropdown at the top of the properties window. You can select the desired control there and Access will select it in design view.

[aytee111]

Gosh, Paul, in all my years and struggling with this issue I never even noticed that drop down! Brilliant.

[pbaldy]

Yes, it comes in handy with "busy" forms!

[John_G]

Thanks, Paul - I had completely overlooked that, because I almost never use that functionality.

[pbaldy]

Happy to help John!

[Lou_Reed]

There is a way actually.  With a form/report in design view and the properties window open, there's a dropdown at the top of the properties window.  You can select the desired control there and Access will select it in design view.

Please explain on this more elaborately. I am interested in doing this.

Respectfully,


Lou Reed

[Lou_Reed]

Never mind. I have the answer. Thanks anyway.

Respectfully,

Lou Reed