The Access Web - Table Of Contents

A listing of all articles, grouped by sections, that are currently available on the website. Each page is listed only once. To find out about recent updates, please visit the What's New section.

	Bugs
	Date/Time
	Forms
	General
	Modules
	Queries
	Reports
	Resources
	Strings
	Tables
	Updates
	Win32 API

Common Functions like CurrentDB, str$, Mid$ fail to work

Automation Error error messages, unable to change/save/delete a database object.

Cannot Start Data Access Object error message.

Numlock key keeps turning off.

Access minimizes to Windows 95/NT toolbar instead of closing

Database name isn't an index this table: error message

Run-Time Error 429: ActiveX component can't create object.

Solving Access 97 IPFs with /Decompile

Error registering Comcat.dll in registry during Install

Error 3014 - Can't Open Any More Tables

Mailmerge starts new instance of Access

There is no license: Error message

Office SR-1 does not work in Win 98

Report returns more records than query

Access bugs fixed by Office SR-2

Couldn't Find Installable ISAM

Hyperlink with "mailto:" tag opens two windows

Error 53 when calling functions from custom DLL

Compile Error in Hidden Module

Maximum length strings crash Access Security Wizard

Solving VBS Error '800a01ad' on CreateObject in ASP/IIS

Code changes are lost during a recompile of code

TransferDatabase Causes Page Fault If Object Exists.

Undefined Function in Expression (Error 3985)

Form_Resize fires after Form_Close on maximized forms

Database Won't Open

Access 2000: Compile Error in converted database

WebBrowser control: Run-Time error '438'

No read Permissions on "MsysModules2"

Access 2000: Type Mismatch or User Defined Type Not Defined

Access 2000: Can't Open/Convert Access 97 MDEs

Access 2000: Getting additional information

Access 2000: Setup Flags

Access 2000: Formatting MsgBox's with '@'

To Hide Or Not To Hide

Access 97 fails to start after Access 2000 Uninstall

Access 2000- Corrupt VBA Project message during conversion

Access 2000- Using Group by along with NZ results in unreadable characters

How to Install Access 97 and Access 2000 on the Same Computer

Access 2000 ADPs- Memo field corruption

Access 2000- Database password appears to be set

Access 2000- DeleteObject code doesn't work

Calculate Age of a person

Return a date in the future from a given date.

Calculate differences in time

Return Dates in US #mm/dd/yyyy# format

Calculate # of Working Days

Various Date manipulation functions

How to handle midnight in calculations

Time, adding and subtracting time and timesheets

Determining Average Time

How many Sundays between two dates

Use Variables in SQL behind forms

Find out if a form is open

Cycle through controls with common names

Enumerate all controls on a form

Have the form move to the record selected in List/Combo box

Return Strings from Option Groups

Use Multi-Select List boxes as query parameters

Grab what the user has typed in a control (uncommitted value)

Fill Fields automatically on form based on a control's value

Detect new record in a form

Move cursor to the end of text in a textbox

Carry current value of a control to new records

Form doesn't open as Modal even though Modal property is set to true

Suspend code until a popup form is closed

Add item to combo box using OnNotinList event

Disable PgUp/PgDown keys in a form

Determine name of parent form

Resolve #Name error in a form/report

Use ControlTipText to display textbox value

Make a label flash

Delete current record

#Error when the Subform has no records

Cannot ApplyFilter on SubForm

Colors and Continuous forms

Refer to Controls on a tabbed form

Duplicate "Record x of y"

Ask before saving record

Limit content of combo/list boxes

Hide a subform if no records present

Handle/Display images in forms/database

Refer to Form and Subform properties and controls

Create a clock on a form

Determine selected records in datasheet view

Open a form in an external database

Set defaults for Find Dialog Box

Form only allows new records to be entered

OnMouseOver Effect

Control Arrays in Access

Tooltips don't seem to work

Close all open forms and "For Each" syntax

Make Numeric and Date fields respond to Plus or Minus keys

Move and Resize form windows from code

Adding 'All' to a listbox or combobox

Displaying photos in a form

Adding a Search form to a database

Display a dialog box for a specified duration

Changing the Background Color of the Current Record in a Continuous Form

First Control in a Read Only subform retains focus

Callback function for a Multi Column List box

Convert Access databases to Executables

Automatically resize forms to current screen resolution

Access, Office and Year 2000

Determine name of sub/function where error occurred

Prevent Access from closing

Reset Autonumber field in Table

Get path and file name of Current database

Importing Excel spreadsheets from code

Send Fax/Email from Access

Run Word 97 MailMerge

Some Access specifications

Commonly used naming conventions

Why CompactCurrentDatabase doesn't work from code

Learn about the new Access Virus

