Richard Korts
asked on
MS Access Marco
Hi,
See attached. I used to know how to do this, but it's been years..........
I want to take the marco opened in design view (LSS_EXTR_Cust-actv), add some fields from the same table & do a "save as" with a different macro name.
I DO NOT want to modify the existing macro.
How do I do that?
I'm not sure of the Access version (it looks old).
Thanks
AccessMacro.jpg
See attached. I used to know how to do this, but it's been years..........
I want to take the marco opened in design view (LSS_EXTR_Cust-actv), add some fields from the same table & do a "save as" with a different macro name.
I DO NOT want to modify the existing macro.
How do I do that?
I'm not sure of the Access version (it looks old).
Thanks
AccessMacro.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great, thanks.
How can I tell if this macro (or ANY Macro) is an "Autoexec" macro.?
I will need to make the new one the Autoexec macro (eventually) and of course turn off the old (current) one.
How can I tell if this macro (or ANY Macro) is an "Autoexec" macro.?
I will need to make the new one the Autoexec macro (eventually) and of course turn off the old (current) one.
If it's a real auto exec macro ... it will actually have the name:
AutoExec
no more, no less :-)
Access looks for that exact name when loading, and if found - executes whatever commands are in that macro.
AutoExec
no more, no less :-)
Access looks for that exact name when loading, and if found - executes whatever commands are in that macro.
ASKER
I see how they did it; there is no AutoExec macro, they open the database by executing a .bat file that has this line:
"C:\Program Files\Microsoft Office\Office11\MSACCESS.E XE" "C:\C_LSS\DB\Linked_to_LSS .mdb" /x "LSS_MACR_Mo-1"
"LSS_MACR_Mo-1" is a macro that executes a query that does what I need.
Thanks!
"C:\Program Files\Microsoft Office\Office11\MSACCESS.E
"LSS_MACR_Mo-1" is a macro that executes a query that does what I need.
Thanks!
to create a copy of the query, select the query and do a right click , select copy then paste
give the query a new name.
now, open the new query in design view and add the fields then save