DataWright Information Services

Consulting and Resources for Excel and Access

DataWright Information Services

Navigation add-in for Excel 2007 Download it here: Notes: This file is a demonstration of an Excel 2007 Add-In that creates a very basic Navigation tab. On that tab is a drop-down list that repopulates when you click it, generating a list of worksheets in the active workbook . Selecting an item in the drop-down […]

Tracking data changes in Access

Tracking data changes in Access There are situations where you want to be able to track changes to records in a multi-user database. This page contains articles covering two options: storing when a record was changed and by whom; and storing the old value of a field before it changed. The first option only keeps […]

Why won’t my macro run in Access 2007? — DataWright Information Services

Why do some macros not run in Access 2007? Access 2007 has a number of new features that enhance macros. This gives you more flexibility and allows you to create an Access application that will work even if VBA has been disabled. However, not all macro commands are created equal and, in the interests of […]

Selection with VBA — DataWright Information Services

Several ways to make selections using VBA To work effectively with Excel, you need to be able to refer to the workbook, sheet, or range of interest. If you use the macro recorder as a learning tool, you will think that you need to select everything before you manipulate it. That is not the case. […]

Access Tips — DataWright Information Services

Tips for using Access This is a collection of tips that don’t warrant a whole page to themselves, but could make your life easier. General hints and tips Creating code for an event Creating an MDE file from your database Booting users out of a multi-user database — Updated 31 Jan 2009 Calculate Working Days […]

Logging users in your database

Finding out who is using your database If you have multiple users in your database, you often need to know who is in the database when it comes time to do some maintenance. If you have set up user-level security, it’s possible to get that information with the Jet User Roster, which reads the contents […]

Access Resources — DataWright Information Services

Access Resources This is a page of resources that we hope you will use and enjoy. The resources will be added to over time, so please come back to check for new pages. You are welcome to use the samples from this site, as long as you cite this site as the source. If you […]

Using combo boxes in Access, Part 1 — DataWright Information Services

Using combo boxes Combo and list boxes are among the most powerful and versatile controls in Access. They allow you to control data entry by limiting the options to existing items, but you can do much more than that. The articles on this page will demonstrate some of the things you can do with combo […]