Search results

Hi everyone, I wonder if someone can help me. I have a database that imports product files from suppliers. It is a string of 96 characters and I want to be able to vaildate the length of certain fields. I import the file with no problems but I want to be able to vaildate the length of the...

Afternoon all, I have a problem that I hope you guys can help with. I recieve a stock extract each morning and could contain mulitple lines of the same item but with different stock levels. What I need to be able to do using a either a query of using VB is to get one line per item but with...

Afternoon all, my Database is nearlly all finished just one thing needs doing. I have a query that I run in VB, then it exports it into a CSV file to a folder on the C drive. When you run the code it goes to the query where it asks for the date and the CSV file is based on that. What I...

Could you guys take a look at this query please. Doing ym head in now. posts say it is down to the brackets not being the wrong place but i'm sure i've tried every way possible!! I keep getting join expression not support. I also know that the whole syntax could be wrong but someone can help...

Evening all, I have a problem importing a file into access. I have a large .txt file which have fixed widths which looks like this 000004945ORDERTRACK 20081001080042 A51200180018190200001OK248601SA00120080930222807 A51200180018190200002RX991601SA00120080930222807...