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
|
|||
|
|||
How to Edit the Macro that exists behind an existing Command Butto
Hi There,
Hoping someone can help me out ... I have inherited the task of managing an Access 2007 application. Within this application I have an Access 2007 form that has a Command Button. I'm not sure how this Command Button was created (Macro, Query, etc.) but I do know what it does. I would like to edit the Query/Macro this Command Button executes. I'd rather not edit the VBA coding as I am a VBA Beginner. Can you pleae let me know how I can edit the Command Button's Query/Macro. Thank you, Jason |
#2
|
|||
|
|||
How to Edit the Macro that exists behind an existing Command Butto
A command button can run a macro or a VB event procedure. If it runs an event
procedure, you cannot modify it via a macro. Go into design view on the form, right click the button and choose 'build event'. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "TP9999" wrote: Hi There, Hoping someone can help me out ... I have inherited the task of managing an Access 2007 application. Within this application I have an Access 2007 form that has a Command Button. I'm not sure how this Command Button was created (Macro, Query, etc.) but I do know what it does. I would like to edit the Query/Macro this Command Button executes. I'd rather not edit the VBA coding as I am a VBA Beginner. Can you pleae let me know how I can edit the Command Button's Query/Macro. Thank you, Jason |
#3
|
|||
|
|||
How to Edit the Macro that exists behind an existing Command B
Hi Dorian,
Thanks for the info. After analyzing the code it states that it opens a Form. Can you suggest a good Access 2007 book that teaches all aspects of Access 2007 in a clea, ordered, and concise manner. And includes VBA coding for Access 2007. Thanks, Jason "Dorian" wrote: A command button can run a macro or a VB event procedure. If it runs an event procedure, you cannot modify it via a macro. Go into design view on the form, right click the button and choose 'build event'. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "TP9999" wrote: Hi There, Hoping someone can help me out ... I have inherited the task of managing an Access 2007 application. Within this application I have an Access 2007 form that has a Command Button. I'm not sure how this Command Button was created (Macro, Query, etc.) but I do know what it does. I would like to edit the Query/Macro this Command Button executes. I'd rather not edit the VBA coding as I am a VBA Beginner. Can you pleae let me know how I can edit the Command Button's Query/Macro. Thank you, Jason |
Thread Tools | |
Display Modes | |
|
|