The Access Web

Normal view

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
Bugs

Common Functions like CurrentDB, str$, Mid$ fail to work
http://www.mvps.org/accessfrfr/bugs/bugs0001.htm

Automation Error error messages, unable to change/save/delete a database object.
http://www.mvps.org/accessfrfr/bugs/bugs0002.htm

Cannot Start Data Access Object error message.
http://www.mvps.org/accessfrfr/bugs/bugs0003.htm

Numlock key keeps turning off.
http://www.mvps.org/accessfrfr/bugs/bugs0004.htm

Access minimizes to Windows 95/NT toolbar instead of closing
http://www.mvps.org/accessfrfr/bugs/bugs0005.htm

Database name isn't an index this table: error message
http://www.mvps.org/accessfrfr/bugs/bugs0006.htm

Run-Time Error 429:  ActiveX component can't create object.
http://www.mvps.org/accessfrfr/bugs/bugs0007.htm

Solving Access 97 IPFs with /Decompile
http://www.mvps.org/accessfrfr/bugs/bugs0008.htm

Error registering Comcat.dll in registry during Install
http://www.mvps.org/accessfrfr/bugs/bugs0009.htm

Error 3014 - Can't Open Any More Tables
http://www.mvps.org/accessfrfr/bugs/bugs0010.htm

Mailmerge starts new instance of Access
http://www.mvps.org/accessfrfr/bugs/bugs0011.htm

Bookmark Bug
http://www.mvps.org/accessfrfr/bugs/bugs0012.htm

There is no license: Error message
http://www.mvps.org/accessfrfr/bugs/bugs0013.htm

Office SR-1 does not work in Win 98
http://www.mvps.org/accessfrfr/bugs/bugs0014.htm

Report returns more records than query
http://www.mvps.org/accessfrfr/bugs/bugs0015.htm

Access bugs fixed by Office SR-2
http://www.mvps.org/accessfrfr/bugs/bugs0016.htm

Couldn't Find Installable ISAM
http://www.mvps.org/accessfrfr/bugs/bugs0017.htm

Hyperlink with "mailto:" tag opens two windows
http://www.mvps.org/accessfrfr/bugs/bugs0018.htm

Error 53 when calling functions from custom DLL
http://www.mvps.org/accessfr/bugs/bugs0019.htm

Compile Error in Hidden Module
http://www.mvps.org/accessfr/bugs/bugs0020.htm

Maximum length strings crash Access Security Wizard
http://www.mvps.org/accessfr/bugs/bugs0021.htm

Solving VBS Error '800a01ad' on CreateObject in ASP/IIS
http://www.mvps.org/accessfr/bugs/bugs0022.htm

Code changes are lost during a recompile of code
http://www.mvps.org/accessfr/bugs/bugs0023.htm

TransferDatabase Causes Page Fault If Object Exists.
http://www.mvps.org/accessfr/bugs/bugs0024.htm

Undefined Function in Expression (Error 3985)
http://www.mvps.org/accessfr/bugs/bugs0025.htm

Form_Resize fires after Form_Close on maximized forms
http://www.mvps.org/accessfr/bugs/bugs0026.htm

Database Won't Open
http://www.mvps.org/accessfr/bugs/bugs0027.htm

Access 2000: Compile Error in converted database
http://www.mvps.org/accessfr/bugs/bugs0028.htm

WebBrowser control: Run-Time error '438'
http://www.mvps.org/accessfr/bugs/bugs0029.htm

No read Permissions on "MsysModules2"
http://www.mvps.org/accessfr/bugs/bugs0030.htm

Access 2000: Type Mismatch or User Defined Type Not Defined 
http://www.mvps.org/accessfr/bugs/bugs0031.htm

Access 2000: Can't Open/Convert Access 97 MDEs 
http://www.mvps.org/accessfr/bugs/bugs0032.htm

Access 2000: Getting additional information 
http://www.mvps.org/accessfr/bugs/bugs0033.htm

Access 2000: Setup Flags 
http://www.mvps.org/accessfr/bugs/bugs0034.htm

Access 2000: Formatting MsgBox's with '@' 
http://www.mvps.org/accessfr/bugs/bugs00035.htm

To Hide Or Not To Hide
http://www.mvps.org/accessfr/bugs/bugs0036.htm

Access 97 fails to start after Access 2000 Uninstall
http://www.mvps.org/accessfr/bugs/bugs0037.htm

