ACCESS FEED: Re: [MS_AccessPros] Send specific report with SendReportHTML function

Minggu, 08 November 2015

Re: [MS_AccessPros] Send specific report with SendReportHTML function

John-

No, that character is the title means "THE FIRST",it's part of the report.

Best Regards,

Kevin

发自我的小米手机

在 "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年11月8日下午8:40写道：

Kevin-

I don't understand what I'm seeing here. Are you sending a snippet of code as the HTML body?

Perhaps this: 第一章

.. is the line generated on a Chinese machine?

If that's the case, then you need to do:

' Replace lines
strHTML = Replace(strHTML, "第一章", "<hr>")

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Nov 8, 2015, at 12:48 PM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John-
The text below is the output html in email. You see there's table line.
Best Regards,
Kevin

第一章
On Error GoTo ErrHandle
If IsNull(Me.GroupBookingID) Then

Forms!frmGroupBooking!subPart.
Forms!frmGroupBooking!subPartService.
Forms!frmGroupBooking!subPartItinerary.
Forms!frmGroupBooking!subPartItineraryCityTour.
Forms!frmGroupBooking!subPartItineraryCityTourDayService.
Forms!frmGroupBooking!subPartItineraryCityTourSpot.

Else
Forms!frmGroupBooking!subPart.
Forms!frmGroupBooking!subPartService.
Forms!frmGroupBooking!subPartItinerary.
Forms!frmGroupBooking!subPartItineraryCityTour.
Forms!frmGroupBooking!subPartItineraryCityTourDayService.
Forms!frmGroupBooking!subPartItineraryCityTourSpot.
End If

ErrExit:
Exit Sub
ErrHandle:
Resume ErrExit

zhaoliqingoffice@163.com