VBA Code not running in Access

[piggeh]

I have a button in a form in Access that I am trying to place some VBA code against when someone clicks it. Code I have at the moment is as follows:

Private Sub Command41_Click()
MsgBox ("this is a test")
End Sub 

The button opens up a report in print preview so it has something as an embedded macro already that runs when you click it. Even though I've put the above into visual basic editor, it doesn't pop up when someone clicks the button, so I'm guessing it prioritises the embedded macro over anything that's in Visual Basic?

Any advice on how to solve please? First bit of custom VBA I've done in MS Office so probably a noob mistake.

[MaddAussie]

Is it 2007? if so you may have to tell Excel, Access or what ever to trust your code

[piggeh]

Is it 2007? if so you may have to tell Excel, Access or what ever to trust your code

It's Access 2007. Have told it to trust the code.

Had a play round though and if I change the button properties from 'Embedded macro' to 'Event Procedure' it then runs the VBA code but doesn't then run the embedded macro that was in place... will keep having a play.

[piggeh]

So basically what I'm trying to do is have a password box that needs to be filled in on a form as authorisation for an order to be raised. Then the print PO button will check the field to ensure it matches the code within the user table and if it matches, to then run the rpeort in print preview mode so it can be printed out. I have figured out how to use VBA to check whether the box is empty or not, and can figure out the rest of the code to check password is correct. However I dont know how to then hand it over to the macro if everytihng is ok at the end of it all. Any ideas?

I saved the embedded macro so it now has a name, but cannot figure out how to call it within the VBA code.

[Flash477]

DoCmd.RunMacro "MyMacro"

[piggeh]

DoCmd.RunMacro "MyMacro"

Quality! Works a charm. Thank you

[Flash477]

As you have found out naming a function in a certain way does not cause it to run, it has to be tied to the event property of the button.

Basically Macros are a shorthand way of running VBA commands and the only way to run both at once is to call the macro in the VBA code. The above code should do what you need - or you can just convert the macro to VBA code.

[piggeh]

I think I will keep it in macro format - basically I created a form and various gubbins previously, trying not to rewrite it all too much and just put some control structures in place in various areas, so if I just name the various macros I should be ok.

Need to now do some SQL query to match passwords up but will figure that out easily enough (hopefully).

Thanks for the help.