Welcome

Talks and presentatons

On 6 November 2010 I gave a talk on Integrating Access and
Excel at Office Devcon 2010, in Sydney.

The talk showed how to use Access as a data store for Excel, and
included sections on:

• Using ADO from Excel — an updated version of the articles
  on this site
• Using VBA to create pivot tables based on Access data
• And two short snippets on
  • Drilling down into Excel reports
  • Cleaning up timestamps in CSV files

You can download the presentation and the sample files
here.

Other files

These files don’t fall into the normal category of files on this
site. They will be added to periodically, and you are welcome to
download and use them.

Last updated 09 Mar 2009, 20:45

• Glucose testing for
  diabetics — Provided by Eugene A. Cummings
• Navigation Add-In for
  Excel 2007 — A simple add-in that you may find useful

Latest additions and updates

Here are the latest additions or updates to the site, most recent
at the top of the list:

Last updated 24 May 2013 16:45

• Excel:
  Create an Access database and table with ADOX Updated 6 Oct
  2010
• 
  Word: Importing Excel data into a bookmarked Word document using
  VBA Updated 1 Oct 2010
• Access:
  
  Recovering a corrupted form or report
• Access:
  
  Relinking to a password-protected backend database
• Access:
  
  Dependent combo boxes on a continuous form
• Access:
  
  Rebuilding a corrupt database table
• Access:
  A
  query with a Totals row Updated 11 Nov 2009
• 
  Versions up to 2003
• 
  Access 2007
• Access:
  
  Allowing users to select any item from a dependent combo box
• Access:
  Preventing clashes in a booking system
• Access:
  
  Correcting date formats in exported csv files
• 
  Access: Normalizing a table with repeating fields, using VBA
• 
  Access: Deleting duplicated records
• 
  Tagging duplicates
• 
  Showing only duplicated records
• 
  Deleting duplicates
• 
  Excel: Managing cascading validation lists without hard work
• 
  Access: Tracking data changes in your database
• 
  Excel: Showing which worksheets link to the current sheet
• 
  Excel: Duplicating several worksheets at once
• 
  Access: Keeping track of processes with a log table
• 
  Access: Booting users out of the database
• 
  Access: Why wont my macros run in Access 2007?
• 
  Access: Converting Access macros to VBA code
• 
  Excel: Drilling up or down in an Excel report
• Excel:
  Speed up your code by avoiding loops where possible
• Access: Comparing
  two or more lists
• 
  Access: Documenting query names and SQL
• 
  Access: Documenting query references
• Access:
  Documenting table fields and indexes —
• Excel:
  Creating pivot tables with expanding ranges (3 articles)
• 
  Part1: Using a dynamic range (all versions of Excel)
• 
  Part 2: Using a List (Excel 2003)
• 
  Part 3: Using a Table (Excel 2007)
• 
  Excel: Selecting cells with the Special Cells dialog
• Excel:
  Three ways to merge lists using Excel
• Part
  1: Use a unique key to identify duplicates
• Part 2:
  Create a query to extract the data into another worksheet
• Part 3: Use Advanced Filter to display a unique list of
  items
• 
  Tip: Checking to see if a table exists
• Excel:
  Importing more than 65536 rows into a worksheet
• Access:
  Updating a list in a combo box (4 articles)
• 
  Part 1: Adding items to a value list: Using a callback fuction
• Part 2: Adding
  items to a value list: Using the AddItem method
• 
  Part 3: Adding items to a value list: Manipulating the RowSource as
  a string
• 
  Part 4: Updating the RowSource: Adding a new record to a table