How To Run Microsoft Access On A Mac PC Using CrossOver Software

How To Run Microsoft Access On A Mac PC Using CrossOver Software

You might find this a little strange but I generally prefer Mac to Windows as not all my work is purely Microsoft Access. However, working on Access requires a Windows instance and though I have several computers set up, my Mac Pro also has Access installed using CrossOver Software Installer.

Here’s a quick two minute video tutorial on How To Run Microsoft Access On A Mac which I found to explain the installation process…

httpvh://www.youtube.com/watch?v=y0TF-we1bsY

This is just one way to get Continue reading “How To Run Microsoft Access On A Mac PC Using CrossOver Software”

Concatenating Multiple Rows Into Single Line In MS Access

Microsoft Access Database: Concatenating Multiple Rows Into Single Line In MS Access

Now I’m not going to take credit for this next piece of Microsoft Access database VBA code as it was originally created by a well-known Allen Browne – many thanks!

Instead, I’m going to borrow his code for you (my regular readers) just in case you haven’t seen this before and add an element of quickly adding criteria to a query as a workaround to avoid expanding the VBA code itself.

concatenating multiple rows into single line in ms access

There are potential problems and errors this code will throw at you if you try to add criteria in the normal manner or embed any SQL directly into the calling custom function which means using some common sense and logic to deal with the challenge here.

Microsoft Access Database: Concatenating Multiple Rows Into Single Line In MS Access

First of all, let’s get the function to work and the query understood. In a new module, you will need Continue reading “Concatenating Multiple Rows Into Single Line In MS Access”