Access 2000- Corrupt VBA Project message during conversion
http://www.mvps.org/accessfr/bugs/bugs0038.htm

Access 2000- Using Group by along with NZ results in unreadable characters
http://www.mvps.org/accessfr/bugs/bugs0039.htm

How to Install Access 97 and Access 2000 on the Same Computer
http://www.mvps.org/accessfr/bugs/bugs0040.htm

Access 2000 ADPs- Memo field corruption
http://www.mvps.org/accessfr/bugs/bugs0041.htm

Access 2000- Database password appears to be set
http://www.mvps.org/accessfr/bugs/bugs0042.htm

Access 2000- DeleteObject code doesn't work
http://www.mvps.org/accessfr/bugs/bugs0043.htm

 
Date/Time

Calculate Age of a person
http://www.mvps.org/accessfr/datetime/date0001.htm

Return a date in the future from a given date.
http://www.mvps.org/accessfr/datetime/date0003.htm

Calculate differences in time
http://www.mvps.org/accessfr/datetime/date0004.htm

Return Dates in US #mm-dd-yyyy# format
http://www.mvps.org/accessfr/datetime/date005.htm

Calculate # of Working Days
http://www.mvps.org/accessfr/datetime/date0006.htm

Various Date manipulation functions
http://www.mvps.org/accessfr/datetime/date0007.htm

How to handle midnight in calculations
http://www.mvps.org/accessfr/datetime/date0008.htm

Time, adding and subtracting time and timesheets
http://www.mvps.org/accessfr/datetime/date0009.htm

Determining Average Time
http://www.mvps.org/accessfr/datetime/date0010.htm

How many Sundays between two dates
http://www.mvps.org/accessfr/datetime/date0011.htm

Forms

Use Variables in SQL behind forms
http://www.mvps.org/accessfr/forms/frm0001.htm

Find out if a form is open
http://www.mvps.org/accessfr/forms/frm0002.htm

Cycle through controls with common names
http://www.mvps.org/accessfr/forms/frm0003.htm

Enumerate all controls on a form
http://www.mvps.org/accessfr/forms/frm0004.htm

Have the form move to the record selected in List-Combo box
http://www.mvps.org/accessfr/forms/frm0005.htm

Return Strings from Option Groups
http://www.mvps.org/accessfr/forms/frm0006.htm

Use Multi-Select List boxes as query parameters
http://www.mvps.org/accessfr/forms/frm0007.htm

Grab what the user has typed in a control (uncommitted value)
http://www.mvps.org/accessfr/forms/frm0008.htm

Fill Fields automatically on form based on a control's value
http://www.mvps.org/accessfr/forms/frm0009.htm

Detect new record in a form
http://www.mvps.org/accessfr/forms/frm0010.htm

Move cursor to the end of text in a textbox
http://www.mvps.org/accessfr/forms/frm0011.htm

Carry current value of a control to new records
http://www.mvps.org/accessfr/forms/frm0012.htm

Form doesn't open as Modal even though Modal property is set to true
http://www.mvps.org/accessfr/forms/frm0013.htm

Suspend code until a popup form is closed
http://www.mvps.org/accessfr/forms/frm0014.htm

Add item to combo box using OnNotinList event
http://www.mvps.org/accessfr/forms/frm0015.htm

Disable PgUp-PgDown keys in a form
http://www.mvps.org/accessfr/forms/frm0016.htm

Determine name of parent form
http://www.mvps.org/accessfr/forms/frm0017.htm

Resolve #Name error in a form-report
http://www.mvps.org/accessfr/forms/frm0018.htm

Use ControlTipText to display textbox value
http://www.mvps.org/accessfr/forms/frm0019.htm

Make a label flash
http://www.mvps.org/accessfr/forms/frm0020.htm

Delete current record
http://www.mvps.org/accessfr/forms/frm0021.htm

#Error when the Subform has no records
http://www.mvps.org/accessfr/forms/frm0022.htm

Cannot ApplyFilter on SubForm
http://www.mvps.org/accessfr/forms/frm0023.htm

Colors and Continuous forms
http://www.mvps.org/accessfr/forms/frm0024.htm

Refer to Controls on a tabbed form
http://www.mvps.org/accessfr/forms/frm0025.htm

Duplicate "Record x of y"
http://www.mvps.org/accessfr/forms/frm0026.htm

Ask before saving record
http://www.mvps.org/accessfr/forms/frm0027.htm

