Search results

Hello, thank you very much for your input! I have tried this code, the report runs but it's empty ("#False").

thanks for your reply. I can try adding the database but i should remove all data first, is this ok? Clarification of the request: - i am trying to open a report with multiple records. Basically i have a report for 1 invoice, this works ok. I want to make a button so i can print or save...

Excellent idea. I made a new form and tried to hardcode the values: Private Sub btnPrintRange_Click() DoCmd.OpenReport "rptInvoice", acViewPreview, , "[invoicenumber] BETWEEN " & 201701150 & " AND " & 201701155 End Sub but now nothing happens. Both values are correct and exist.

Yes, there are is more than one invoice in the range, the numbers are correct. The field isn't text. I tried to make a new form in my database and start over with trying to get this to work. When i run the code i don't get report anymore but a prompt asking me for an invoice id (which i would...

Thank you for your reply. I am very sure there aren't multiple pages. The counter on the bottom page "1" and the direction icons are greyed out indicated there is only 1 page. :(

Hello guys, I have been looking for a solution to this all afternoon but i can't figure this out. My apologies but i am very new to access. I want to open multiple reports at once in a print preview of different id's. So far the report does open but it will only open one id and not the range...