-
Archives
-
Meta
Author Archives: rawilken
DLookup
Doing an If clause with DLookup genereally means usin a comparison of the lookup result to a value using the equals function. Most other functions do not tend to work well with DLookup and especially not the IF ISNULL structure.
File System Objects
Remember to look to use FSO’s such as FileCopy when you are trying to do things outside of Acces from within Access. File System Objects are readily available and require few skills to learn.
Posted in Access 2007 problems/solutions, Uncategorized
Tagged FSO File System Ojects Copy
Comments Off on File System Objects
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 DLL References VBA Listbox
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 CSV Delimited Import XLS Excel Text
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 CSV, Import
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 Beach, Cash, Finances, Parking, Parking Lot, Virginia Beach
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