Category Archives: Uncategorized

List boxes not populating

If you are using list box(es) and they will not populate with values, check your references in the VBA Editor. Odds are that there is a missing reference to a DLL or two.

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Comments Off on List boxes not populating

CSV Importing

The solution for importing a CSV file is to link to it instead of importing it. Linking to it, all the fields are correctly formatted and populated. One problem to watch out for; commas in the data. So I am … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Comments Off on CSV Importing

Importing CSV files

Importing files can be tricky in MS Access. The application tries to set the property for each field and even with preset values you can still get data imported incorrectly. I don’t have a complete solution for this problem just … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged , | Comments Off on Importing CSV files

Parking Lots

Central Parking System needs a database application to manager the paperwork and finances for the parking lots they operate in the City of Virginia Beach.

Posted in Access 2007 problems/solutions, Uncategorized | Tagged , , , , , | Comments Off on Parking Lots

Nuclear Power plants

Now I will be creating a database for four nuclear power plants. The purpose will be tracking the testing and training of the plant operators. From this the company will also be able to assess what a crew would be … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Comments Off on Nuclear Power plants

Nuclear Power plants

Now I will be creating a database for four nuclear power plants. The purpose will be tracking the testing and training of the plant operators. From this the company will also be able to assess what a crew would be … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Comments Off on Nuclear Power plants

File Maker to MySQL

A new challenge is before us. Migrating a FileMaker Pro database on a Mac OSX machine to MySQL on a hosted server. So we can handle Mac and PC implementations.

Posted in Access 2007 problems/solutions, Uncategorized | Comments Off on File Maker to MySQL

Discovery

I enjoy the discovery phase of a project; learning a new business, seeing how other people arrange and manage their business. No two businesses are the same. There lies the shortfall of software packages. They are not able to be … Continue reading

Posted in Uncategorized | Comments Off on Discovery

What my customers enjoy

I find that when developing a proposal, if I give the client a graphic display of their database as it would look to the user, that they are better equiped to help me design the database the way they want … Continue reading

Posted in Uncategorized | Comments Off on What my customers enjoy

Data Comparison/Change made easy?

I do a weekly download from a .csv file (for my client). They want to visually compare the orig data (in a form) to the new data.  Then they may or may not want to accept any data changes. So … Continue reading

Posted in Uncategorized | Comments Off on Data Comparison/Change made easy?