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 found that a simple "Welcome" screen/form added to a database makes it both more friendly and easier to use. Here is how I added one to a Microsoft Access database.
Please see the important note at the bottom of this article regarding compati…
Not too long ago I wrote this article on doing the same thing in MS Access (https://www.experts-exchange.com/articles/38421/Making-your-Database-More-User-Friendly.html). I found that a similar "Welcome" screen makes Excel worksheets "friendlier" a…