How do I run vba code in Access without a macro window opening?

  • Thread starter Thread starter mb1946
  • Start date Start date
M

mb1946

I am brand new to Access 2007 VBA programming. When I try to run simple test
VBA code, a window pops up asking for a macro name.

What am I doing wrong and how can I get around this?
 
mb1946 said:
I am brand new to Access 2007 VBA programming. When I try to run simple
test
VBA code, a window pops up asking for a macro name.

What am I doing wrong and how can I get around this?
Click to expand...

What's the code and how are you trying to run it? (there are several ways)
 
Your VBA code has to generate an output. Place a debug.print "place an output
variable name"; without the quotes of course and open the Immediate Pane by
selecting Ctl-G.

You should see your output in the Immediate Pane. If nothing happens then
your code may require calling the function from a query, or some other higher
level object.
 
Back
Top