Limit content of combo-list boxes
http://www.mvps.org/accessfr/forms/frm0028.htm

Hide a subform if no records present
http://www.mvps.org/accessfr/forms/frm0029.htm

Handle-Display images in forms-database
http://www.mvps.org/accessfr/forms/frm0030.htm

Refer to Form and Subform properties and controls
http://www.mvps.org/accessfr/forms/frm0031.htm

Create a clock on a form
http://www.mvps.org/accessfr/forms/frm0032.htm

Determine selected records in datasheet view
http://www.mvps.org/accessfr/forms/frm0033.htm

Open a form in an external database
http://www.mvps.org/accessfr/forms/frm0034.htm

Set defaults for Find Dialog box
http://www.mvps.org/accessfr/forms/frm0035.htm

Form only allows new records to be entered
http://www.mvps.org/accessfr/forms/frm0036.htm

OnMouseOver Effect
http://www.mvps.org/accessfr/forms/frm0037.htm

Control Arrays in Access
http://www.mvps.org/accessfr/forms/frm0038.htm

Tooltips don't seem to work
http://www.mvps.org/accessfr/forms/frm0039.htm

Close all open forms and "For Each" syntax
http://www.mvps.org/accessfr/forms/frm0040.htm

Make Numeric and Date fields respond to Plus or Minus keys
http://www.mvps.org/accessfr/forms/frm0041.htm

Move and Resize form windows from code
http://www.mvps.org/accessfr/forms/frm0042.htm

Adding "All" to a listbox or combobox
http://www.mvps.org/accessfr/forms/frm0043.htm

Displaying photos in a form
http://www.mvps.org/accessfr/forms/frm0044.htm

Adding a Search form to a database
http://www.mvps.org/accessfr/forms/frm0045.htm

Display a dialog box for a specified duration
http://www.mvps.org/accessfr/forms/frm0046.htm

Changing the Background Color of the Current Record in a Continuous Form
http://www.mvps.org/accessfr/forms/frm0047.htm

First Control in a ReadOnly subform retains focus
http://www.mvps.org/accessfr/forms/frm0048.htm

Callback function for a Multi Column List box
http://www.mvps.org/accessfr/forms/frm0049.htm

Mini Calendar
http://www.mvps.org/accessfr/forms/frm0050.htm

General

Convert Access databases to Executables
http://www.mvps.org/accessfr/general/gen0001.htm

Automatically resize forms to current screen resolution
http://www.mvps.org/accessfr/general/gen0002.htm

Access, Office and Year 2000
http://www.mvps.org/accessfr/general/gen0003.htm

Determine name of sub-function where error occurred
http://www.mvps.org/accessfr/general/gen0004.htm

Prevent Access from closing
http://www.mvps.org/accessfr/general/gen0005.htm

Reset Autonumber field in Table
http://www.mvps.org/accessfr/general/gen0006.htm

Path and Folder location for databases
http://www.mvps.org/accessfr/general/gen0007.htm

Importing Excel spreadsheets from code
http://www.mvps.org/accessfr/general/gen0008.htm

Send Fax-Email from Access
http://www.mvps.org/accessfr/general/gen0009.htm

Run Word 97 MailMerge
http://www.mvps.org/accessfr/general/gen0010.htm

Some Access specifications
http://www.mvps.org/accessfr/general/gen0011.htm

Commonly used naming conventions
http://www.mvps.org/accessfr/general/gen0012.htm

Why CompactCurrentDatabase doesn't work from code
http://www.mvps.org/accessfr/general/gen0013.htm

Learn about the new Access Virus
http://www.mvps.org/accessfr/general/gen0014.htm

Run Dos Batch files from Access
http://www.mvps.org/accessfr/general/gen0015.htm

Cannot open Access 97 database in previous versions
http://www.mvps.org/accessfr/general/gen0016.htm

Automation object doesn't close automatically
http://www.mvps.org/accessfr/general/gen0017.htm

DLookup Usage Samples
http://www.mvps.org/accessfr/general/gen0018.htm

Use LIKE in queries and code
http://www.mvps.org/accessfr/general/gen0019.htm

Inputbox and Password Masks
http://www.mvps.org/accessfr/general/gen0020.htm

How to create Shortcuts on Desktop
http://www.mvps.org/accessfr/general/gen0021.htm

Duplicate VBA code in Perl using OLE
http://www.mvps.org/accessfr/general/gen0022.htm

Generic Name Structures in Access
http://www.mvps.org/accessfr/general/gen0023.htm

