Monthly Archives: March 2015

VBA function to Pivot and Concatenate Child records

In situations where a Parent record has a limited number of children (0 to 10 works well) and you would like to list those children next to the parent somewhat like you would with a Pivoted table. Pivoting the table … Continue reading

Posted in All, VBA Code MS Access | Comments Off on VBA function to Pivot and Concatenate Child records

Save Record before Event

If users are editing or creating a record and there is an option on the form to print out the form if they press it they will expect the information that they have just created to appear on the print … Continue reading

Posted in All, Database Design, MS Access, VBA Code MS Access | Comments Off on Save Record before Event

Appropriate User Interfaces

I have three guitars 10 windsurfers and 4 bikes (5 if you count a static exercise bike) I have three regularly used computers (tablet , desktop and laptop) – four if you count my phone. My bikes are not duplicates … Continue reading

Posted in All, General Opinion, Productivity, Project Management | Comments Off on Appropriate User Interfaces

Forcing or Limiting Columns Using Cross Tab Queries

MS Access has a version of SQL that can be edited to enforce specific columns being shown in queries. Within the query editor navigate to the SQL View Normally when a cross-tab query is selected MS Access will generate columns … Continue reading

Posted in All, Database Design, MS Access, SQL MS Access | Comments Off on Forcing or Limiting Columns Using Cross Tab Queries