Okay, so it looks like VBA is how I need to go as I don't know a way to get the formats into the macro builder... One question tho.... been a long time..... and seem to be having problems writting the code...
Been looking for search for some help but getting more confused, guess things have...
Forgot one thing..... this is also being mailed out and in the subject line would like the date appear as well....
Current:
Report, CombinedWarRoomReport, PDF Format (*.pdf), me@work.com, , , Spending Report [looking to add date here], Attached is the current spending report, No,
When using a macro to save a file, it asks for a file location....
What I would like to do is save the file with a date at the end of the file name... I.E. Master File 4-9-13
The current string to save the file reads:
Report, CombinedWarRoomReport, PDF Format (*.pdf), G:\Public\War...
All -
Currently have groupfooter5 .... need this to be invisible if me.codename="Invoice"....
Tried....
If Me.CodeName = "Invoice" Then
Me.GroupFooter5.Visible = False
Else
Me.GroupFooter5.Visible = True
End If
However it is not working...
Essentially, groupfooter5 is a subtotal for...
Well, I did find anything in the module that had "FNTESTSafe...." and replace with "FNSafeSend..." and used the following in the button...
Now, getting the error of
"Ambiguous name detected: FNSafeSendEmail"
And the highlight goes to the following portion of the module:
Public Function...
Thats just it, think I am not properly using / addressing the module in the form. Right now, the Module is sitting there under a name of "Global Code". Then in the form, the On Click has the following
Private Sub Mail_Daily_Report_Click()
DoCmd.SendObject acReport, "dailylineReview", "*.pdf"...
I have been directed to the below site to help me with the new office e-mail security.
http://www.utteraccess.com/forum/mail-t1988667.html
Have added the portion to Outlook and rand the test and all works.
But have not used modules before and having problems referencing the module in the code...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.