| ||||||||||||
|
How To Open Email Using SendObject Access Example Download Send Email Access Sample Download (Advanced) Programming MS Access Security Alternative Inventory Calculations Down Load ( Single User) How To Perform Inventory Calculations (Multi-User) Make Dependent Combo Box Code Access Database Download How To Fill Fields From Combo Box Use Global Variables as Parameters Download Continuous Form Dependent Combo Box How To Program Continuous-Continuous Master/Detail Forms Download Example for Bar Chart/ Bar Graph on Access Forms Programming Crosstab Query Example TransferText & OutputTo Examples DoCmd.OpenForm & OpenArgs VBA Example |
Visual Basic Global Variables as Query Parameters
Using global variables to pass user selection criteria to queries is a useful
programming technique to master.
This Access download will provide you with all the forms, modules, queries and VBA code to get you started. Here is the SQL query code used in the example:
SELECT M_Student_Courses.Student_ID, L_Students.Student, L_Courses.Course In the code above, get_global is a function that passes back the value of any global variable you have defined. In this case we are retrieving the GBL_Student_ID which was previously selected as a parameter in the form below. There are other methods for returning global variables, such as the Eval function, however we find this custom method more reliable and flexible.
Give our
Global Variables as Query
Parameters downloadable Access example a try.
|
|
|
Access Database Examples • Microsoft Access Templates • MS Access Tutorials |