Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
10 Commandments 

In Memoriam

Terms of Use

VB Petition

General: Index of Articles

Convert Access databases to Executables

Available alternatives to creating mdb exes (not possible)

Automatically resize forms to current screen resolution

Dynamically resize forms and controls at runtime to match the users settings for screen resolution

Access, Office and Year 2000

How does the Year 2000 issue affect Access and Office

Determine name of sub/function where error occurred

How to determine at runtime, the function where the error was generated, or walking the call stack

Prevent Access from closing

Simple, clean, and user friendly way of allowing Access to close only if certain criteria are met

Reset Autonumber field in Table

How to reset an Autonumber field so that it starts from zero again

Get path and file name of Current database

Retrieve just the file name or the full path to the database currently open in Access

Importing Excel spreadsheets from code

Syntax for importing specific sheets or ranges from Excel files through TransferSpreadSheet method

Send Fax/Email from Access

Built in and third party solutions to add faxing and emailing capabilities to a database

Run Word 97 MailMerge

Use Automation to start Word and fire off a mailmerge sequence

Some Access specifications

The "limits" of Access

Commonly used naming conventions

Leszynski/Reddick Guidelines for naming conventions in Access

Why CompactCurrentDatabase doesn't work from code

How to compact and automatically reopen the current database 

Learn about the new Access Virus

How does the virus affect a database

Run Dos Batch files from Access

How to shell out to a batch file from VBA

Cannot open Access 97 database in previous versions

No Access version, so far, has been backwards compatible

Automation object doesn't close automatically

Setting an automation object to Nothing does not guarantee that the object will be automatically terminated

DLookup Usage Samples

Syntax for looking up various data types via the Domain functions

Use LIKE in queries and code

Syntax for using the LIKE predicate in SQL

Inputbox and Password Masks

InputBox's cannot carry the password mask (not easily anyway)

How to create Shortcuts on Desktop

VBA does not support creating shortcuts

Duplicate VBA code in Perl using OLE

An automation sample done in Perl

Generic Name Structures in Access

How to use a generic name structure to store names of individuals, employees, companies, organizations etc.

Troubleshoot conversion to Access 97 problems

Conversion TroubleShooter provided by Microsoft PSS

Use Autonumbers properly

What can Autonumbers be used for, and what should you expect from them

Connect your database to the web

How to connect your database to the web via ODBC/IDC

Runtime command line argument doesn't work

An Access database cannot be thrown in runtime mode in a full installation without the mso97rt.dll

Run wizards from code

How to call various Access wizards from code

Replace the Access splash screen

How to display a customized splash screen when Access is launched

Reading a drive's Volume Label

Use Dir function to read a drive's volume label

Show/Hide database window from code

How to show and hide the database container window from code

Email/Export Charts from Access

How to export a Graph 97 chart from Access so that the image can be emailed

Jet 4.0 Replication

Compelling reasons to use Replication in Jet 4

Who's logged in?

Determine which users are currently logged into the database

Copy CommandBars and Import/Export Specifications to a new database

How to copy the system tables to a new database

Displaying IP Addresses by using an Input mask

Use an Input Mask to format IP addresses

What was that password again?

Programmatically retrieve a database's password

Bits and Bitmasks

How to use Bitmasks to handle multiple flags

Access 2000: Hiding Replace Tab in Find/Replace Dialog

How to hide the Replace tab in the new Find-Replace dialog

Securing AllowBypassKey

Running the AllowBypassKey sample from Help without specifying the DDL flag still leaves a hole open

Access 2000 - 2002: Compact the Current Database

Compact the current database from a command button


1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer