How to execute VBA Access module

Question

Ok I m using Access 2003 and I ve just started learning Access and VBA a few days ago  I wrote some code in a module and there are no errors when I press the play button on the debugger toolbar up top   How do I actually execute this code on my database so that it will do something  In other words how do I make use of the module   Please help me out I m struggling hard and the deadline for this is thursday   Thanks

User · Answer

If you just want to run a function for testing purposes, you can use the Immediate Window in Access.

Press Ctrl + G in the VBA editor to open it.

Then you can run your functions like this:

?YourFunction("parameter")
(for functions with a return value - the return value is displayed in the Immediate Window)
YourSub "parameter"
(for subs without a return value, or for functions when you don't care about the return value)
?variable
(to display the value of a variable)

User · Answer

You re not running a module -- you re running subroutines functions that happen to be stored in modules   If you put the code in a standalone module and don t specify scope in the definitions of your subroutines functions  they will be public by default  and callable from anywhere within your application  This means that you can call them with RunCode in a macro  from the class modules of forms reports  from standalone class modules  or for the functions  from SQL  with some caveats    Given that you were trying to implement in VBA something that you felt was too complicated for SQL  SQL is the likely context in which you want to execute the code  So  you should just be able to call your function within the SQL statement     SELECT MyTable PersonID  MyTable FirstName  MyTable LastName  FormatAddress  Address    City    State    Zip    Country   As Address   FROM MyTable    That SQL calls a public function called FormatAddress   that takes as arguments the components of an address and formats them appropriately  It s a trivial example as you likely would not need a VBA function for that purpose  but the point is that this is how you call functions from within a SQL statement   Subroutines  i e   code that returns no value  are not callable from within SQL statements

User · Answer

Well it depends on how you want to call this code     Are you calling it from a button click on a form  if so then on the properties for the button on form  go to the Event tab  then On Click item  select  Event Procedure   This will open the VBA code window for that button  You would then call your Module Routine and then this would trigger when you click the button   Similar to this   Private Sub Command1426 Click       mdl ExportMorning ExportMorning End Sub   This button click event calls the Module mdl ExportMorning and the Public Sub ExportMorning

[ms-access] How to execute VBA Access module?

Examples related to ms-access

Examples related to vba