Run Dos Batch files from Access

Cannot open Access 97 database in previous versions

Automation object doesn't close automatically

DLookup Usage Samples

Use LIKE in queries and code

Inputbox and Password Masks

How to create Shortcuts on Desktop

Duplicate VBA code in Perl using OLE

Generic Name Structures in Access

Troubleshoot conversion to Access 97 problems

Use Autonumbers properly

Connect your database to the web

Runtime command line argument doesn't work

Run wizards from code

Replace the Access splash screen

Reading a drive's Volume Label

Show/Hide database window from code

Email/Export Charts from Access

Jet 4.0 Replication

Who's logged in?

Copy CommandBars and Import/Export Specifications to a new database

Displaying IP Addresses by using an Input mask

What was that password again?

Bits and Bitmasks

Convert Currency ($500) into words (Five Hundred Dollars)

Use variables to call functions

Read Word Document Properties (Author, Last Print Date etc.)

Return a concatenated list of sub-record values

Use SendKeys to open another database

Sample Excel Automation

Run Excel Macros through Automation

Concatenate fields in same table

Check to see if a File or Directory exists

Filter a recordset

Disable Shift key

Domain Aggregate Functions Replacements

Use Class modules to return Dir and File names

Check if an object exists in the database

Conquer RunCommand Constants

VB5 Switchboard Utility

Import Outlook 98 messages

Send Email using CDO/Outlook 98

VB5 Compact Database utility (Access 97)

Maintain a history of changes

References Wizard

Class Builder Wizard

Compile And Save All Modules

PrivDBEngine and Startup Properties

Forms Format Wizard

Bills of Materials

Using WithEvents to get saved filenames

Convert an Access 97 database to Access 95 format

Access 97 Compactor Addin

Code Comment Builder Wizard

Class Information Wizard

TSI Synchronizer

Creating a reference to a Class in a Library database

Transferring Records to Excel with Automation

Specify UserName & Password for new Access instance

Internet Data Transfer Library

Determining who has Word Doc file open

Getting the Decompile and Compact context menu options

VBA Developer's Handbook - Replacement for functions in Chapter 12

Scheduler Utility

Opening a new Word document based on a template through Automation

Determining the number of dimensions for an array

Exporting an Excel worksheet as a CSV file

Spelling number, in many languages (PolyGlot Number Speller)

Rotate Label ActiveX Control

TSI Xpression 9.0

TSI Form-Report to Data Access Page Wizard

File Search and Properties Object

Access 2000- Using DAO code in ADPs

Use a parameter to return all records if Null

Return database object names

Open Parameter queries from code

Have query return highest/lowest value in a field

Use a variable in a field's criteria

Have a query return every nth record in a table

Find Unmatched records between two tables

Find Duplicate key values

Solving problems with Dates in SQL

Create a query that returns Top n records

Create a query that returns Random records

Turn off the default Action query confirmations

Too few parameters, expected n

Simplify action queries in code

Handling floating-point, Currency, and Decimal Datatype in SQL

Finding all X having all required Y

Fixed column name and crosstabs

Continuous sequence, maximum length (stroke)

Quartiles, Percentiles

Getting a related field from a GroupBy (total) query

Merging sequences

Jet-MSDE- DELETE * FROM Table1; Incorrect syntax near '*'

Printout Multiple copies of a report

Print only the current record to a report

Handle reports from a modal form

Show totals at bottom of report

Use Multiselect listbox to limit records in report

Close report automatically if no data found

Handle Null values in fields

Send a report via EMail

Change printers from code

Boxes with variable dimensions

Save a report's output as a PDF file

Open a report in an external database

Printing First and Last Page Numbers for Report Groups

Use a recordset as report's datasource

Bring up Print Dialog from code

Count the Number of Groups on a Report

Printing Page Numbers on multi column report

Displaying timelines on a report

Lines/Graphics not retained in Word/RTF Export

Custom Zoom in Reports

Parse one field's data into multiple fields

Extract characters from a string containing both numbers and characters

Parsing character separated string into individual components

Replace a character with another within one string

Capitalize first character of every word automatically

Convert all text to Upper/Lower case

Increment Numeric portion of a string

Names with Mixed cases

How to find out if a table exists in a database

"Too many fields defined" error message

Referential Integrity between databases

Hide a table in Database Window

Have Autonumber field start from a value different from 1"

How to perform Seek on Linked Tables

Retrieve linked database namepath

Create Hyperlink Field from code

Reconnect linked Access tables from code

Reconnect linked ODBC tables from code

Don't let the Synonym "bug" bite

Relink tables from different datasources

Sub-classing Entities

Creating DSNs from code

Synchronization without Replication

Creating an AutoNumber field from code