Database Sample Code
-
Clearing tables in Access
by Thamar
How to erase the contents of a table in Access
-
Reuse ADO recordsets
by ElementK Journals
How to reuse ADO recordsets without destroying them first
-
How to include Text, nText and Image datatypes in a Union query
by ElementK Journals
How to include Text, nText and Image datatypes in a Union query
-
Syncronise Databases
by Santi Mondejar
Load data between two databases online
-
Parameters in a DAO parameter query
by ElementK Journals
Entering parameters into a DAO parameter query
-
Data-shaped SQL clauses
by ElementK Journals
How to build a data-shaped SQL clause for VB
-
Evaluate string formulas in VB
by ElementK Journals
How to evaluate string formulas in VB
-
Auto Form
by Santi Mondejar
Automatically generate a HTML form from an SQL query
-
Plan for debugging
by ElementK Journals
A few tips on planning in advance debugging in your ASP pages
-
Access, VB and SQL Server wildcard characters
by James Crowley
Important differences between Access, VB and SQL Server wildcard characters
-
Turn off warning messages in MS Office applications
by ElementK Journals
How to programmatically turn off warning messages in MS Office applications when using Office Automation