Recent content by kgranneman

The Debug.Print returns [RecCount] = 90. Assuming the bracketed portion isn't applied, then the field is RecCount which is an AutoNumber, long interger and the record I tested was #90. I have this field included on the report, although I don't need it. The report field name is also RecCount...

Thank you for reviewing the code and replying. I've tried it with and without the DoCmd in the On_open event. The procedure advances to that point and displays the "Output format" dialog box. After clicking "OK" I see the "generating report" dialog box flash momentarily and then.. nothing. No...

I have a subform nested into a main form. I want to email a report of only the current record being viewed. The report mirrors the form, it contains a subreport nested into a main report. The main form has a unique text SubjectID and the subform has a unique number RecCount. Allen Browne has...

I have a date field that caculates on click of a command button in a form. I like to use that calculated date in a message set in the body of an appointment reminder. I want the message to read: "Connection Date [insert connectdate from calculated field]" Me![frmAppoints]![ApptNotes] =...

I made the change. Now have to re-package and test on other PC. I'll let you know the outcome. Thanks for the reply.

I created a form which triggers an email message. If the message is "closed" without saving or sending the system returns a 2501 error. I trapped the error and entered handling code which works on my system with the full version of Access 2010. However when the database is packaged with Runtime...