Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access is a SQL Server stored procedure. After writing the necessary code, you can programmatically execute even a parameterized SQL Server stored procedure.
1. The video first shows the viewer the SQL Server stored procedure that the code will execute.
2. The video then takes a step-by-step approach to the VBA code necessary to execute the stored procedure.
3. Finally, the video demonstrates how to pass parameters from a VBA subroutine to a SQL Server stored procedure.
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. To get started, learn the basics.