Macro code

captnk

Registered User.
Local time
Today, 00:06
Joined
Dec 12, 2001
Messages
148
Does anyone have a nice short piece of code to run a macro (VB script ok) from a button please.
Any ideas welcome
 
Hi,
if you have a macro already set up than simply have database window active on the macro's tab and form in design view active in the background. Just click and drag the macro over the form and as the cursor moves to form it will change into the button.
Place the macro/button where you want it and that should be it.
Alternatively create a normal button and under properties 'On Click' select the macro from the drop down box.
HTH

Chris
 
OOPs!
I realise I should have mentioned that the button already exists and performs other functions (by vb script),and the Macro needs to be run in as part of the existing sequence.
Thats why I am looking for a script.
Tks
 

Users who are viewing this thread

Back
Top Bottom