Profile cover photo
Profile photo
DB Guy
11 followers
11 followers
About
Posts

Post has attachment
Public
Keyboard Key Code Values
This was an old article on my website, which I thought might be good to resurrect in case people might find still find it useful. The Form's Key events can be used to determine which key on the keyboard was pressed so that certain user actions can be interc...
Keyboard Key Code Values
Keyboard Key Code Values
thedbguy.blogspot.com
Add a comment...

Post has attachment
Public
Create a Parameter Query to accept multiple values
Parameter queries are a quick way to create dynamic queries where the result changes depending on user input. If you are not familiar with parameter queries, you can review my article on Parameter Query Basics . The following SQL statement is an example of ...
Add a comment...

Post has attachment
Public
Happy Halloween to Gremlins and Zombies
About three years ago, I wrote this blog article on Combobox Gremlins . In perfect timing for the upcoming Halloween, I received a follow up comment from Colin Riddington trying to explain the reason for the issue I described in that article. He was so insp...
Add a comment...

Post has attachment
Public
Copy Folder Structure
Hello there! First, I must apologize for the title of this article. I chose it because I think most Internet searches use a phrase similar to it, and I wanted to make sure people get to see and consider this information in their projects. So, I am not reall...
Add a comment...

Post has attachment
Public
RegEx vs Character Loop
As is often the case with database management, we invariably have to clean up the data at some point. This demo was inspired by a thread discussion at UtterAccess where the original poster was looking for a way to remove unwanted characters from table recor...
RegEx vs Character Loop
RegEx vs Character Loop
thedbguy.blogspot.com
Add a comment...

Post has attachment
Public
RegEx vs Character Loop
As is often the case with database management, we invariably have to clean up the data at some point. This demo was inspired by a thread discussion at UtterAccess where the original poster was looking for a way to remove unwanted characters from table recor...
RegEx vs Character Loop
RegEx vs Character Loop
thedbguy.blogspot.com
Add a comment...

Post has attachment
Public
RegEx vs Character Loop
As is often the case with database management, we invariably have to clean up the data at some point. This demo was inspired by a thread discussion at UtterAccess where the original poster was looking for a way to remove unwanted characters from table recor...
RegEx vs Character Loop
RegEx vs Character Loop
thedbguy.blogspot.com
Add a comment...

Post has attachment
Public
Retrieve Database (Extended) Properties
If you've ever wondered how to programmatically retrieve the information from the Summary tab when you click on "View and edit database properties" from the Info tab in Backstage View, then continue reading. An example of the Summary tab information is show...
Add a comment...

Post has attachment
Public
Backstage View
A while back, I posted a demo showing how to hide the Backstage View in Access 2010 ( click here to see the original article ). This particular technique allows developers to somewhat restrict users from making unwanted modifications to their database appli...
Backstage View
Backstage View
thedbguy.blogspot.com
Add a comment...

Post has attachment
Public
List Files in a Folder and its Subfolders
While trying to answer a question in the MSDN Forums, I realized although there are already a lot of examples on how to list all the files in a folder or directory, I thought this was challenging enough for me to give it a try. The original poster's request...
Add a comment...
Wait while more posts are being loaded