Saving a report as a field name by default

unclefink

Registered User.
Local time
Today, 11:06
Joined
May 7, 2012
Messages
184
I am working on a db that has options of saving and emailing a report. Most of the reports are specific to a general tenant space. What I would like to know, is there a way to save or email a report by default to title itself the chosen "tenant" name rather than the "query/report" name, the item the report is initially derived from.

Example: When saving a report, the current Name is TenantRptAlldata.pdf which only reports back a specific tenant name.

What I would like it to do is self title via the tenant name and maybe the current date.pdf.

Is this possible, any suggestions?
 
Saving and emailing by pushing a button which has the save or email procedure via the button operation.
 
Now awake, i realize my response probably didnt make much since. I wrote it with just shy of 3 hours of sleep after a 12 hour shift.

I have a button with an embeded macro which prompts for the specific report to save or email. I have one button for each option when i click on the appropriate button it will save the report as the report name and either saves it to a file path or attaches it to an outlook email. In either case, the report has a default name of the report name.

Hope this answers your question.
 
Pat,

First off thank you in advance for taking the interest in giving me the information you have thus far. Unfortunately I am not at all familiar with of understand the process of programming VBA code, is that something you might be able to help me with?
 

Users who are viewing this thread

Back
Top Bottom