Consulting and Resources for Excel and Access
Welcome
Welcome to this site. We have put together a number of resources for Access and Excel, which we hope you will find useful.
Update 21 September 2012: As I have now taken up a full-time job, I am not taking on any new consulting work but I continue to support existing clients. I have also started a blog where new articles will be posted. Because the articles on this site have been in the search engines for a while I will keep the site going as an archive. Hope to see you at the new site!
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.
Last updated 24 May 2013 16:45
Last updated 24 May 2013 16:45
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
If you would like us to assist you with any of the ideas on this site or to provide an obligation-free quote, please contact us to arrange a meeting.
