Search results

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.

Thanks for your reply, I have attemped to design a report that looks like Excel. I have a main report which has two sub reports with 10 columns. Patient chart numbers display vertically across one subreport and the Yes,No or N/A results are lined down the second subreport. The main report has...

Thanks for your reply. Being self taught has many, many, many "I'm not sure why, it just worked. My logic was I am developing a DB with many forms that will have several hundred questions that will only be answered, YES, NO or N/A. I'm not sure what you mean by search form. After discussing...

I have a subreport with 10 columns and I need to total each column? Right now it totals all 10 columns. Any help appreciated.

Anyone up for a challange or a good laugh??? I am working on a DB to be used by our corporate compliance auditors. I have multiple tables,queries and forms. I have a report with multiple questions each question was assigned a default numerical value (points). I have combo boxes that display...