Troubleshoot conversion to Access 97 problems
http://www.mvps.org/accessfr/general/gen0024.htm

Use Autonumbers properly
http://www.mvps.org/accessfr/general/gen0025.htm

Connect your database to the web
http://www.mvps.org/accessfr/general/gen0026.htm

Runtime command line argument doesn't work
http://www.mvps.org/accessfr/general/gen0027.htm

Run wizards from code
http://www.mvps.org/accessfr/general/gen0028.htm

Replace the Access splash screen
http://www.mvps.org/accessfr/general/gen0029.htm

Reading a drive's Volume Label
http://www.mvps.org/accessfr/general/gen0030.htm

Show/Hide database window from code
http://www.mvps.org/accessfr/general/gen0031.htm

Email/Export Charts from Access
http://www.mvps.org/accessfr/general/gen0032.htm

Jet 4.0 Replication
http://www.mvps.org/accessfr/general/gen0033.htm

Who's logged in?
http://www.mvps.org/accessfr/general/gen0034.htm

Copy CommandBars and Import/Export Specifications to a new database
http://www.mvps.org/accessfr/general/gen0035.htm

Displaying IP Addresses by using an Input mask
http://www.mvps.org/accessfr/general/gen0036.htm

What was that password again?
http://www.mvps.org/accessfr/general/gen0037.htm

Bits and Bitmasks
http://www.mvps.org/accessfr/general/gen0038.htm

Modules

Convert Currency ($500) into words (Five Hundred Dollars)
http://www.mvps.org/accessfr/modules/mdl0001.htm

Use variables to call functions
http://www.mvps.org/accessfr/modules/mdl0002.htm

Read Word Document Properties (Author, Last Print Date etc.)
http://www.mvps.org/accessfr/modules/mdl0003.htm

Return a concatenated list of sub-record values
http://www.mvps.org/accessfr/modules/mdl0004.htm

Use SendKeys to open another database
http://www.mvps.org/accessfr/modules/mdl0005.htm

Sample Excel Automation
http://www.mvps.org/accessfr/modules/mdl0006.htm

Run Excel Macros through Automation
http://www.mvps.org/accessfr/modules/mdl0007.htm

Concatenate fields in same table
http://www.mvps.org/accessfr/modules/mdl0008.htm

Check to see if a File or Directory exists
http://www.mvps.org/accessfr/modules/mdl0009.htm

Filter a recordset
http://www.mvps.org/accessfr/modules/mdl0010.htm

Disable Shift key
http://www.mvps.org/accessfr/modules/mdl0011.htm

Domain Aggregate Functions Replacements
http://www.mvps.org/accessfr/modules/mdl0012.htm

Use Class modules to return Dir and File names
http://www.mvps.org/accessfr/modules/mdl0013.htm

Check if an object exists in the database
http://www.mvps.org/accessfr/modules/mdl0014.htm

Use FTP
http://www.mvps.org/accessfr/modules/mdl0015.htm

Conquer RunCommand Constants
http://www.mvps.org/accessfr/modules/mdl0016.htm

VB Switchboard Utility
http://www.mvps.org/accessfr/modules/mdl0017.htm

Import Outlook 98 messages
http://www.mvps.org/accessfr/modules/mdl0018.htm

Send Email using CDO-Outlook 98
http://www.mvps.org/accessfr/modules/mdl0019.htm

VB5 Compact Database utility (Access 97)
http://www.mvps.org/accessfr/modules/mdl0020.htm

Maintain a history of changes
http://www.mvps.org/accessfr/modules/mdl0021.htm

References Wizard
http://www.mvps.org/accessfr/modules/mdl0022.htm

Class Builder Wizard
http://www.mvps.org/accessfr/modules/mdl0023.htm

Compile Project
http://www.mvps.org/accessfr/modules/mdl0024.htm

PrivDBEngine and Startup Properties
http://www.mvps.org/accessfr/modules/mod0025.htm

Forms Wizard
http://www.mvps.org/accessfr/modules/mdl0026.htm

Bill Of Materials
http://www.mvps.org/accessfr/modules/mdl0027.htm

Using WithEvents to get saved filenames
http://www.mvps.org/accessfr/modules/mdl0028.htm

Convert an Access 97 database to Access 95 format
http://www.mvps.org/accessfr/modules/mdl0029.htm

Access 97 Compactor MDB
http://www.mvps.org/accessfr/modules/mdl0030.htm

