Recent content by GDewez

A couple of us were doing data entry when one of the record converted its characters to chinese one. When trying to delete this record,I got the error message that the key wasn't found in any record. And clicking the help this is what it said "The search key was not found in any record. (Error...

You saved several days of my time. Thank you!

I am trying to export to a .csv file too. However I have a problem with the text fields. I need the result of the export to be all in upper case. The original data was entered in lower case. Is there a way to get it to do it automatically? Or does the data need re-entering? I haven't...

Found it now.

Wazz, It is now asking for the parameter of dd, then mmm, then yy. Then there is a message that the expression is too complex. How come Access does not recognise d m and y anymore? It is not recongised in the Input masks either.

Hi there, I have to format a date following dd-mmm-yy in an expression also containing text. Expr1: "Text" & " " Date() Although separately formatting the date is easily done. I need to keep both int he same expression.