Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Macros / December 2006

automating a set of macros

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robb27 - 16 Dec 2006 02:18 GMT
I have access 2000. I have a couple of macros. 1 fires the other. I want to
automate the first one.
The first macro moves the cursor to a certain field then it fires the other
macro to sort the field ascending and sends the cursor back down the to first
empty row in the same field.
Right now in order for this to work, i have to go to tools, choose macro,
then choose the macro I want to start. - I would like to make it
automated...say with a keyboard shortcut, (I don't want to use a button or
anything, unless it could be a permanent button on the tool bar), but I don't
know how to do that part. I hope I have explained myself well enough. Can
anyone help? Thanks.

Rob
Ken Snell (MVP) - 16 Dec 2006 02:33 GMT
Check out AutoKeys macro in Help file.

Signature

       Ken Snell
<MS ACCESS MVP>

>I have access 2000. I have a couple of macros. 1 fires the other. I want to
> automate the first one.
[quoted text clipped - 12 lines]
>
> Rob
Robb27 - 16 Dec 2006 03:04 GMT
Awesome! - I had read that from a book, but I just couldn't get my brain
around it, but the help file actually got it through. Thanks for the nudge
Ken!

> Check out AutoKeys macro in Help file.
>
[quoted text clipped - 14 lines]
> >
> > Rob
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.