Category Archives: Uncategorized

Retrieving images from URLs

You can use the web to fill images in your Access database. Use a image control, the on current event of the form and the .picture property of the image. You’ll need to create a simple function to retrieve the … Continue reading

Posted in Uncategorized | Comments Off on Retrieving images from URLs

Workaround: Access and Dropbox

So you’ve noticed that Access doesn’t play well with Dropbox? Because Dropbox uses a synchronization process to put a local version on your desktop, all kinds of nastiness can happen. Your data can overwrite another person’s data when you synch … Continue reading

Posted in Access in the Cloud, Access vs Dropbox, Access with MySQL back end, Uncategorized | Tagged , , | Comments Off on Workaround: Access and Dropbox

Access Database in the Cloud?

Throughout 2017, we were approached by a number of clients including KnoxMarine (Charleston, SC) and SeniorSmart (Sykesville, MD) to fix their ‘Cloud’ Access databases.  They were both using Microsoft Cloud to hold their Access Database files and were very disappointed … Continue reading

Posted in Uncategorized | Comments Off on Access Database in the Cloud?

Banking / Finance Real Estate Loan Portfolio Access Database

So we built this application for 1st Market Bank which has since become Union.  We’ve also sold it to 1st Capital Bank which is now Sterling. Essentially, the user records all of the relevant information about Customer’s and their loans … Continue reading

Posted in Bank database, Uncategorized | Tagged , , , | Comments Off on Banking / Finance Real Estate Loan Portfolio Access Database

Integrating Access with Outlook using automation and vba (Visual Basic for Applications)

So you have a list of emails and you want to keep in contact with folks easily. I do this by periodically sending out emails to my former clients and offering them incentives to come back and purchase again.  Since … Continue reading

Posted in Uncategorized | Comments Off on Integrating Access with Outlook using automation and vba (Visual Basic for Applications)

Virginia, Henrico County Public Schools Facilities/Projects/Asset Management Database

We’re particularly proud to work with one of the best counties in the United Stated (and the home of Data Control, LLC!) We have built and implemented an Asset / Facility / Project tracking database for Henrico County School Systems. If … Continue reading

Posted in Announcements/News, Government Database, Microsoft Access Solutions, Uncategorized | Tagged , , , , , | Comments Off on Virginia, Henrico County Public Schools Facilities/Projects/Asset Management Database

Calculating travel time between two locations

You need a way to automatically calculate the time to get from one location to another location. You might use this for giving your drivers directions to your clients. Or expand to be an efficient route because you are going … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off on Calculating travel time between two locations

Beginning a new Database

I’m about to begin the development of a database for the Navy (Military Naval Base Client in Maryland). The purpose of the database is to track inventory on the military base. I’ve already had interviews with the client and gotten … Continue reading

Posted in Access Code Examples, Inventory Database, Microsoft Access Solutions, Military Database, Navy Database, Uncategorized | Tagged , , , | Comments Off on Beginning a new Database

Specific Port in Connection String to SQL

When creating a project that will use SQL Server as the back end, the default port used is 1433. You need to have your firewall and router forwarding incoming requests on that port. However, if you need to use a … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Comments Off on Specific Port in Connection String to SQL