E
ecapox via AccessMonster.com
What is really sad is that my work blocks logins to accessmonster and I have
to type this on my GD iPhone. Anyways....
Issue with docmd.transferdatabase. Transferring all access object from one
database with code to about 60 other databases. All transferring of items
work except macros. Code example below:
for each ao in currentproject.allmacros
Docmd.transferdatabase _
Acexport, _
"Microsoft access", _
Strdestdb, _
Acmacro, _
Ao.name, _
Ao.name, _
False
next ao
pretty straight forward. It finds the macro but when it goesto export it to
the destination db I get a runtime error 7874- Microsoft office access cannot
find the object 'mcr_repair101pcode'. What is strange is that it references
the correct name of the macro but it says it cat find it. Very strange.
Any ideas??
Thanks
emanuele
to type this on my GD iPhone. Anyways....
Issue with docmd.transferdatabase. Transferring all access object from one
database with code to about 60 other databases. All transferring of items
work except macros. Code example below:
for each ao in currentproject.allmacros
Docmd.transferdatabase _
Acexport, _
"Microsoft access", _
Strdestdb, _
Acmacro, _
Ao.name, _
Ao.name, _
False
next ao
pretty straight forward. It finds the macro but when it goesto export it to
the destination db I get a runtime error 7874- Microsoft office access cannot
find the object 'mcr_repair101pcode'. What is strange is that it references
the correct name of the macro but it says it cat find it. Very strange.
Any ideas??
Thanks
emanuele