Recent content by nickjones87

Hi guys, I have a problem with special characters / symbols / accents not being imported correctly into access. For example, ° or ß or é ù ü etc. I have a macro to import the data from a Tab Delimited file using "TransferText" in the macro wizard I am using Unicode (UTF-8) as the spec for...

If I understand correctly, sounds a little complicated as the whole database and forms have been designed around 1 table holding all data :( (I'm an amateur) Any advice on a solution to the problem, whilst keeping the 1 table? :)

Hi, What would you suggest? Thanks..

Hi, I'm importing orders into Access 2002, the csv file is from eBay. I've stumbled into a problem with orders with 2 or more different products for each sale. I've attached a picture so it's easier to understand my problem. As you can see, rows 3-5 and 20-25 contain multiple products. Once...

Thanks for getting back to me, its funny you mention this routine because I already have one very similar using 'Waiting', 'Despatched' and 'Hold'. Creating a True/False field called 'PackLock' sounds like a good idea to me. When an order is Despatched or put on Hold, the form will requery, to...

Hello, I have a Access 2002 database that is used for despatching orders, the operator is presented with a form which details what needs to be packed, they can then print an address label then despatch the order, the next order comes up automatically. The form uses a Query that find to find...