Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro Object 3

Status
Not open for further replies.
stephenj789

stephenj789

Technical User
Joined
Jan 28, 2002
Messages
58
Location
US
I have a macro that I created using the Macro Builder in Access. I would like to run that macro in a VBA module. How do I refer to the macro in the VBA code and get it to run? Thank you.
 
Sort by date Sort by votes
Docmd.RunMacro "MacroNameHere"

Kyle
 
Upvote 0 Downvote
or you can use the wizard to convert the macro to VBA

Tools > Macros > Convert macros to visual basic
 
Upvote 0 Downvote
The first one worked and I am sure the second suggestion would work to. Thanks!
 
Upvote 0 Downvote
If you plan on learning VBA, which will give you so much more possibilities than macros, then converting your macros to VBA is a good way to start - see how they 'translate' to code.

thanks for the star
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

feipezi
  • Locked
  • Question Question
How to get the macros back as they vanish somehow in a AccessDB?
Replies
8
Views
1K
combo
combo
ClowneUser
  • Locked
  • Question Question
Moving OLE objects
Replies
1
Views
348
lameid
lameid
MattGreer
  • Locked
  • Question Question
MS Access Macro - SetWarnings - Where is it?
Replies
2
Views
2K
MattGreer
MattGreer
BJZeak
  • Locked
  • Question Question
MSACCESS VBA object Order
Replies
8
Views
548
BJZeak
BJZeak
kronar30
  • Locked
  • Question Question
object properties
Replies
1
Views
268
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top