{ MS Access }
Creating a primary key in MS Access via SQL
The following code will create a primary key in MS Access
Export a Comma-Delimited Text File
Here's how you can get a CSV file out of your Access DB:
How to create labels (print x of x) from a report.
Need to print labels for each carton you've input into an Access database? Just loop through the records like this:
(Note that SumOfPC will be a calculated field from the SQL you are using to create the report)
Loop through the errors collection
This simple bit of code will give you the "real" errors from the error collection. Very helpful for debugging!
Rename a Field from VBA
This example shows you how to rename Fields in Access.
- Tested in Access 97, but should work in Access 2000, XP, + ...
To start this example, do the following:
1. Create a new Access database.
2. Add new table and save it as Table1
3. Create a fiel...