I have a combo box on a form. I need the user to be able to select Open, Closed, or blank for both. Open and closed works perfect. How do I allow them to select blank or perhaps all for everything. A query is opened based on what is selected on the combobox.
I use the empty option to mean all when I use combos for searches. However, this SQL isn't quite right:
SELECT * from yourTable
WHERE [SomeField] = [Forms]![FormName]![comboName]
The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…