If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Macro / functton question
I have a command button on a form that when pressed I want to run a function
to update a field and then execute a macro which runs queries etc. and produces a report. Can I execute a macro from a function i.e. after I have done my update. I want them both to execute when the button is clicked. There is probably a better way to do this & apologies is this is too dumb for words .. learning as I go along .. Some help would be much appreciated. abay |
#2
|
|||
|
|||
Abay,
No, this is not "too dumb for words". But you will find when asking for help in newsgroups that the more specific you can be, the easier it is for others to understand you. Especially if you can give examples. You can run a macro from within a VBA procedure by using... DoCmd.RunMacro "NameOfYourMacro" -- Steve Schapel, Microsoft Access MVP Abay wrote: I have a command button on a form that when pressed I want to run a function to update a field and then execute a macro which runs queries etc. and produces a report. Can I execute a macro from a function i.e. after I have done my update. I want them both to execute when the button is clicked. There is probably a better way to do this & apologies is this is too dumb for words .. learning as I go along .. Some help would be much appreciated. abay |
#3
|
|||
|
|||
Many thanks Steve ... yes you are right, I should have given an example,
will do next time. ebay "Steve Schapel" wrote in message ... Abay, No, this is not "too dumb for words". But you will find when asking for help in newsgroups that the more specific you can be, the easier it is for others to understand you. Especially if you can give examples. You can run a macro from within a VBA procedure by using... DoCmd.RunMacro "NameOfYourMacro" -- Steve Schapel, Microsoft Access MVP Abay wrote: I have a command button on a form that when pressed I want to run a function to update a field and then execute a macro which runs queries etc. and produces a report. Can I execute a macro from a function i.e. after I have done my update. I want them both to execute when the button is clicked. There is probably a better way to do this & apologies is this is too dumb for words .. learning as I go along .. Some help would be much appreciated. abay |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
A Tricky Question! Macro & Chart | hce | General Discussion | 7 | August 10th, 2004 04:07 AM |
Macro Question | richard birkett | New Users | 1 | June 16th, 2004 01:52 PM |
Macro question | Jim | Worksheet Functions | 2 | June 10th, 2004 08:41 PM |
macro question | Joe Silvers | Worksheet Functions | 1 | September 16th, 2003 02:34 PM |