Solved

MS Access Marco

Posted on 2014-02-21
5
400 Views
Last Modified: 2014-02-21
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
0
Comment
Question by:Richard Korts
  • 2
  • 2
5 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 39877894
for your information, what you want to alter is a query.
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
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 39877896
First ... on the File menu at the top of Access:

File>>SaveAs
Enter your new name.

Now make the changes ... the File>>Save

done.
0
 

Author Comment

by:Richard Korts
ID: 39878185
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.
0
 
LVL 75
ID: 39878191
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.
0
 

Author Closing Comment

by:Richard Korts
ID: 39878252
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.EXE" "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!
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now