Search results

Merry Christmas to All, I've just come across a most annoying situation in my reports. Previously, one of the text boxes contained a date calculated from ReceivedDate + 14. Now, I've complicated things by adding an expression to allow for five different possibilities: received date +7, >7 to14...

Good day, An application was created using A2002 then converted to A97. This converted version has been in use for 5 months and it now contains more than 6000 records. Many modifications have been made to original. I now want the users to use new version. My problem is twofold: Firstly, when...

Good day, Since adding DateTimePicker ActiveX Controls to one of my forms, the following messages appear: "Can't set value to Null when checkbox property = False" and "The value you entered isn't valid for this field." (The field in question is a big question mark.) What's that all about and...

In a form, I have an estimated completion date field which I want to link to the received date and type of inquiry fields. Depending on the "type of inquiry" selected, I want the completion date to be entered automatically based on predetermined service standards, i.e. if "letter of confirmation...

I want to enable users to view reports of open inquiries by age based on the ReceivedDate field. I would like to create 3 queries to allow them to view records that are between 1-14 days old; 14-28 days old and 28+ days old. I've played around with all kinds of syntax ranging from ''Between...