Search results

As for now I decided to set the acPreview to true so the user can see the PDF file just before it attached to email

Yes, All db is local too As I said the report is visible before I export it to PDF

I show the report first Next the user can click a ribbon to export to PDF and send by email

I create the PDF on a local machine

I'm exporting reports to pdf using DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, strPDFfile After exporting the report is sent by email sometimes the end user get the report with blank sub reports The report looked OK before exporting and sending :( Any idea ?

Yes, I saw that :) How do I send the Me.ControlName ?

How do I send the form name and the control name I'm currently in to the function ? I guess I can use something like fPaste(Me.Name) I know I can use Me to send the frm As Form, or use Me.Name to send the Form's name How do I send the Control name ?

Thanks, but it's not exactly what I want I want the user to be able to edit this textbox text, and be able to insert the text into the middle of it. He can also do some kind of formatting there - Bold Underline and Italic Can I make my own button in the right click menu to run a code that will...

I'm using a right menu click menu Since the field is a rich text one I want to limit the users to paste a plain text only, but can't find the correct msoControlButton button ID :( Is there another option, If there is no special ID for it ? Thanks ' Create the PlainText menu. Set...

You probably either assign a value to one of the fields by code or by a default value on the form.

Actually I use my own IsNOE() function If Trim(strToTest + "") =" " then True Else False End if

You are right. Look carefully at my code It wont print blank values

What exactly do you need?

What exactly do you mean by "Save"? 🤔 The file is already there, on the computer. Do you mean to "Save as..." giving it a new name?

This might help you Public Sub pbListAllEnvironVars() Dim i As Long For i = 1 To 255 If IsNull(Environ$(i)) = False Then Debug.Print i & " - " & Environ$(i) End If Next i End Sub

A date can't be compared to Null value try to replace the Null value with something like 01.01.1900

Thanks a lot :) I'll test it and dig into it

Thanks The doubled apostrophes did it :)

I see no reason the DoCmd.GoToRecord , , acNewRec not to work I feel other then uploading a strip version of your db it will be all some kind of guessing.

I use the free 3to9 font. I deploy it wherever I put my db Clean and easy :)