Show which worksheets link to the current worksheet — DataWright Information Services
Which worksheets link to the active worksheet? When you copy a worksheet, it’s useful to know whether that worksheet contains formulas that reference other sheets. It is also useful to know which sheets are referenced. There are a couple of good reasons for this: If two or three worksheets form a self-contained module (eg: a […]
Documenting queries in Access — DataWright Information Services
Documenting the queries in your database If you have built an Access database of any size, it is likely that you will have a large number of queries. If you want to document the SQL for current and future users, you can use the Database Documenter that comes with Access but you will be left […]
Relinking to a Password-protected backend database
Re-linking to a password-protected database If you create a multi-user database you should split it into a front end (with all the business logic) and a back end containing the tables. The back end belongs on the network in a shared directory; the front end should be on each user’s local PC. Of course, putting […]
Add-to combo boxes — DataWright Information Services
Letting users add a new record to a combo box Often your users will need to add new items to a combo box. How you do that will depend on several factors. If the items in the combo are made up of a value list, you will need to add new items to that list. […]
About — DataWright Information Services
About Denis Wright Denis Wright is the principal of DataWright Information Services, a Sydney-based consultancy specialising in Excel and Access solutions. The consultancy started in 1997 and has provided solutions for a wide range of clients, ranging from small and medium businesses to listed companies, State government departments and the CSIRO. In his past life […]
Documenting query dependencies in Access
Documenting query dependencies If you have to document the queries on your database you will often need to know: What queries do I have in the database, and what is the SQL for those queries? What queries and tables in the database lie upstream of any query; ie, what data does my query depend on? […]
ADO: Defining recordsets correctly — DataWright Information Services
Shows how recordset definitions change, depending on the task
Custom Functions — DblToDate — DataWright Information Services
Transferring Times From Excel To Access Application: Access and Excel I recently came across an annoying problem when transferring dates and times from Excel to Access. I had created a list of time intervals varying from 0 to about 2 weeks, formatted them as dates, and imported them into Access with the accompanying table. Trouble […]
DAO data types — DataWright Information Services
Data type constants in DAO If you have used code that documents your tables using DAO, the data type of each field will be represented by a number. This table decodes those data type constants for you, so that your reports are easier to understand. Value DataType Description 1 dbBoolean Boolean 2 dbByte Byte 3 […]
Report drill code — DataWright Information Services
Code for detail drill down / drill up article This code is provided to simplify copying and pasting of the annotated code from my article on drilling up and down in an Excel report.To use, set up the Summary and Detail sheets using the download file as an example. Copy this code into the sheet […]
