Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Not in List event

There are many examples of how to handle new entries to Combo Boxes, a.k.a. Not_In_List events. However, the one that is not so easily found is how to handle entries that include more than just what’s in the Combo Box. For example, you’re entering an Order from a new Client and you need more than […]

Loading

Appointment Collision Check

You’ve created a database for scheduling appointments, one little problem when entering these appointments you can’t tell if it clashes with another appointment (especially, if you are not the only one entering). You could use a query but I always thought this would be handled better in a Module besides, I had an old database […]

Loading

Create a Splash Screen (Simple)

To create a Splash Screen using a Form…

Create a new Form In the Properties Sheet set… Set the Border to None Set Auto Center to Yes Set Pop Up to Yes Set Moveable to No (optional) Set the Timer Interval to the amount of time (in milliseconds) you want the Splash Screen to […]

Loading

Adding a custom image to a Command Button

A little tired of the stock images that come with Access? You can add your own…

Step 1 – In Design Mode of your Form (if the Property Sheet is not open do so now) click on the Command Button. Then in the Property Sheet select the Ellipse button, the one with the three dots, […]

Loading

Where to copy/paste Code

You found a piece of code, it says to copy/paste into the Event Procedure of your Control, great! Hmm, now where exactly is that?

First, open you Form in Design Mode making sure the Property Sheet is open. Select your Control and on the Property Sheet select the Event tab.

 

Go copy the […]

Loading