Posted on August 5, 2009, 8:53 pm, by Rhys, under
VBA.
In a previous post I demonstrated how a little bit of VBA code can be used to build some basic user interfaces to deliver data. Continuing on with this the examples here will show how to build some basic user interfaces; Combo box (or drop down list) and a Multi-Select List. Like the previous examples […]
Posted on July 20, 2009, 10:00 am, by Rhys, under
VBA.
I’ve never been a huge fan of VBA but it can be very useful for quickly providing interfaces to your databases. The examples here use Macros in Excel 2007 to execute stored procedures on SQL Server and provide data back to the user. These examples use the AdventureWorks sample database. Execute a Stored Procedure with […]