Search results

Help! I am using a Mid() function in Expr2. Expr1 is an Instr() function. The query work fine when I tested it on a table (Access2000) that was imported, but will not work on a table that is linked to an external (Access97) data source. Every time the query is run I get the Error message...

Can anyone tell me if it is possible to ensure that one part of a macro or code is executed before it starts on another part of sequence. I want to append data automatically from one table to another when a job is completed and then delete it from the first table. I am worried that if...

Unfortunately I have no choice but accept data into a memo field in the following format:- Make: Ford Model: Mondeo Colour: Blue I need to make a query that will parse through and allow me to seperate the three categories and create three seperate fields. The data is always imported in the...