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.
Video Steps
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.
OMG, Alison Balter. I took a couple VB courses of hers in the early 1990s. She is awesome, a really great teacher. I still have her Access 97 book which is my absolute favorite tech book ever, and very, very dog eared.
I'm now doing hard core SQL Server and Excel/Access VBA, and I can thank her for really getting me going in this arena so many years ago....
Thank you for your kind words. I really appreciate you taking the time to place your comments. I am glad that I had a positive impact on your programming career. It is awesome that you are doing such wonderful things with your career!
Not just Doug , there is 1000's of us who broke the back of programming with your books. as the saying goes "Give a man a fish, you feed him for a day, teach him how to fish an you feed him for life".
I wrote this article because I was unable to find an article on this here on EE. Read on for step-by-step instructions on how to create a custom command ribbon in your office applications that not only make them look more professional but also prot…