DataWright Information Services
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.
DataWright is committed to helping you turn your data into information. We are based in Sydney, Australia but we can offer our consulting services over the web, if you are not in our neighbourhood.
Last updated 3 September 2010
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 4 March 2011, 23:50
- Excel: Defining dynamic ranges Updated 4 March 2011
- 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.
