Recent content by nanny

It still does not work. When I use the expression builder, should I be selecting [HospiceDiagnosis] from the table, query or form??? Thanks, Nanny:rolleyes:

Good morning all, I have a form that lets you choose a patient's diagnosis from a combo box. I am now trying to total each diagnosis on a report. I need some help communicating to the computer what I want. I have tried =Count(IIF([HospiceDiagnosis], "COPD")) and multiple variations of that. Any...

decided to stay with the macro-it works- the only that is a little distasteful is the e-mail recipient will have to open 14 e-mails. Would be nice to send all reports to one folder on my desktop and e-mail the one folder. any suggestions? :rolleyes:

I made the changes you suggested. The first thing after I clicked the e-mail report button was "The report name 'summaryrptAdmissions' you entered is misspilled or refers to a report that isn't open or doesn't exist. ---The spelling was correct so I opened the report, left it opened and clicked...

This is what I copied and pasted -It's starting to scare me!!!! Private Sub Command29_Click() On Error GoTo mcre_mailreports_mcre_mailreports_Err If (Reports!SummaryrptAdmissions) Then DoCmd.SendObject acReport, "SummaryrptAdmissions", "SnapshotFormat(*.snp)"...

I have a macro which will e-mail 14 reports from a command button. Would rather have VB code for some reason---so I did that thing where you convert the macro----now I do not know how to use it. I tried to copy and paste it into the on clinc property of the cmd button but it does'nt work...

I went back and looked at all my reports. The dates on the three reports were not formatted the same as all the other reports. Correcting that made all the reports print correctly. You have been a great help and I appreciate it.

Hello again Mr. BobLarson I finally got the reports to print using your form and modifying the code. I have 14 reports total that print. The only problem I am having now is three of the reports do not print the data they are suppose too. Any Ideas??? Thanks for your help. Slow but...

Still not working. I copied and pasted your code and then substituted my form names as appropriate. Do I need to create a query of the audit dates? Thanks again for your help--not a lot to work with on this end--even so----Thank you. nanny

I understand--thanks, but do I have to open the reports before I can print them??

I copied your example, but the open report only let me choose one report to open/print. I was hoping to print all reports that fall within a date range.

Mr. Larson will I need to replace any of your expression with my information??? Do I need to start from a table then query then form??? Between [Forms]![frmReportDates]![txtBegDate] And [Forms]![frmReportDates]![txtEndDate]

I found some wonderful advise on printing multiple reports (edit code behind print button), but I need to take it a step further. I need to add a date range for the reports to print. I did this in the query under [AuditDate] and it's fine when I print one report, but when using the print all...

I'm not sure how to post my DB

I needed the report Yes,No or N/A to be visible. When I changed the combo box to a text box on the report all I could get to display was a number. I did try.