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

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...

Post has attachment
Public
A Recordset Bug
While trying to help a MSDN Forum user recently, I came across a potential bug when using a Recordset to loop through the records in a query. If you are interested in reading the discussion thread, you can find it using this link: https://social.msdn.micros...
Add a comment...

Post has attachment
Public
Get PDF Form Field Names
Some of you may be familiar with my Fillable PDF Demos , which allow the user to fill a PDF form with data from an Access database. The demos use two different approaches for accomplishing this. One solution uses an XML approach, which works even if users o...
Get PDF Form Field Names
Get PDF Form Field Names
thedbguy.blogspot.com
Add a comment...

Post has attachment
Public
Execute Excel Functions in Access
As a database developer, I sometimes help people convert their data from Excel into Access. Although both applications can store data in a table format, they are built for different purposes. Excel is a little bit easier to learn so a lot of people tend to ...
Add a comment...

Post has attachment
How to Retrieve the Hard Disk's Serial Number
I found myself looking for a way to retrieve the serial number of the computer's hard drive as a way of preventing unauthorized copies of an Access app. I have done it before but couldn't remember how. To my surprise, I found several ways to accomplish this...
Add a comment...

Post has attachment
A function to return the next work day
I know there are plenty of routines already available to calculate work days, but this topic is not really about adding work days to a date or counting work days between two dates. Rather, it is an extension of the topic for making sure the result from a da...
Add a comment...

Post has attachment
Import Access 97 MDB Data Using Access 2016
Some people may still be using an Access 97 MDB database and then realize they can no longer open their database when they upgrade to Access 2013 or 2016. According to this MS article , support for Access 97 MDBs were removed in Access 2013. The recommended...
Add a comment...

Post has attachment
Form Data Validation
If you ever need to make sure the user entered valid information on the form before committing the data into the table, then it is considered "best practice" to perform data validation routines using the Form's BeforeUpdate event. In addition, it is common ...
Add a comment...
Wait while more posts are being loaded