Code Comment Builder Wizard
http://www.mvps.org/accessfr/modules/mdl0031.htm

Class Information Wizard
http://www.mvps.org/accessfr/modules/mdl0032.htm

TSI Synchronizer
http://www.mvps.org/accessfr/modules/mdl0033.htm

Creating a reference to a Class in a Library database
http://www.mvps.org/accessfr/modules/mdl0034.htm

Transferring Records to Excel with Automation
http://www.mvps.org/accessfr/modules/mdl0035.htm

Specify UserName & Password for new Access instance
http://www.mvps.org/accessfr/modules/mdl0036.htm

Internet Data Transfer Library
http://www.mvps.org/accessfr/modules/mdl0037.htm

Internet Data Transfer Library
http://www.mvps.org/accessfr/modules/mdl0038.htm

Getting the Decompile and Compact context menu options
http://www.mvps.org/accessfr/modules/mdl0039.htm

CodeWriter 2.0
http://www.mvps.org/accessfr/modules/mdl0040.htm

VBA Developer's Handbook - Replacement for functions in Chapter 12
http://www.mvps.org/accessfr/modules/mdl0041.htm

Scheduler Utility
http://www.mvps.org/accessfr/modules/mdl0042.htm

Opening a new Word document based on a template through Automation
http://www.mvps.org/accessfr/modules/mdl0043.htm

Determining the number of dimensions for an array
http://www.mvps.org/accessfr/modules/mdl0044.htm

Backup Wizard
http://www.mvps.org/accessfr/modules/mdl0045.htm

Exporting an Excel worksheet as a CSV file
http://www.mvps.org/accessfr/modules/mdl0046.htm

Spelling number, in many languages (PolyGlot Number Speller)
http://www.mvps.org/accessfr/modules/mdl0047.htm

Rotate Label ActiveX Control
http://www.mvps.org/accessfr/modules/mdl0048.htm

TSI Xpression 9.0
http://www.mvps.org/accessfr/modules/mdl0049.htm

TSI Form-Report to Data Access Page Wizard
http://www.mvps.org/accessfr/modules/mdl0050.htm

File Search and Properties Object
http://www.mvps.org/accessfr/modules/mdl0051.htm

Access 2000- Using DAO code in ADPs
http://www.mvps.org/accessfr/modules/mdl0052.htm

Queries

Use a parameter to return all records if Null
http://www.mvps.org/accessfr/queries/qry0001.htm

Return database object names
http://www.mvps.org/accessfr/queries/qry0002.htm

Open Parameter queries from code
http://www.mvps.org/accessfr/queries/qry0003.htm

Have query return highest-lowest value in a field
http://www.mvps.org/accessfr/queries/qry0004.htm

Use a variable in a field's criteria
http://www.mvps.org/accessfr/queries/qry0005.htm

Have a query return every nth record in a table
http://www.mvps.org/accessfr/queries/qry0006.htm

Find Unmatched records between two tables
http://www.mvps.org/accessfr/queries/qry0007.htm

Find Duplicate key values
http://www.mvps.org/accessfr/queries/qry0008.htm

Solving problems with Dates in SQL
http://www.mvps.org/accessfr/queries/qry0009.htm

Create a query that returns Top n records
http://www.mvps.org/accessfr/queries/qry0010.htm

Create a query that returns Random records
http://www.mvps.org/accessfr/queries/qry0011.htm

Turn off the default Action query confirmations
http://www.mvps.org/accessfr/queries/qry0012.htm

Too few parameters, expected n
http://www.mvps.org/accessfr/queries/qry0013.htm

Simplify action queries in code
http://www.mvps.org/accessfr/queries/qry0014.htm

Handling floating-point, Currency, and Decimal Datatype in SQL
http://www.mvps.org/accessfr/queries/qry0015.htm

Finding all X having all required Y
http://www.mvps.org/accessfr/queries/qry0016.htm

Fixed column name and crosstabs
http://www.mvps.org/accessfr/queries/qry0017.htm

Continuous sequence, maximum length (stroke)
http://www.mvps.org/accessfr/queries/qry0018.htm

Quartiles, Percentiles
http://www.mvps.org/accessfr/queries/qry0019.htm

Getting a related field from a GroupBy (total) query
http://www.mvps.org/accessfr/queries/qry0020.htm

Merging sequences
http://www.mvps.org/accessfr/queries/qry0021.htm

