Home — DataWright Information Services
resources for Excel and Access
How to create bookings and avoid clashes
Creating bookings while avoiding clashes This sample was created in response to a question on MrExcel.com. It demonstrates a way to assign timeslots in a booking form, and avoid clashes. The database is in mdb format and can be downloaded here (28,234 bytes) If you’re ever called upon to make a booking system, one component […]
Creating a Log table in Access — DataWright Information Services
Creating a log table If your database runs a regular process with multiple steps, and you want to be able to track when the process was run, you need a log to serve as an audit trail. By adding a timestamp field to the log, you can work out which steps are slowing you down […]
Contact — DataWright Information Services
Contacting DataWright Mailing Address Email Address Copyright © 1997-2010 All Rights Reserved. Home | About | Links | Contact | Excel | Access
Documenting tables — DataWright Information Services
Documenting tables in an Access database Recently I published an article on documenting queries in your database. This article will help you to document your table fields and indexes. There are six functions used in this tutorial; two each to create and populate the documenter tables, one to control them, and a utility function to […]
Diabetes log file
Diabetes log file This file was created by Eugene A. Cummings to help diabetics monitor their blood glucose control. It contains a worksheet for each week of the year. It is being hosted here to make it available to as many people as possible. Please download the Excel file here. Copyright © 1997-2010 All Rights […]
Update a Word file by pulling Excel data into bookmarks — DataWright Information Services
Refreshing Excel data in a Word document, using bookmarks Download a sample here. If you are using Word to build a report that relies on Excel tables, you have a couple of ways to achieve it. One is to create links to the Excel file, which is OK if the file is not very large […]
Query with Totals Row — DataWright Information Services
A query with a Totals row Ever need to create a query with a Totals row, like in an Excel report? Use this sample to see how. Versions prior to 2007 I have seen two methods for creating a query with a totals row. The first involves creating a normal Select query joined to a […]
Normalizing a table with repeating fields — DataWright Information Services
Removing repeating fields from a table: Using VBA If you have to convert a spreadsheet to a database you will often find that the imported table has repeating fields. Converting this to a better structure can be tedious and error-prone, especially if there are many fields (the limit in Access is 255 fields in a […]
Pivot tables with expanding ranges — DataWright Information Services
Creating pivot tables with expanding ranges When you add more rows to the data for a pivot table, it is frustrating to have to manually adjust the pivot table’s source range so that you can see the new data in the pivot table. Here are three tips that let your pivot table expand to fit […]
