Hi,
I'm having some problems with a piece of code that allows the user to save changes to data previously entered it saves over the old information. The problem occurs in only two of the date fields when they save the changes the day and month swap around even though these fields had no alterations made to them. Code below, but I'm not sure if its this or I need to make a global declaraltion that data in these date columns is to be saved in xyz format.
An example below the top line is correct the bottom is not and its allows the first date field and the last date field that have the issue.Please Login or Register to view this content.
11/04/2011 15/05/2011 25/04/2011 08/05/2011
4/11/2011 15/05/2011 25/04/2011 5/08/2011
I have set the date format for the text box in the user form with code shown below.
Hope this make sense.Please Login or Register to view this content.
Cheers BJ5352
Bookmarks