Jet-MSDE- DELETE * FROM Table1; Incorrect syntax near '*'
http://www.mvps.org/accessfr/queries/qry0022.htm

Reports

Printout Multiple copies of a report
http://www.mvps.org/accessfr/reports/rpt0001.htm

Print only the current record to a report
http://www.mvps.org/accessfr/reports/rpt0002.htm

Handle reports from a modal form
http://www.mvps.org/accessfr/reports/rpt0003.htm

Show totals at bottom of report
http://www.mvps.org/accessfr/reports/rpt0004.htm

Use Multiselect listbox to limit records in report
http://www.mvps.org/accessfr/reports/rpt0005.htm

Close report automatically if no data found
http://www.mvps.org/accessfr/reports/rpt0006.htm

Handle Null values in fields
http://www.mvps.org/accessfr/reports/rpt0007.htm

Send a report via EMail
http://www.mvps.org/accessfr/reports/rpt0008.htm

Change printers from code
http://www.mvps.org/accessfr/reports/rpt0009.htm

Variable Grow Box Report
http://www.mvps.org/accessfr/reports/rpt0010.htm

Save a report's output as a PDF file
http://www.mvps.org/accessfr/reports/rpt0011.htm

Open a report in an external database
http://www.mvps.org/accessfr/reports/rpt0012.htm

Printing First and Last Page Numbers for Report Groups
http://www.mvps.org/accessfr/reports/rpt0013.htm

Use a recordset as report's datasource
http://www.mvps.org/accessfr/reports/rpt0014.htm

Bring up Print Dialog from code
http://www.mvps.org/accessfr/reports/rpt0015.htm

Count the Number of Groups on a Report
http://www.mvps.org/accessfr/reports/rpt0016.htm

Printing Page Numbers on multi column report
http://www.mvps.org/accessfr/reports/rpt0017.htm

Displaying timelines on a report
http://www.mvps.org/accessfr/reports/rpt0018.htm

Lines-Graphics not retained in Word-RTF Export
http://www.mvps.org/accessfr/reports/rpt0019.htm

Custom Zoom in Reports
http://www.mvps.org/accessfr/reports/rpt0020.htm

Resources

The Access Web Links - Recommended Reading
http://www.mvps.org/accessfr/resources/books.htm

The Access Web - Downloads
http://www.mvps.org/accessfr/resources/downloads.htm

The Access Web Links - General
http://www.mvps.org/accessfr/resources/general.htm

The Access Web Links - Mirrors
http://www.mvps.org/accessfr/resources/mirrors.htm

Newsgroups
http://www.mvps.org/accessfr/resources/ngs.htm

The Access Web Links - Other Access sites around the world
http://www.mvps.org/accessfr/resources/othersites.htm

The Access Web Links - Patches and Fixes
http://www.mvps.org/accessfr/resources/patches.htm

The Access Web Links - Access Products
http://www.mvps.org/accessfr/resources/products.htm

The Access Web Links - Technical Papers
http://www.mvps.org/accessfr/resources/techpapers.htm

The Access Web Links - Utilities
http://www.mvps.org/accessfr/resources/utils.htm

The Access Web Links - VB Links
http://www.mvps.org/accessfr/resources/vb.htm

Strings

Parse one field's data into multiple fields
http://www.mvps.org/accessfr/strings/str0001.htm

Extract characters from a string containing both numbers and characters
http://www.mvps.org/accessfr/strings/str0002.htm

Parsing character separated string into individual components
http://www.mvps.org/accessfr/strings/str0003.htm

Replace a character with another within one string
http://www.mvps.org/accessfr/strings/str0004.htm

Capitalize first character of every word automatically
http://www.mvps.org/accessfr/strings/str0005.htm

Convert all text to Upper-Lower case
http://www.mvps.org/accessfr/strings/str0006.htm

Increment Numeric portion of a string
http://www.mvps.org/accessfr/strings/str0007.htm

Names with Mixed cases
http://www.mvps.org/accessfr/strings/str0008.htm

Tables

How to find out if a table exists in a database
http://www.mvps.org/accessfr/tables/tbl0001.htm

"Too many fields defined" error message
http://www.mvps.org/accessfr/tables/tbl0002.htm

Referential Integrity between databases
http://www.mvps.org/accessfr/tables/tbl0003.htm

Hide a table in Database Window
http://www.mvps.org/accessfr/tables/tbl004.htm

