Search results

Brian, As I said, your solution to the date format worked a treat, however, now that the VBA runs, I have another slight issue. Once fixed then my Form is finished!! The section of code which does the update of the records is If YearCol = "2012" Then Query = "SELECT [Membership...

Brian, Thanks for the input, it worked a treat!! Since I recieved your reply, I still can't find any reference to this solution either on this Forum or Google or in my refeernce book (The Missing Manual). Is it a well know fact that, although I am dealing with UK dates in Forms, when I use...

Spikepl, Thanks for your unhelpful comments. You certainly know how to encourage a new user !!!

Brian, Phew!! It looks like the problem I have but I can't understand the code (I am not that experienced yet!!) If possible could you give me a clue in simple language (or code) that would apply to my code? If not I will have to abandon the SQL method and try to work out how to use Query to...

Jiri, Thanks. I have checked that setting and it is set to UK and short date dd/mm/yyyy, so that is not the problem. If I navigate to the entry in my database that has been written incorrectly and select the date picker that appears, if I then select the same date, it is written in the...

Hi, I am new to access and have only been messing about with it for a few weeks, so forgive me if my code sample is not efficient or elegant. I am tidying it up as I learn more! My problem is that, depite variable ConvertedDate (it is a Date variable)being in the correct format (I think), of...