Recent content by cunninghamsa

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...

Hello Mile-O-Phile, Just thought I'd let you know that I figured out the errors in syntax for my formula. Takes me a while but I get it eventually. Just a few missing parentheses were causing me all this grief. Good grief! For anyone out there who should be at the same developmental stage as I...

Hello Mile-O-Phile, Yes, you're right, ServiceStandards is a combobox with five possible options. I may not have understood your question corrrectly but my comprehension of bound column is as follows: If I want a value retrieved from text entered into a field, I enter this field name into...

Gidday, Sorry to resuscitate this one but it seemed to be just the ticket for what I was hoping to accomplish. I used the following formula in a text box (Estimate Completion Date) based on the user's selection in a combo box (Service Standards): IIf ([ServiceStandards] = "<7 days URGENT"...

Thank you Bob and Pat! I was afraid I was going to find out how difficult it would be. I will try your suggestion, Mr. H.. If I'm successful, I'll let you know. Bye for now!

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...

:confused: Thank you for attempting to answer my question. I may be a bit dim but I don't even know where these quotation marks should be inserted since "allow zero length" is not a field property in date/time data type. Nor is it an option in the control's properties. Lastly, the only...

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...

Query by Age Thank you NamLiam and DCX693. Finally, it worked. I feel like such a nimrod. It appears that the query was not working simply because of the order of the fields. Can't explain it but once I reordered them, all was well. Now, I can move forward and create the reports and automate...

Age Bracket Query - DB19.zip Thanks for the reply. I had seen the above and had attempted to open it but got the message that the folder was invalid or corrupted. Unsure if problem is at this end. Am curious to take a look. Would it be possible to send as new attachment?

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...