-
Archives
-
Meta
Author Archives: Jack
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 Access and MySQL, Access in the Cloud, Access vs Dropbox
Comments Off on Workaround: Access and Dropbox
Access Driven Web Sites
You can control your web content with an Access Database. That’s how we run our website(s)! So, here’s the datacontrolllc.com website showing 3 lists of clients: Subcontracting / Build-Fixing / Integrating We’re going to concentrate on the first list of … Continue reading
Posted in Access and SQL Server, Access Code Examples, Access Database on Web
Comments Off on Access Driven Web Sites
Combination Form Filters
I’m often asked by clients to perform combination filters. That is, not just a single filter on a form. But combining multiple filters that interact with one another. For instance, in the Marketing Database I’ve built for datacontrolllc.com, I have an … Continue reading
Posted in Access Code Examples, Access Database Advanced Forms, Access Database Filters
Comments Off on Combination Form Filters
Access and Word Integration
Recently we’ve been asked by a number of clients including Roofing Consulting Services (Consultants, Richmond, VA), KnoxMarine (Surveyors, Charleston, SC) and Hirschler Fleischer (Attorney, Richmond, VA) to integrate Access with Word. What these companies have in common is that they … Continue reading
Posted in Access Automating Word VBA, Access Code Examples, Access Database Advanced Forms
Comments Off on Access and Word Integration
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?
Managing text communications (with an Access Database)
You can manage your texting using an Access Database. Contact us at www.datacontrolllc.com or jjaeger@datacontrolllc.com to learn more. You can purchase this Access database for $100.00
Posted in Access Code Examples, Microsoft Access Solutions
Tagged contact access database, texting access database
Comments Off on Managing text communications (with an Access Database)
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 Access Database, access database code example sample notinlist combo box legal manufacturing health care distribution banking finance, bank access database, loan portfolio database
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 Asset Access Database, City Access Database, County Government Access Database, Facility Access Database, Government Access Database, School System Access Database
Comments Off on Virginia, Henrico County Public Schools Facilities/Projects/Asset Management Database