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.
Archive for the ‘Access 2007 problems/solutions’ Category
DLookup
Thursday, December 30th, 2010File System Objects
Friday, November 12th, 2010Remember 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.
List boxes not populating
Tuesday, November 9th, 2010If 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.
Can’t delete records in SQL Server table from Access
Monday, November 8th, 2010Issue:
Table must have a Primary key (or at least a unique index).
Resolution:
When creating the link to the SQL Server table, and Access prompts for index, this isn’t sufficient.
The index must be created on the SQL Server table (and must be unique?)
Furthermore, after adding the index, Access still doesn’t recognize the index. You must destroy and recreate the connection to the table.
CSV Importing
Friday, October 22nd, 2010The 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 turning to the semicolon as the answer. I am looking for the web developer to output the csv delimited by semicolons. If that is done there is a solution to the errors and format problems of importing a csv file. Once it is linked, I will then do the updates of the records. The only other step is to establish a set path for the location of the csv file.
Importing CSV files
Monday, October 4th, 2010Importing 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 yet but keep checking our posts and you will see one as soon as I have worked it out.
Parking Lots
Friday, September 24th, 2010Central Parking System needs a database application to manager the paperwork and finances for the parking lots they operate in the City of Virginia Beach.
Nuclear Power plants
Friday, August 13th, 2010Now 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 capable of based on test results of individuals. This way they can combine individuals with respect to their strengths and weaknesses so as to have all crews meet certain standards.
Nuclear Power plants
Friday, August 13th, 2010Now 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 capable of based on test results of individuals. This way they can combine individuals with respect to their strengths and weaknesses so as to have all crews meet certain standards.
File Maker to MySQL
Saturday, July 31st, 2010A 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.