Recent content by KlausObd

Hi, how to write a compare in VBA generally depends on what field-type the value is. If it's a number - then you just write "[Doc ID]=" & Me![Doc ID] number with decimals: [Doc_Number] = str(Me!Doc_Number) string - then you say: "[DOC_String] = '" & Me![MyStringField] &...

Hi, Dates: a) The datetime format in MSAccess always stores a point in time - internally stored as type double (the values before the . are the number of days since the 30.12.1899 (Bill Gates GrandFathers birthday) and the numbers after the . are the part of the day. 0 = midnight, date only no...