ProgrammingMSAccess.com

Hot tip: Want more code VBA, VB.NET, ADO, ADO.NET, and T-SQL samples than those that appear below?  Try our Books and Presentations areas for code samples that include commentary describing how they work.

Click a link to jump to the samples you prefer to browse.

VB.NET Code Samples

1. Load a SQL Server database with a SQLCommand object
2. Connect to a SQL Server Database with a  Windows user account
3. Print metadata about SQL Server logins with a SQLDataReader object
4. Invoke Web service to display some nodes from returned XML object
5. Invoke Web service to parse all nodes from returned XML object
6. Visual Basic .NET procedure to read XML file using XmlTextReader
7. Visual Basic .NET proc and class to display a DataReader's output
8. Speed up an app by pre-compiling exceptions
9. Populate a DataSet with a DataAdapter
10. Prints two DataTables from two DataSets
11. Create a DataSet and return its schema information  

T-SQL scripts for SQL Server

1. A Transact-SQL script that demonstrates how to use a server-side cursor to enumerate the tables in a database.
2. A TSQL script for creating a database with tables.
3. A 2005 T-SQL script to create a login based on a certificate
4. A stored proc that deletes any row from a table
5. A pair of T-SQL scripts to create and use parameters and return status values
6. A pair of T-SQL SELECT statements to contrast ranking functions and rank within partitions of data
7. A set of 4 T-SQL scripts to illustrate how to perform join tables
8. A set of 5 T-SQL scripts that show how to use the GROUP BY clause
9. A large collection of T-SQL scripts that demonstrate the use of INSERT, UPDATE, and DELETE statements
10. T-SQL scripts for webcast slide deck on preparing for 70-431 exam

General and SQL Server VBA Scripts

1. A VBA procedure to list all the reports in a remote database file.
2. Three VBA procedures demonstrating basic Array processing techniques.
3. A pair of VBA procedures to assign an ADO recordset as the source for a report.
4. A VBA procedure to create a table with a column check constraint.
5. A VBA procedure to manage contacts in Outlook from an Access project.
6. A VBA utility demonstrating hex arithmetic.
7. A VBA utility for computing the days to next month.
8. A VBA utility for computing the days from first of last month.
9. A VBA procedure using JRO to make a Design Master.
10. A VBA procedure to list all other replicas visible to a replica.
11. A set of VBA procedures to generate a pivot chart
12. VBA procedures to program a conditional format in Access
13. A VBA procedure that demonstrates how to connect a SQLDMO SQLServer object.
14. A VBA procedure that shows how to drop a column from a SQL Server table and replace it with a new column that is a primary key.
15. A VBA procedure to change a SQL Server instance to Windows authentication mode.  Also shows how to stop and restart a SQL Server instance.
16. A pair of VBA procedures demonstrating how to open programmatically an Access project that connects to a SQL Server database.  Uses automation.
17. Two VBA procedures to enumerate the databases on a SQL Server.
18. Two VBA procedures to enumerate the views with their text in a database on a SQL Server.  
19. A pair of VBA event procedures that filter SQL Server data on an Access form.
20. A VBA procedure that uses ADO to open a view from Pubs.
21. A VBA procedure that uses ADO to create a new view in Pubs.
22. A VBA procedure that uses ADO to create and run a stored procedure listing all the tables and views in a .adp file. 

VBA scripts for Web Development

1. A VBA procedure to inventory data access pages.
2. A set of VBA procedures to parse a FrontPage guest book register for an Access table.
3. A VBA sample that shows techniques for managing multiple concurrent Internet Explorer sessions.
4. An ASP script with VBScript to publish selected fields from the authors table in the SQL Server pubs database.