Search results for query: *

Thank you ANdrew for this post. Incredibly informative and a great starting point for me. It will take me some time to digest what you've written. At present I am at the point where I have combined the 2 databases together and the correct relationships are there. As stated, I now need to...

I have a db where I have been given data comprised of 3 different ordering systems. 2 of these are old and 1 is our present system and I will be receiving updated data to enter into the database. I intend to have a 1:Many relationship between tblCustomers and tblOrders. Then have a 1:many...

thanks for your help -it's doing what I want. Many thanks

Excellent that's doing what I want! Thanks for your help.

Thanks, I have tried the: Set txtLocation = "E:\Snow Valley\" & Format(Now(), "yyyymmdd_hhnnss") & ".txt" however when I try running the module I receive a "compile error object required" and txtLocation = is highlighted from the above code so I am assuming that the line is wrong? Haven't...

Hi, I'm very new to VBA and have been thrown in the deep end a little. I've had a request that we export our stock list and provide them to a 3rd party on a daily basis. I've written and tested the basic query and so on but now I need to fine tune it. I have created a module that will save a...