Transferring VBA Code

[Arturo]

I have a system set up to update users in the field. Each day the result of
their activity in their main database is captured in a linked database. When
they log off for the day, the linked file is uploaded to an FTP site. This
process also downloads a clean version of that database to allow them to
begin the process for the next session.

The downloaded file is the file that opens first in the process. When it
opens, the Autoexec macro sends new objects and updates to the other
database. I have some forms in this process that need updating occasionally.
Some of these forms have a great deal of code behind them. Sometimes it is
only a minor change.

My question is this. Is there a way that I can transfer the VBA code behind
the form from one database to another without sending the entire form?

Thank you.

 

[Tom van Stiphout]

On Tue, 2 Sep 2008 05:15:00 -0700, Arturo

Not if you are in compiled MDE format, which is the recommended
configuration. I wouldn't try to finess it; if there is a new version,
the user should download it from the server, or some utility (Tony
Toews has one) should do it for her.

-Tom.
Microsoft Access MVP

 

[Arturo]

Thank you.

On Tue, 2 Sep 2008 05:15:00 -0700, Arturo

Not if you are in compiled MDE format, which is the recommended
configuration. I wouldn't try to finess it; if there is a new version,
the user should download it from the server, or some utility (Tony
Toews has one) should do it for her.

-Tom.
Microsoft Access MVP