Search results

Hi PNGBill I tried to import it with a different name, but got the same error. Could this be something to do Access 2007 vs 2003? In the older databases, the import of this specific table works

Hi All I'm trying to import info from an Excel file into an Access 2007 database, but it gives me the error message: " is not a valid field name. What is causing this? I'm trying to over-write the original table, so it should not be trying to force formatting within the existing fields....or so...

sorry about that. I remembered only when i clicked the submit button. My bad.

Hi All I'm starting an access db in which I need to track the medical appointments and licenses for all our operators who use motorized equipment. I want this db to remind me of pending appointments, and when licenses are due for renewal. Other than VB, is there any easy way to create this...

I would have used a V-lookup as well, then apply a filter to th column, and specify, where is not null (blanks)

Hi folks I need a formula to use in a MS Access query to extract a portion of text from a text string, where the portion lies between 2 delimiting characters (#) The field length is not always the same. I tried the "MID", "Instr", "LEN" functions, but nothing successful yet :confused::confused::(