If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change report name
Hi,
Is there a way to change report name to be like OrderID_FirstName_LastName I need it to be like that already in report preview because my pdfprinter is naming the pdf file according the reports name which is showing in preview window. We are sending alot of orders to the factory soit would really speed up things. We save the pdffile under customers folder, but know I have to manually rename the pdf file. Thanks! |
#2
|
|||
|
|||
Change report name
You can generally set the Caption property of the report in the On Open
event. My experience is that this value is used as the default file name. -- Duane Hookom Microsoft Access MVP "John" wrote: Hi, Is there a way to change report name to be like OrderID_FirstName_LastName I need it to be like that already in report preview because my pdfprinter is naming the pdf file according the reports name which is showing in preview window. We are sending alot of orders to the factory soit would really speed up things. We save the pdffile under customers folder, but know I have to manually rename the pdf file. Thanks! |
#3
|
|||
|
|||
Change report name
Hi!
Thanks for reply. What I ment was that can I set the Caption property or some other property to be build from the current records fields. Example: ="Order" & "_" & ([FirstName]) I tried that but the reports title in preview window is now ="Order" & "_" & ([FirstName]) Hopefully I can explain what I mean? Thanks "Duane Hookom" kirjoitti: You can generally set the Caption property of the report in the On Open event. My experience is that this value is used as the default file name. -- Duane Hookom Microsoft Access MVP "John" wrote: Hi, Is there a way to change report name to be like OrderID_FirstName_LastName I need it to be like that already in report preview because my pdfprinter is naming the pdf file according the reports name which is showing in preview window. We are sending alot of orders to the factory soit would really speed up things. We save the pdffile under customers folder, but know I have to manually rename the pdf file. Thanks! |
#4
|
|||
|
|||
Change report name
You could maybe use:
Private Sub Report_Open(Cancel As Integer) Me.Caption = "Order_" & Dlookup("FirstName",[RecordSource]) End Sub Otherwise you could have a function return firstname value from an open form or openargs or some place. -- Duane Hookom Microsoft Access MVP "John" wrote: Hi! Thanks for reply. What I ment was that can I set the Caption property or some other property to be build from the current records fields. Example: ="Order" & "_" & ([FirstName]) I tried that but the reports title in preview window is now ="Order" & "_" & ([FirstName]) Hopefully I can explain what I mean? Thanks "Duane Hookom" kirjoitti: You can generally set the Caption property of the report in the On Open event. My experience is that this value is used as the default file name. -- Duane Hookom Microsoft Access MVP "John" wrote: Hi, Is there a way to change report name to be like OrderID_FirstName_LastName I need it to be like that already in report preview because my pdfprinter is naming the pdf file according the reports name which is showing in preview window. We are sending alot of orders to the factory soit would really speed up things. We save the pdffile under customers folder, but know I have to manually rename the pdf file. Thanks! |
Thread Tools | |
Display Modes | |
|
|