Access VBA

Resolved · Low Priority · Version 2003

Thu 22 May 2008, 09:39 Delegate Jonathan said...

Jonathan has attended:
Access VBA course

Access VBA

when joining a string together if the same data is held within different records how can you write code so that only one instance of the record is shown on the form but there is a count of the number of times the record is in the database? i.e. house number 16 has flats but you only want to show the house number once and the number of flats contained within it.

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

Access VBA

Access VBA

Access articles

Access tip:

Splittng a database