microsoft access tips and techniques

This page lists topics of technical interest relating to Microsoft Access and Access Visual Basic for Applications (VBA) programming.

Written by DMW, these topics have not been vetted by third parties, so please treat them critically.

If you have any views or comments, please e-mail david wallis.

Coping with null values in query expression fields shows the use of the NZ function in preventing errors in the results of calculations in Access queries.

Attaching labels to control objects on a form shows how to restore a label to a control in the design of a form.

Access form loses subform Problem when a main form loses one of its subforms during the design process.

List all database objects presents VBA functions for making lists of the tables, queries, forms and reports that make up a database.

Excel-like rounding of numbers presents an Access VBA function that produces the same results as Excel's ROUND function.

Compacting database and database speed is about taking care of Access database files and addressing the issue of 'bloat'.

AutoNumber field error offers diagnosis of, and solution to, the problem of an AutoNumber primary-key field causing errors when inputting a new record is attempted.

Form or report control displays #Error explains one common cause for the unwelcome appearance of this result in a text box.

disclaimer

DMW Consultancy Ltd does not accept any liability for loss or damage to data to which any techniques, methods or code included in this website are applied. Back up your data; test thoroughly before using on live data.