Please visite my Access Blog to read more articles including the following:
Extract Data Using Regular Expressions
Using regular expressions is an excellent approach for matching complex patterns. This article demonstrates how to extract the matching information.
Just another short article to discuss the most important concept in relational database theory.
Hide datasheet columns in Split Forms
Some people do not like to use the new Split Forms. But for others who do, this might come in handy.
There is a new and better way to draw borders around each row of textboxes on a report.
When to use the "Me" keyword
Did you ever receive any error or unexpected results when using the "Me" keyword in your code?
There is a new security feature beginning with Access 2007 for preventing malicious code from executing without the user's permission.
There's a new feature since Access 2007 that gives database developers another option for resizing form controls to accommodate different user screen resolutions.
If you've ever wondered about placeholder records, this article discusses my personal point of view on the topic.
Hide Options Menu from the Backstage
This article shows how you can use a custom ribbon to remove most of the menus from the backstage in Access 2010.
Assigning Ribbons using VBA
This article shows you how to assign a custom ribbon to multiple forms at the same time.
Navigation Form Bug
If you use a Navigation Form in your database project, maybe you have encountered this "bug."
How to build strings in VBA
If you're ever confused on how to use double or single quotes when building strings such as SQL statements in a VBA module, then I hope this article helps.
Text Field vs a Hyperlink
Which one is better? Do you have a favorite?
Query Join Basics
For new developers, a refresher on what each query JOIN type means and when to use them.
Update Query with Append
Did you know that you can execute an UPDATE and APPEND query at the same time?
Pop-up, Modal, or Dialog Forms
Ever wondered what were the differences between the various window modes when opening a form? This article is an excerpt from the book "Professional Access 2013 Programming." It was reprinted with permission from the authors and publisher.
This article tries to explain the basic principles of event-driven programming and how it applies to Access and Visual Basic for Applications.
Make-Table vs Append Query
Ever wonder which method of creating and using a temporary table in your database would cause the file size to increase more? I did too. So, I decided to create a little experiment.
If you try to use the Combobox Wizard to add a search feature to look for records on your form, you might discover that this feature is not always available. This short article tries to describe when the Combobox Wizard gives you two or three choices based on the Record Source of your form.
Database Startup Properties
Did you ever want to set certain database startup options using code and wondered what were the names of those properties? This article lists all the property settings available in the Current Database tab of the Access Options window.
A Practical Use of a Cartesian Query
As promised in my first blog, this article describes one practical use of a Cartesian Query. The situation: Produce a query with individual records for each day a room was booked in a room reservation database to facilitate reporting its monthly room occupancy.
This year, I have decided to try "blogging," and this is going to be my first blog. A cartesian query returns a set of data where the number of records returned is the product between the number of records from all the tables used in the query. Although not very common, there are many valid reasons for using a cartesian query.
The Form's Key events can be used to determine which key on the keyboard was pressed so that certain user actions can be intercepted. Access provides some built-in KeyCode Constants that can be used for this situation.
Parameter Query Basics
Queries are considered the workhorse of any database system. They provide a way to correlate the tables in the database and retrieve the requested information based on certain conditions or user requirements. In this article, learn how to use parameter queries to add flexibility to your Access databases.
- Extract Data Using Regular Expressions
- Hide datasheet columns in Split Forms
- Report Gridlines
- When to use the "Me" keyword
- Trusted Locations
- Placeholder Records
- Hide Options Menu from Backstage
- Assigning Ribbons using VBA
- Navigation Form Bug
- How to build strings in VBA
- Text or Hyperlink
- Query Join Basics
- Update Query with Append
- Pop-up, Modal, or Dialog Forms
- Event-Driven Programming
- Make-Table vs Append Query
- Combobox Wizard
- Database Startup Properties
- Practical use of Cartesian Query
- Cartesian Query
- KeyCode Values
- Parameter Query Basics