Have Autonumber field start from a value different from 1
http://www.mvps.org/accessfr/tables/tbl0005.htm

How to perform Seek on Linked Tables
http://www.mvps.org/accessfr/tables/tbl0006.htm

Retrieve linked database namepath
http://www.mvps.org/accessfr/tables/tbl0007.htm

Create Hyperlink Field from code
http://www.mvps.org/accessfr/tables/tbl0008.htm

Relink Access tables from code
http://www.mvps.org/accessfr/tables/tbl0009.htm

Relink ODBC tables from code
http://www.mvps.org/accessfr/tables/tbl0010.htm

Oracle Synonyms
http://www.mvps.org/accessfr/tables/tbl0011.htm

Relink tables from different datasources
http://www.mvps.org/accessfr/tables/tbl0012.htm

Sub-classing Entities
http://www.mvps.org/accessfr/tables/tbl0013.htm

Creating DSNs from code
http://www.mvps.org/accessfr/tables/tbl0014.htm

Synchronization without Replication
http://www.mvps.org/accessfr/tables/tbl0015.htm

Creating an AutoNumber field from code
http://www.mvps.org/accessfr/tables/tbl0016.htm

Updates

July 10th, 1999
http://www.mvps.org/accessfr/updates/u_current.htm

June 7th, 1999
http://www.mvps.org/accessfr/updates/u_jun799.htm

April 6th, 1999
http://www.mvps.org/accessfr/updates/u_apr699.htm

March 15th, 1999
http://www.mvps.org/accessfr/updates/u_mar1599.htm

March 13th, 1999
http://www.mvps.org/accessfr/updates/u_mar1399.htm

March 6th, 1999
http://www.mvps.org/accessfr/updates/u_mar699.htm

February 15, 1999
http://www.mvps.org/accessfr/updates/u_feb1599.htm

January 26th, 1999
http://www.mvps.org/accessfr/updates/u_jan2699.htm

December 11th, 1998
http://www.mvps.org/accessfr/updates/u_dec1198.htm

November 6th, 1998
http://www.mvps.org/accessfr/updates/u_nov698.htm

November 4th, 1998
http://www.mvps.org/accessfr/updates/u_nov498.htm

September 27th, 1998
http://www.mvps.org/accessfr/updates/u_sep2798.htm

September 9th, 1998
http://www.mvps.org/accessfr/updates/u_sep998.htm

August 27th, 1998
http://www.mvps.org/accessfr/updates/u_aug2798.htm

August 17th, 1998
http://www.mvps.org/accessfr/updates/u_aug1798.htm

July 15th, 1998
http://www.mvps.org/accessfr/updates/u_jul1598.htm

June 23rd, 1998
http://www.mvps.org/accessfr/updates/u_jun2398.htm

June 4th, 1998
http://www.mvps.org/accessfr/updates/u_jun498.htm

May 22nd, 1998
http://www.mvps.org/accessfr/updates/u_may2298.htm

May 8th, 1998
http://www.mvps.org/accessfr/updates/u_may898.htm

May 1st, 1998
http://www.mvps.org/accessfr/updates/u_may198.htm

April 26th, 1998
http://www.mvps.org/accessfr/updates/u_apr2698.htm

April 16th, 1998
http://www.mvps.org/accessfr/updates/u_ap1698.htm

March 29th, 1998
http://www.mvps.org/accessfr/updates/u_mar2998.htm

March 9th, 1998
http://www.mvps.org/accessfr/updates/u_mar998.htm

February 15th, 1998
http://www.mvps.org/accessfr/updates/u_feb1598.htm

Win32 API

Call Windows File Open/Save Dialog box
http://www.mvps.org/accessfr/api/api0001.htm

Call Windows Browse for Folder Dialog box
http://www.mvps.org/accessfr/api/api0002.htm

Get Local Drives and UNC Path of network drives
http://www.mvps.org/accessfr/api/api0003.htm

Have Access pause until Shelled process has finished
http://www.mvps.org/accessfr/api/api0004.htm

Retrieve Unique Filenames for mass export
http://www.mvps.org/accessfr/api/api0005.htm

Search for a file
http://www.mvps.org/accessfr/api/api0006.htm

Find out if an application is currently running
http://www.mvps.org/accessfr/api/api0007.htm

Network User Name
http://www.mvps.org/accessfr/api/api0008.htm

Current Computer Name
http://www.mvps.org/accessfr/api/api0009.htm

Retrieve Windows/System/Temp Directories
http://www.mvps.org/accessfr/api/api0010.htm

