K
Katrina
I would like to use the Button_OnClick command in db1 to
run a macro from db2. Is this possible?
I'm trying to use DB1 to open a macro (in DB2) and begin
exporting forms from DB2 to a DB3.
The reason I have this set up like this is because DB2
(Updater.mdb) is a Db set up for updating DB1
(UserDb.mdb). DB3 is the master(MasterDB.mdb). I have 2
Options for updating the database.
1) You can copy the MasterDB file over the UserDB file.
(Thus the need for another DB to update, so that UserDB
can be closed)*** I have this set up****
2)You can export the forms and reports from MasterDB into
UserDB, so that user's custom forms and reports so not get
erased. (this is what I'm trying to accomplish.)
Does anyone know how I can accomplish 2) from
Updater.mdb? My thought is that I can Open MasterDB and
run a macro to export the forms etc. I know how to make
the macro, however, I don't know how to run it from an
outside DB.
Can someone please let me know if there is a way to run a
macro in MasterDB from Updater.mdb?
Thanks in advance,
Katrina
run a macro from db2. Is this possible?
I'm trying to use DB1 to open a macro (in DB2) and begin
exporting forms from DB2 to a DB3.
The reason I have this set up like this is because DB2
(Updater.mdb) is a Db set up for updating DB1
(UserDb.mdb). DB3 is the master(MasterDB.mdb). I have 2
Options for updating the database.
1) You can copy the MasterDB file over the UserDB file.
(Thus the need for another DB to update, so that UserDB
can be closed)*** I have this set up****
2)You can export the forms and reports from MasterDB into
UserDB, so that user's custom forms and reports so not get
erased. (this is what I'm trying to accomplish.)
Does anyone know how I can accomplish 2) from
Updater.mdb? My thought is that I can Open MasterDB and
run a macro to export the forms etc. I know how to make
the macro, however, I don't know how to run it from an
outside DB.
Can someone please let me know if there is a way to run a
macro in MasterDB from Updater.mdb?
Thanks in advance,
Katrina