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
|
|||
|
|||
MS Fax and MS ACCESS REPORTS
Hi,
I am trying to fax (using ms fax) an access report. The report is faxed but only text appear on the fax and all formatting/images are missing. It seems that word rendering is not working properly. Does anyone know how to fix that. Thanks, Nour |
#2
|
|||
|
|||
You've provided none of the necessary information.
ms fax? What's that? Provide your fax software. List the precise steps by which you are sending the fax and how this is related to Outlook. -- Russ Valentine [MVP-Outlook] "Nour" wrote in message . .. Hi, I am trying to fax (using ms fax) an access report. The report is faxed but only text appear on the fax and all formatting/images are missing. It seems that word rendering is not working properly. Does anyone know how to fix that. Thanks, Nour |
#3
|
|||
|
|||
Hi,
Here is the code ... ' Fax report ... DoCmd.SendObject acReport, stDocName, acFormatRTF, "[fax: " & strTel & "]", , , , , False Note: - I have win XP home edition. - I have installed Microsoft FAX service. - In Outlook, I added "Fax tansport protocol" - My report ( stDocName ) contains both textes and images. - When I hit "Send Fax" button, an email is sent to outlook. - Then I have to go to outlook and click on "send & receive" which triggers the "rendering process" using ms word. Otherwise I have to wait until outlook does the automated send and receive, in my case every minute (another problem I have to solve ) . Nour "Russ Valentine [MVP-Outlook]" a écrit dans le message de news: ... You've provided none of the necessary information. ms fax? What's that? Provide your fax software. List the precise steps by which you are sending the fax and how this is related to Outlook. -- Russ Valentine [MVP-Outlook] "Nour" wrote in message . .. Hi, I am trying to fax (using ms fax) an access report. The report is faxed but only text appear on the fax and all formatting/images are missing. It seems that word rendering is not working properly. Does anyone know how to fix that. Thanks, Nour |
#4
|
|||
|
|||
Reply to the rest of my questions.
-- Russ Valentine [MVP-Outlook] "Nour" wrote in message . .. Hi, Here is the code ... ' Fax report ... DoCmd.SendObject acReport, stDocName, acFormatRTF, "[fax: " & strTel & "]", , , , , False Note: - I have win XP home edition. - I have installed Microsoft FAX service. - In Outlook, I added "Fax tansport protocol" - My report ( stDocName ) contains both textes and images. - When I hit "Send Fax" button, an email is sent to outlook. - Then I have to go to outlook and click on "send & receive" which triggers the "rendering process" using ms word. Otherwise I have to wait until outlook does the automated send and receive, in my case every minute (another problem I have to solve ) . Nour "Russ Valentine [MVP-Outlook]" a écrit dans le message de news: ... You've provided none of the necessary information. ms fax? What's that? Provide your fax software. List the precise steps by which you are sending the fax and how this is related to Outlook. -- Russ Valentine [MVP-Outlook] "Nour" wrote in message . .. Hi, I am trying to fax (using ms fax) an access report. The report is faxed but only text appear on the fax and all formatting/images are missing. It seems that word rendering is not working properly. Does anyone know how to fix that. Thanks, Nour |
#5
|
|||
|
|||
the code i run in ACCESS 2002 is ... Private Sub cmdSendFax_Click() On Error GoTo Err_cmdFax_Click Dim stDocName As String Dim strFileAndPath As String Dim strTel As String ' in case data was changed, save before faxing .. Call cmdSave_Click ' Select language 'strLang= "Fr" Dim nInput As Variant Do nInput = InputBox("English Fax ( 1 ), French Fax ( 2 ) ", "Fax Language", 1) Loop Until nInput = 1 Or nInput = 2 strLang = Choose(nInput, "En", "Fr") strTel = Form_Entreprise.Fax '."5142730120" ' "5142701212" stDocName = "FaxDoc" ' Fax report ... DoCmd.SendObject acReport, stDocName, acFormatRTF, "[fax: " & strTel & "]", , , , , False ' Runs Report to MSFax ' acFormatRTF SendReceiveNow Exit_cmdFax_Click: Exit Sub Err_cmdFax_Click: MsgBox Err.Description Resume Exit_cmdFax_Click End Sub |
#6
|
|||
|
|||
Hi,
Never mind I found a solution. I just changed acFormatRTF to acFormatSNP in the Docmd.SendObject call. Thank you for you help. Nour "Nour" a écrit dans le message de news: ... Hi, I am trying to fax (using ms fax) an access report. The report is faxed but only text appear on the fax and all formatting/images are missing. It seems that word rendering is not working properly. Does anyone know how to fix that. Thanks, Nour |
#7
|
|||
|
|||
Aha. Did your document have any elements that would require rendering?
-- Russ Valentine [MVP-Outlook] "Nour" wrote in message ... Hi, Never mind I found a solution. I just changed acFormatRTF to acFormatSNP in the Docmd.SendObject call. Thank you for you help. Nour "Nour" a écrit dans le message de news: ... Hi, I am trying to fax (using ms fax) an access report. The report is faxed but only text appear on the fax and all formatting/images are missing. It seems that word rendering is not working properly. Does anyone know how to fix that. Thanks, Nour |
#8
|
|||
|
|||
Yes, images and special formatting. I already mentioned that in my first
post. Thanks. Nour "Russ Valentine [MVP-Outlook]" a écrit dans le message de news: ... Aha. Did your document have any elements that would require rendering? -- Russ Valentine [MVP-Outlook] "Nour" wrote in message ... Hi, Never mind I found a solution. I just changed acFormatRTF to acFormatSNP in the Docmd.SendObject call. Thank you for you help. Nour "Nour" a écrit dans le message de news: ... Hi, I am trying to fax (using ms fax) an access report. The report is faxed but only text appear on the fax and all formatting/images are missing. It seems that word rendering is not working properly. Does anyone know how to fix that. Thanks, Nour |
Thread Tools | |
Display Modes | |
|
|