How to play WAV/MIDI/AVI files
http://www.mvps.org/accessfr/api/api0011.htm

Use GetSystemMetrics to return System specific information
http://www.mvps.org/accessfr/api/api0012.htm

Find class names of a running application
http://www.mvps.org/accessfr/api/api0013.htm

Create/return a unique temp file
http://www.mvps.org/accessfr/api/api0014.htm

Read a Value from Registry
http://www.mvps.org/accessfr/api/api0015.htm

How do I quit Windows from Access?
http://www.mvps.org/accessfr/api/api0016.htm

How to retrieve information about a specific Locale
http://www.mvps.org/accessfr/api/api0017.htm

Start Registered applications with ShellExecute
http://www.mvps.org/accessfr/api/api0018.htm

Manipulate Access Window
http://www.mvps.org/accessfr/api/api0019.htm

Return Long or Short Filenames
http://www.mvps.org/accessfr/api/api0020.htm

Make it "Sleep"
http://www.mvps.org/accessfr/api/api0021.htm

Disable Close button on maximized form
http://www.mvps.org/accessfr/api/api0022.htm

Retrieve executable's filename and path
http://www.mvps.org/accessfr/api/api0023.htm

Daylight Savings Time & PreciseDateDiff
http://www.mvps.org/accessfr/api/api0024.htm

Close another Application
http://www.mvps.org/accessfr/api/api0025.htm

Copy a database
http://www.mvps.org/accessfr/api/api0026.htm

hWnd of Controls
http://www.mvps.org/accessfr/api/api0027.htm

Change cursor while editing
http://www.mvps.org/accessfr/api/api0028.htm

Detect Available Resolutions
http://www.mvps.org/accessfr/api/api0029.htm

Interrupt running code
http://www.mvps.org/accessfr/api/api0030.htm

AddressOf
http://www.mvps.org/accessfr/api/api0031.htm

Drag and Drop from Explorer
http://www.mvps.org/accessfr/api/api0032.htm

Enumerating System Fonts
http://www.mvps.org/accessfr/api/api0033.htm

Detect Application Activate/Deactivate
http://www.mvps.org/accessfr/api/api0034.htm

Put an image in Access window
http://www.mvps.org/accessfr/api/api0035.htm

Track IntelliMouse's wheel
http://www.mvps.org/accessfr/api/api0036.htm

Suppress the "Printing" Dialog
http://www.mvps.org/accessfr/api/api0037.htm

Suppress the "Loading Image" dialog
http://www.mvps.org/accessfr/api/api0038.htm

Retrieve NT Server's Time
http://www.mvps.org/accessfr/api/api0039.htm

Retrieve Current User's NT Domain
http://www.mvps.org/accessfr/api/api0040.htm

Preventing Multiple Instances of a database
http://www.mvps.org/accessfr/api/api0041.htm

Copy an image to the Clipboard
http://www.mvps.org/accessfr/api/api0042.htm

Put a custom icon in the form's caption bar
http://www.mvps.org/accessfr/api/api0043.htm

Displaying a custom Mouse icon
http://www.mvps.org/accessfr/api/api0044.htm

Subclassing form for SysTray functionality
http://www.mvps.org/accessfr/api/api0045.htm

Replacement for Sendkeys
http://www.mvps.org/accessfr/api/api0046.htm

Enabling Full Row Select in a ListView
http://www.mvps.org/accessfr/api/api0047.htm

Enabling Full Row Select in a Treeview
http://www.mvps.org/accessfr/api/api0048.htm

Copy variables/control contents to memory
http://www.mvps.org/accessfr/api/api0049.htm

Rotate Text
http://www.mvps.org/accessfr/api/api0050.htm

Read/Set Internet Explorer URL from code
http://www.mvps.org/accessfr/api/api0051.htm

Determining Combobox's Dropped state
http://www.mvps.org/accessfr/api/api0052.htm

Drawing images on an Access form
http://www.mvps.org/accessfr/api/api0053.htm

Retrieving a Special Folder's location
http://www.mvps.org/accessfr/api/api0054.htm

Retrieving Operating System Name
http://www.mvps.org/accessfr/api/api0055.htm

Changing button captions in GetOpenFileName dialog
http://www.mvps.org/accessfr/api/api0056.htm

Removing Min-Max-Close buttons from a report's Preview Window
http://www.mvps.org/accessfr/api/api0057.htm