Access code

 
 

Start

Access hints

Links

Forum

Business

Company

Here are some useful samples of code aimed primarily to Access97. Today these problems are covered by standard functions inside Access in newer releases.

Documentation of Access-tables.
The package for documenting the object in JET, i.e. tables and queries, is too detailed and does not cover some of the propeties of most interests. Here is a simple Add-in, which in a comprehensive way details the most relevant properties: Fieldname, Description, Caption, Length and Data type.

TabControl to Access 95 
One of the more popular tab control these days, the one supplied with Access 97 is much better.

Calendar for date fields.
Here is a sample to facilitate data entry for date fields. It is a little form called Cal which you Activate with a double click. It contains week number which seems impossible for Yankees to understand is sometimes useful.

File dialog for pointing to a file
This sample shows how to use comdlg32.ocx to give the user a nicer way of specifying a path and file name. Be aware of DLL-hell problems with this OCX.
Today we prefer to use the solution presented on the Access Web.