Access MVP (2010-2015)


Microsoft opens a User Voice site for Access

Yep, you read that right… Microsoft has opened up a UserVoice site where YOU can suggest features or improvements you’d like to see in Microsoft Access Desktop and Web Apps, as well as, vote on suggestions made by others. This is a great opportunity for YOU to pass on your ideas directly to the Product […]

 560 total views

How to integrate a Microsoft Access database with QuickBooks?

by Guest Poster Priyanka Chouhan


Microsoft Access is a Database Management System, a part of Microsoft office suite of products. This application allows Users to utilize QuickBooks data files just like Access databases.

Steps to create a table in Microsoft Access with QuickBooks:

Run MS Access 2013 (Windows Start button ->All Programs ->Microsoft Office […]

 3,872 total views

Run Query from Desktop

To run a Query from your Desktop without actually opening your Database…

1. Open your Database

2. Select the Query you want to run and drag it to your Desktop

3. Close your Database and then double-click the Query on your Desktop

 1,052 total views

 1,052 total views

Get Initials

I use Initials in Combo Boxes for space conservation on a Form. I don’t depend on the User to enter them, instead, I enter the below in the After_Update event of the Last Name Control on my Form…

Me.txtAssociateInitials = Trim(Left(Me.txtFirstName, 1)) & Trim((" " + Left(Me.txtMiddleInitial, 1))) & Trim((" " + Left(Me.txtLastName, 1)))

 1,016 total views

Ampersand not showing in Caption

When using an Ampersand (&) in a Label or Button Caption you get an underscore (Jack_Jill) or nothing (JackJill). To get Jack & Jill you need to double up on the ampersands… Jack && Jill.

Why? In Access the Ampersand is used as a Keyboard Shortcut. So, if you have a Button Caption entered like […]

 8,773 total views

Minimize Ribbon

Using just…

CommandBars.ExecuteMso "MinimizeRibbon" ..fails. Why? Because if the Ribbon is already minimized it will actually maximize. So, you need to check the Ribbon state first… If Not CommandBars.GetPressedMso("MinimizeRibbon") Then CommandBars.ExecuteMso "MinimizeRibbon" End If

 741 total views

 741 total views

Set focus to start of field

When you open a Form, the first field (Control) in your preset Tab Stop is always highlighted. This has been known to cause issues…

Users press the Enter key, thereby eliminating the data that was present (and don’t always remember to press Undo). Users begin typing not realizing they are not on a new […]

 6,593 total views

Combining Fields

Combining fields is easy enough BUT when there’s a chance one of the fields might be blank (empty), well, that presents an issue. Especially, when you don’t want the comma, period or dash to show if the adjoining field is blank (empty), ie: Jane . Doe (no Middle Inital so only the period shows) or […]

 1,259 total views

To stop Code execution

Click Ctrl + Pause/Break on your keyboard. You may have to do it twice.

 2,194 total views

 2,194 total views

Undock the Property Sheet

Access 2007 and higher…

While the 4-Pointer cursor is showing, usually when on the Title Bar, click and hold the mouse key and drag. To return it back to its docked position, double-click the Title Bar.

 5,285 total views

 5,285 total views