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...

Thanks to both for your input. The necessity for this procedure is that core data is being automatically placed on a remote database. The data is used for a few hours during which time it will be updated. After this the data needs to be removed and stored centrally to provide statistical...

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...

Thanks to both of you. With your help and a little luck I have solved the problem. As suggested I used "InStr()" to find the start of text and noticed that in every case the imported data had the same number of chars (although some were somehow hidden). This allowed me to use "Mid()" to...

Further to the above: If it makes a diference I could probably arrange to have the data supplied in a fixed lenth e.g. Label: 5chars Thanks in advance PaulC

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...