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".
Windows Explorer lets you open archive (tar and tgz) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.
A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html). I have realized that my coworkers primarily use Excel and So have changed the ar…