In the Macro object 'ExportwithFormat' there is an option to output as an html file. There is also an option to supply a template file. I am not sure how to create a template file for html.How to create this file or point to a resource that will work for me?
View RepliesHello all..
I have an HTML template with about 15 TAGS built in to it..such as:
[SKU]
[MITVALUE_TITLE]
[MITVALUE_ACCESSORY1]
[MITVALUE_ACCESSORY2]
[MITVALUE_ACCESSORY3]
[MITVALUE_ACCESSORY4]
[MITVALUE_ACCESSORY5]
[MITVALUE_ACCESSORY6]
[MITVALUE_ACCESSORY7]
etc. etc. etc...
Now I would like to somehow populate those fields from the tables that i have.. (The all have a common "related" field)
example:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
<style type="text/css">
<!--
.style10 {color: #FF0000; font-size: 12px; }
-->
</style>
</head>
<body>
<table width="100%" height="100%" border="0">
<tr>
<th height="23" colspan="2" scope="col">ITEM INCLUDES:</th>
<th width="30%" height="100%" rowspan="4" scope="col"><a href="[MITVALUE_PHOTO5]" target="_blank"><img src="[MITVALUE_PHOTO5]" width=266 height=200 border="6" align="right"></a></th>
</tr>
<tr>
<th width="73%" height="23" colspan="2" scope="col"><p align="center">[MITVALUE_ITEM]</p></th>
</tr>
<tr>
<th width="10%" height="23" scope="col"><div align="left"></div></th>
<th width="38%" scope="col"><div align="left"><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="0D4587"> </font><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY1]<br>
</font><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY2]</font></font></b></font><font color="#000099" size="2" face="Arial, Helvetica, sans-serif"><br>
</font><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY3]</font></font></b></font><font color="#000099" size="2" face="Arial, Helvetica, sans-serif"><br>
</font><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY4]</font></font></b></font><font color="#000099" size="2" face="Arial, Helvetica, sans-serif"><br>
</font><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY5]</font></font></b></font><font color="#000099" size="2" face="Arial, Helvetica, sans-serif"><br>
</font><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY6]</font></font></b></font><font color="#000099" size="2" face="Arial, Helvetica, sans-serif"><br>
</font><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY7]</font></font></b></font></font></b></font></div></th>
</tr>
<tr>
<th height="23" colspan="2" scope="col"><span class="style10">THIS ITEM ONLY INCLUDES ITEMS LISTED ABOVE </span></th>
</tr>
</table>
</body>
</html>
................................................
I would like those fields to be put in automatically.. wether they are in a memo field within a table or a field within a query ... it really doesn't matter.... Anyone have any ideas?
Regards,
OvAdoggvO
my html template is built inside access.. the form button is clicked and the template opens in outlook.
it looks fine in outlook.. so i send the email.. when i receive the email in outlook, it looks fine..
here is what it looks like
http://www.londonheathrowcars.com/image2.jpg
however, i sent the same template to a gmail and hotmail address to see what it looks like..
it looks fine in hotmail
http://www.londonheathrowcars.com/image3.jpg
however in gmail it looks like this..
http://www.londonheathrowcars.com/image1.jpg
now, these gaps are appearing in between tables..
<table>blablabl</table>GAP<table>...
now, my question is.. is there anything i can add to the code that will remove these gaps..
i know my code is messy.. at the moment however it begins with <table> and ends with </table> (the main wrap table)
i realise i may need to add some kind of html type or something, but i dont know what..
as always, if anyone can shed some light on this matter i would be ever grateful..
thank you
below is the code
CODE
Option Compare Database
Private Sub emailbutton_Click()
'References: Oulook Library
Dim strEmail, strSubject As String, strBody As String
Dim objOutlook As Outlook.Application
Dim objEmail As Outlook.MailItem
Set objOutlook = CreateObject("Outlook.application")
Set objEmail = objOutlook.CreateItem(olMailItem)
strEmail = Me.emailadd
strBody = "<table border='1' width='610' id='table1' cellspacing='0' cellpadding='5' bordercolor='#5A79B5' align='left'><tr><td align='center'><table border='0' width='600' id='table2' cellspacing='0' cellpadding='0'>" & _
"<tr><td width='300' height='61'> </td><td width='300' height='61' align='center'><img border='0' src='http://www.londonheathrowcars.com/emaillogosmall.gif' width='300' height='61'></td></tr><tr><td width='300' height='30'><font size='2' face='Arial' color='#000080'>FAO</font></td>" & _
"<td width='300' height='30' align='center'><b><font face='Arial' color='#5A79B5'>-------- London Heathrow Cars --------</font></b></td></tr></table><table border='0' width='600' id='table3' cellspacing='0' cellpadding='0'><tr><td> </td></tr><tr>" & _
"<td><font size='2' face='Arial' color='#000080'>Thank you for your booking request via our website.<br>Details of the requested transfer and our fare are as follows:</font></td></tr><tr><td> </td></tr><tr><td><hr color='#5A79B5'></td></tr></table>" & _
"<table border='0' width='600' id='table4' cellspacing='0' cellpadding='0'><tr><td width='200' height='20'><font size='2' face='Arial' color='#000080'><b>Job Date:</b></font></td><td width='400' height='20'><font size='2' face='Arial' color='#000080'> This</font></td>" & _
"</tr><tr><td width='200' height='20'><font size='2' face='Arial' color='#000080'><b>Pickup Time:</b></font></td><td width='400' height='20'><font size='2' face='Arial' color='#000080'> This</font></td></tr><tr><td width='200' height='20'> </td><td width='400' height='20'> </td>" & _
"</tr><tr><td width='200' height='20'><font size='2' face='Arial' color='#000080'><b>From:</b></font></td><td width='400' height='20'><font size='2' face='Arial' color='#000080'> This</font></td></tr><tr><td width='200' height='20'> </td><td width='400' height='20'> </td>" & _
"</tr><tr><td width='200' height='20'><font size='2' face='Arial' color='#000080'><b>To:</b></font></td><td width='400' height='20'><font size='2' face='Arial' color='#000080'> This</font></td></tr><tr><td width='200' height='20'> </td><td width='400' height='20'> </td>" & _
"</tr><tr><td width='200' height='20'><font size='2' face='Arial' color='#000080'><b>Vehicle:</b></font></td><td width='400' height='20'><font size='2' face='Arial' color='#000080'> This</font></td></tr><tr><td width='200' height='20'><font size='2' face='Arial' color='#000080'><b>Set Fare:</b></font></td>" & _
"<td width='400' height='20'><font size='2' face='Arial' color='#000080'> This</font></td></tr></table><table border='0' width='600' id='table5' cellspacing='0' cellpadding='0'><tr><td><hr color='#5A79B5'></td></tr><tr><td> </td></tr><tr><td>" & _
"<font size='2' face='Arial' color='#000080'>Our drivers are courteous, experienced and smartly presented. In addition, all of our vehicles are modern, clean and comfortable. To book this transfer, kindly reply to this email or call us on the following:</font></td>" & _
"</tr><tr><td> </td></tr><tr><td><table border='0' id='table9' cellspacing='0' cellpadding='0'><tr><td width='150'><b><font face='Arial' size='2' color='#000080'>Freephone (UK Only):</font></b></td><td width='150' align='left'><b><font face='Arial' size='2' color='#000080'>" & _
" 0800 505 3231</font></b></td></tr><tr><td width='150'><b><font face='Arial' size='2' color='#000080'>International:</font></b></td><td width='150' align='left'><font face='Arial' color='#000080' size='2'><b> +44 (0) 208 814 2727</b></font></td></tr></table></td>" & _
"</tr><tr><td> </td></tr><tr><td><hr color='#5A79B5'></td></tr><tr><td><b><font size='2' face='Arial' color='#5A79B5'>Hasan Karim - Operations<br>London Heathrow Cars<br> </font></b></td></tr></table><table border='0' width='600' id='table10' cellspacing='0' cellpadding='0'>" & _
"<tr><td><table border='0' width='325' id='table11' cellspacing='0' cellpadding='0'><tr><td width='75'><font face='Arial' color='#5A79B5'><span style='font-size: 8pt'>Address:</span></font></td><td width='250'><span style='font-size: 8pt; font-family: Arial; color: rgb(90, 121, 181);'>" & _
" Suite 7, Jolyon House, Amberley Way, TW4 6BH</span></td></tr><tr><td width='75'><font face='Arial' color='#5A79B5'><span style='font-size: 8pt'>Phone:</span></font></td><td width='250'><span style='font-size: 8pt; font-family: Arial; color: rgb(90, 121, 181);'> +44 (0) 208 814 </span>" & _
"<span style='font-family: Arial; font-size: 8pt; color: #5A79B5'>2727</span></td></tr><tr><td width='75'><font face='Arial' color='#5A79B5'><span style='font-size: 8pt'>Fax:</span></font></td><td width='250'><span style='font-size: 8pt; font-family: Arial; color: rgb(90, 121, 181);'>" & _
" +44 (0) 208 399 6500</span></td></tr><tr><td width='75'><font face='Arial' color='#5A79B5'><span style='font-size: 8pt'>Web:</span></font></td><td width='250'><span style='font-family: Arial; font-size: 8pt; color: #5A79B5'> http://www.LondonHeathrowCars.com</span></td></tr><tr>" & _
"<td width='75'><font face='Arial' color='#5A79B5'><span style='font-size: 8pt'>Email:</span></font></td><td width='250'><span style='font-family: Arial; font-size: 8pt; color: #5A79B5'> info@LondonHeathrowCars.com</span></td></tr></table></td></tr></table></td></tr></table>"
strSubject = "London Heathrow Cars - Booking Request"
With objEmail
.To = strEmail
.Subject = strSubject
.HTMLBody = strBody
'.Send 'Will cause warning message
.Display
End With
Set objEmail = Nothing
End Sub
I'm using the below to merge an access form into a word template (it's a starter for 10).
That works fine. What I need to do is save the word template as HTML so I can then upload it to my website.
Dim wordApp1 As Word.Application
Dim docPath1 As String
Dim fileName1 As String
Dim PageName As String
PageName = Forms!Frm_Page_Create![Page]
docPath1 = Application.CurrentProject.Path & "Merges"
[code]....
I Am working on a Access database that will build a excel spread sheet, that will be uploaded to Ebay via file exchange. I am looking to build a forum that will edit parts of a Html text in a column, such as the size and color.
View 1 Replies View RelatedIn my DB I have a query that I need to create a static webpage from, now in excel I can do the record button and bingo, but access is a lot more confusing.
I have a template named doc_tplt.html that when I do the export from the query it creates the webpage using this template.
I want to have a form with a selection of command buttons on it to export to html using the template for various queries and tables.
What is the VBA code to export the query (qry_docs) and apply the template (doc_tplt.html) and save to the same directory as the DB itself.
I have an access form. It has
-Two textboxes with client first and last name
-Two textboxes with a contact 'email1' and 'email2' for the client
-A combobox with a list of templates to use for the email.
-A checkbox to include a copy of the statement on the email.
I want the user to be able to press a button which does the following
-Sends an email to both 'email1' and 'email2'.
-Attaches a secific report as PDF if the user has selected the checkbox
-The body of the email includes a greeting line using the clients name from the record.
-The body of the message includes below the greeting line a html email template depending on the users combobox selection.
One of the users of my application, reports an error when saving a report to pdf by VBA code. She’s using Access 2013, on Windows 8.1.
The error is “error 2501 output to action was cancelled with access vb macro”
The VBA code is
StrReport = “RepInvoice”
StrDocumentName = “C:UsersMaryDocumentsAccessInvoice.pdf”
DoCmd.OpenReport StrReport, acViewPreview
DoCmd.OutputTo acOutputReport, StrReport, "PDFFormat(*.pdf)", StrDocumentName, False
DoCmd.Close acReport, StrReport, acSaveNo
This error occurs at the OutputTo line. This code is part of an user form with a button “save as PDF”.
When this code is run, the report is visible as an example (as meant to be) on the screen. The code stops at the OutputTo line.
When I use
DoCmd.OutputTo acOutputReport, StrReport, acFormatPDF, StrDocumentName,, False
the problem still exists.
I tried to save the report manually by Preview > Export > PDF. The preview is OK, saving as PDF results in the same error 2501. This may lead to the conclusion that this problem is not caused by the VBA code.
I verified whether user write rights are OK, and whether a default printer is available. Both are OK. The report consists of 1 page.
When this very same application is used with Access 2010, everything functions as expected.
I need, in some way or another, to be able to import an HTML code from an HTML file into Access. It would be ideal if the end result is a table with one memo field named "HTML".
I know is seems strange, but I need the code itself. I've managed to do a bit of duct-tape work, and import from HTML, but this results in only the text of the HTML code (Meaning the text of the web page, not the tags).
I know I'm crazy for wanting this, but is there anyone out there who can give direction/guidance?
More web-ish than vba-ish,
Andrew
I'm using Access 2007 SP3.
Whenever I export reports to PDF, the output appears zoomed and clipped. No extra pages are generated as they would be if I'm going over margins, it's just the report is clipped.
The report looks perfect in preview mode, and it looks perfect when going to an actual printer. However, when using OutputTo to save it as a PDF, this is when the report content is clipped.
Here is the code I'm using:
DoCmd.OpenReport MyReport, acViewPreview
DoCmd.OutputTo acOutputReport, "", acFormatPDF, "MyReport.pdf"
DoCmd.Close acReport, MyReport
I open the report in preview mode first so events are fired that show/hide various objects based on fields in the recordset.
I've tried reinstalling, and I've tried this on two different machines, one running Windows 7 and one running Windows Server 2008...both with the same results.
I am trying to write a more complex macro that will start another macro at a preset time, however I am getting stopped at the first hurdle - getting a macro to run another macro.
Here is the code i am using at the moment, all I want to do currently is click the first button, then get the second macro to execute. But no luck, getting error 2157 "cannot find the procedure"
Code:
Private Sub Command3_Click()
MsgBox "1st macro running", vbExclamation, "Note"
Application.Run "teststart1"
' Application.OnTime TimeValue("19:55:00"), "teststart1"
[code]....
Hi
Would it be possible to automaticaly enter data from a form in to a word template e.g address
cheers
ross
I have downloaded an MS template for a Membership Data Base. I can't figure out how to import membership data from excell into the template. Please help this mewbe.
View 11 Replies View RelatedHello
I have recently finished a data access page and have one last thing to do on it. When you press a button (Command0), it saves the record into the table. This is fine, but I want it to display a message box as well. I am not sure what code to put in and where to put it. Below is a shortened copy of the code from Microsoft Script Editor, i have chopped the top bit off:
.MsoTextbox {
PADDING-RIGHT: 3px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; WIDTH: 2.539cm; FONT-FAMILY: Tahoma; HEIGHT: 0.502cm
}
.MsoBoundSpan {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
.MsoHyperlinkDisplayText {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; CURSOR: hand; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
.Mso2dSection {
LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSection); OVERFLOW: hidden; POSITION: relative; TOP: 0px; BACKGROUND-COLOR: transparent
}
.Mso2dSectionBanner {
PADDING-RIGHT: 4px; DISPLAY: none; PADDING-LEFT: 4px; FONT-WEIGHT: normal; FONT-SIZE: 8pt; LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSectionBanner); OVERFLOW: visible; PADDING-TOP: 2px; FONT-FAMILY: Tahoma; TOP: 0px; HEIGHT: 0.507cm; BACKGROUND-COLOR: buttonface
}
.MsoRectangle {
BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; OVERFLOW: hidden; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid
}
.MsoTitle {
DISPLAY: none; FONT-WEIGHT: normal; COLOR: inactivecaptiontext
}
.MsoExpandCollapse {
CURSOR: hand
}
.MsoNavContainer {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; Z-INDEX: -1; BORDER-LEFT: gainsboro 1px solid; CURSOR: hand; BORDER-BOTTOM: gainsboro 1px solid; HEIGHT: 25px; BACKGROUND-COLOR: gainsboro
}
.MsoNavButton {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; BORDER-LEFT: gainsboro 1px solid; CURSOR: auto; BORDER-BOTTOM: gainsboro 1px solid; BACKGROUND-REPEAT: no-repeat
}
.MsoNavButtonMouseOver {
BORDER-RIGHT: highlight 1px solid; BORDER-TOP: highlight 1px solid; BORDER-LEFT: highlight 1px solid; BORDER-BOTTOM: highlight 1px solid; BACKGROUND-COLOR: buttonhighlight
}
.MsoNavToggleButtonMouseOver {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid; BACKGROUND-REPEAT: no-repeat; BACKGROUND-COLOR: buttonshadow
}
.MsoNavButtonMouseDown {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; BORDER-LEFT: buttonshadow 1px solid; CURSOR: hand; BORDER-BOTTOM: buttonshadow 1px solid; BACKGROUND-COLOR: buttonshadow
}
.MsoNavRecordsetLabel {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; PADDING-LEFT: 0px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: gainsboro 1px solid; WIDTH: 100%; CURSOR: default; PADDING-TOP: 0px; BORDER-BOTTOM: gainsboro 1px solid; FONT-FAMILY: Tahoma; POSITION: relative
}
.MsoRecordSelector {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid; HEIGHT: 100%; BACKGROUND-COLOR: gainsboro
}
.MsoRecordSelectorCurrent {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11240); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorSelectedImage {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11241); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorSelected {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; LEFT: 0px; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid; TOP: 0px; HEIGHT: 100%; BACKGROUND-COLOR: buttonshadow
}
.MsoRecordSelectorDirtyCurrent {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11242); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorDirty {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11245); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorTransparent {
LEFT: 0px; OVERFLOW: hidden; TOP: 0px
}
HR {
COLOR: black
}
SELECT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
INPUT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BODY {
FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
}
MARQUEE {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
LEGEND {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BUTTON {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
TEXTAREA {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
</STYLE>
<SCRIPT language=Javascript id=MSODSC_Validation>
validateBrowser();
function validateBrowser() {
strVers=navigator.appVersion
strName=navigator.appName
strPlat=navigator.platform
intIndex1=strVers.indexOf("MSIE");
intIndex1=intIndex1+5
intIndex2=strVers.lastIndexOf(";");
intVer=strVers.substring(intIndex1, intIndex2)
intVer=parseInt(intVer)
if (strName=="Microsoft Internet Explorer" && strPlat=="Win32" && intVer>="5") {
validateOWC();
}
else {
strMsgGetIE="<TABLE cellSpacing=0 cellPadding=0 width='95%' border=0 height='8'><TR>"
strMsgGetIE+="<TD bgColor='#336699' height=25 width=15> </TD><TD bgColor='#666666' width=500px><FONT face=Tahoma "
strMsgGetIE+="size=4 color=white><b> Data Access Page Notification</B></FONT></TD></TR>"
strMsgGetIE+="<TR><TD bgColor='#cccccc' width=15> </TD><TD bgColor='#cccccc' width=500px><BR>"
strMsgGetIE+="<p><font face='Tahoma' size='2'>"
strMsgGetIE+="This page requires Windows IE 5.0 or higher.</p>"
strMsgGetIE+="<a href='http://www.microsoft.com/isapi/redir.dll?Prd=Office&Sbp=Access&Pver=10&Ar=DPdesigner&Sba=IEhome&Plcid=1033'><p align='center'>"
strMsgGetIE+="Click here to install the latest version of Internet Explorer.</a></font></p><br></TD></TR></TABLE>"
document.write(strMsgGetIE)
}
}
function validateOWC() {
if (MSODSC.object==null) {
strMsgGetOWC="<TABLE width='95%' cellpadding=0 cellspacing=0 border=0 height='8'>"
strMsgGetOWC+="<TR><TD bgColor='#336699' height=25 width=15> </TD><TD bgColor='#666666' width=500px>"
strMsgGetOWC+="<FONT face=Tahoma color=white size=4><B> "
strMsgGetOWC+="Data Access Page Notification</B></FONT></TD></TR><TR><TD bgColor='#cccccc' width=15> </TD>"
strMsgGetOWC+="<TD bgColor='#cccccc' width='500px'><BR>"
strMsgGetOWC+="<p><font face='Tahoma' size='2'>This page requires the Microsoft Office Web Components.</p>"
strMsgGetOWC+="</font><p><font face='Tahoma' size='2'>See the <a HRef='http://r.office.microsoft.com/r/rlidmsowcpub?clid=1033&p1=Microsoft Access&HelpLCID=1033'>Microsoft Office Web site</a> for more information. "
strMsgGetOWC+="</font></p><BR></TD></TR></TABLE>"
document.write(strMsgGetOWC)
}
}
</SCRIPT>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>chauhat03</o:Author>
<o:LastAuthor>chauhat03</o:LastAuthor>
<o:Revision>50</o:Revision>
<o:TotalTime>117</o:TotalTime>
<o:Created>2007-03-20T13:00:23Z</o:Created>
<o:LastSaved>2007-04-02T11:36:45Z</o:LastSaved>
<o:Company>Carphone Warehouse Plc</o:Company>
<o:Version>11.6568</o:Version>
</o:DocumentProperties>
</xml><![endif]--></HEAD>
<BODY style="OVERFLOW: auto" vLink=#800080 link=#0000ff>
<CENTER>
<H1 class="" id=HeadingText><IMG id=Image0 style="Z-INDEX: 2" tabIndex=33
src="Comms Quiz_filesimage002.jpg"></H1></CENTER>
<DIV class=Mso2dSectionBanner id=HeaderQuizResultsBanner
style="MARGIN-LEFT: 0px; WIDTH: 31.989cm" tabIndex=-1><SPAN
id=HeaderQuizResultsBannerCaption>Header: QuizResults</SPAN></DIV>
<DIV class=Mso2dSection id=HeaderQuizResults
style="VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 31.989cm; HEIGHT: 52.997cm"><SPAN
class=MSTheme-Label id=QuizDate_Label
style="FONT-WEIGHT: 700; LEFT: 6.111cm; OVERFLOW: hidden; WIDTH: 2.751cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 0.292cm; HEIGHT: 0.449cm">Date</SPAN><TEXTAREA class=MsoTextbox id=QuizDate style="FONT-WEIGHT: 700; LEFT: 9.101cm; WIDTH: 155px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 0.292cm; HEIGHT: 17px" tabIndex=15 cols=26></TEXTAREA><SPAN
class=MSTheme-Label id=Employee_Label
style="FONT-WEIGHT: 700; LEFT: 6.111cm; OVERFLOW: hidden; WIDTH: 2.751cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 1.295cm; HEIGHT: 0.45cm">Employee<BR></SPAN><TEXTAREA class=MsoTextbox id=Employee style="FONT-WEIGHT: 700; LEFT: 9.101cm; WIDTH: 154px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 1.295cm; HEIGHT: 17px" tabIndex=16></TEXTAREA><TEXTAREA class=MsoTextbox id=Answer1 style="FONT-WEIGHT: 700; LEFT: 6.007cm; WIDTH: 718px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 7.991cm; HEIGHT: 39px" tabIndex=20 rows=1 cols=29 MsoTextAlign="General"></TEXTAREA><TEXTAREA class=MsoTextbox id=Answer2 style="FONT-WEIGHT: 700; LEFT: 6.007cm; WIDTH: 718px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 12.012cm; HEIGHT: 39px" tabIndex=21 cols=21 MsoTextAlign="General"></TEXTAREA><TEXTAREA class=MsoTextbox id=Answer3 style="FONT-WEIGHT: 700; LEFT: 6.007cm; WIDTH: 718px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 16.007cm; HEIGHT: 39px" tabIndex=22 rows=1 cols=22 MsoTextAlign="General"></TEXTAREA><TEXTAREA class=MsoTextbox id=Answer4 style="FONT-WEIGHT: 700; LEFT: 6.007cm; WIDTH: 718px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 20.003cm; HEIGHT: 39px" tabIndex=23 rows=1 cols=35 MsoTextAlign="General"></TEXTAREA><TEXTAREA class=MsoTextbox id=Answer5 style="FONT-WEIGHT: 700; LEFT: 6.007cm; WIDTH: 718px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 23.973cm; HEIGHT: 39px" tabIndex=24 rows=1 cols=32 MsoTextAlign="General"></TEXTAREA><TEXTAREA class=MsoTextbox id=Answer6 style="FONT-WEIGHT: 700; LEFT: 6.007cm; WIDTH: 718px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 27.965cm; HEIGHT: 39px" tabIndex=25 rows=1 cols=22 MsoTextAlign="General"></TEXTAREA><TEXTAREA class=MsoTextbox id=Answer7 style="FONT-WEIGHT: 700; LEFT: 6.007cm; WIDTH: 718px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 31.989cm; HEIGHT: 39px" tabIndex=26 rows=1 cols=31 MsoTextAlign="General"></TEXTAREA><TEXTAREA class=MsoTextbox id=Answer8 style="FONT-WEIGHT: 700; LEFT: 6.007cm; WIDTH: 718px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 35.984cm; HEIGHT: 39px" tabIndex=27 rows=1 cols=30 MsoTextAlign="General"></TEXTAREA><TEXTAREA class=MsoTextbox id=Answer9 style="FONT-WEIGHT: 700; LEFT: 6.007cm; WIDTH: 718px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 39.98cm; HEIGHT: 39px" tabIndex=28 rows=1 cols=24 MsoTextAlign="General"></TEXTAREA><TEXTAREA class=MsoTextbox id=Answer10 style="FONT-WEIGHT: 700; LEFT: 6.007cm; WIDTH: 718px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 43.975cm; HEIGHT: 39px" tabIndex=29 rows=1 cols=30 MsoTextAlign="General"></TEXTAREA><SPAN
class=MSTheme-Label id=Comments_Label
style="FONT-WEIGHT: 700; FONT-SIZE: 10pt; LEFT: 6.007cm; OVERFLOW: hidden; WIDTH: 2.751cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 46.594cm; HEIGHT: 0.45cm">Comments?</SPAN><TEXTAREA class=MsoTextbox id=Comments style="FONT-WEIGHT: 700; LEFT: 6.007cm; WIDTH: 718px; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 46.99cm; HEIGHT: 39px" tabIndex=30 rows=1 cols=24 MsoTextAlign="General"></TEXTAREA><SPAN
class=MSTheme-Label id=DropdownList2_Label title="Team Manager"
style="FONT-WEIGHT: 700; Z-INDEX: 1; LEFT: 6.111cm; OVERFLOW: hidden; WIDTH: 2.689cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 2.301cm; HEIGHT: 0.396cm">Team
Manager</SPAN><SELECT id=DropdownList2
style="FONT-WEIGHT: 700; Z-INDEX: 2; LEFT: 9.101cm; WIDTH: 4.11cm; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 2.301cm; HEIGHT: 0.502cm"
tabIndex=17></SELECT><SPAN class=MSTheme-Label id=DropdownList3_Label
title=Department
style="FONT-WEIGHT: 700; Z-INDEX: 3; LEFT: 6.111cm; OVERFLOW: hidden; WIDTH: 2.248cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 3.282cm; HEIGHT: 0.396cm">Department</SPAN><SELECT
id=DropdownList3
style="FONT-WEIGHT: 700; Z-INDEX: 4; LEFT: 9.101cm; WIDTH: 4.11cm; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 3.282cm; HEIGHT: 0.502cm"
tabIndex=18></SELECT><SPAN class=MSTheme-Label id=DropdownList4_Label title=Site
style="FONT-WEIGHT: 700; Z-INDEX: 5; LEFT: 6.111cm; OVERFLOW: hidden; WIDTH: 2.248cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 4.288cm; HEIGHT: 0.396cm">Site</SPAN><SELECT
id=DropdownList4
style="FONT-WEIGHT: 700; Z-INDEX: 6; LEFT: 9.101cm; WIDTH: 4.11cm; COLOR: blue; FONT-FAMILY: Arial; POSITION: absolute; TOP: 4.288cm; HEIGHT: 0.502cm"
tabIndex=19></SELECT><SPAN class=MSTheme-Label id=Label1
style="FONT-WEIGHT: 700; Z-INDEX: 7; LEFT: 6.007cm; OVERFLOW: hidden; WIDTH: 19.006cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 5.979cm; HEIGHT: 1.586cm">1
.A new Homepage has been created to host TalkTalk Faults documents and
information on Melon KB. Name two aims of the Homepage. (A+B). Where would you
provide feedback in order to update or improve content on this Homepage?
(C).</SPAN><SPAN class=MSTheme-Label id=Label2
style="FONT-WEIGHT: 700; Z-INDEX: 8; LEFT: 6.007cm; OVERFLOW: hidden; WIDTH: 19.004cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 37.968cm; HEIGHT: 1.586cm">9.
If you receive a call from a customer providing a MAC, how would you check if an
order is in the queue or of ot has been released or rejected? (A ,B &
C)</SPAN><SPAN class=MSTheme-Label id=Label3
style="FONT-WEIGHT: 700; Z-INDEX: 9; LEFT: 6.007cm; OVERFLOW: hidden; WIDTH: 18.897cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 41.989cm; HEIGHT: 1.586cm">10.
A new Melon form has been created to use when handling a call from a customer
who has an ongoing query or complaint with an outstanding balance. What is the
purpose of the form? (A). What is essential when completing this action?
(B)</SPAN><SPAN class=MSTheme-Label id=Label4
style="FONT-WEIGHT: 700; Z-INDEX: 10; LEFT: 6.007cm; OVERFLOW: hidden; WIDTH: 19.004cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 9.975cm; HEIGHT: 1.586cm">2.
An issue has arisen with the new Calling Features service available via
www.mytalktalk.net. What has been removed from the site whilst the issue is
being investigated? (A). If a customer requests the Calling Features service,
what should you do? (B)</SPAN><SPAN class=MSTheme-Label id=Label5
style="FONT-WEIGHT: 700; Z-INDEX: 11; LEFT: 6.007cm; OVERFLOW: hidden; WIDTH: 19.004cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 13.97cm; HEIGHT: 1.586cm">3.
If a customer is having problems connecting to their broadband, what is the
correct system to use to verify that they have the correct username and
password? (A). If you find that the username and password is missing from ISP
Admin, what should you do? (B).</SPAN><SPAN class=MSTheme-Label id=Label6
style="FONT-WEIGHT: 700; Z-INDEX: 12; LEFT: 6.007cm; OVERFLOW: hidden; WIDTH: 19.001cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 17.965cm; HEIGHT: 1.586cm">4.
What is the AOL Portal Feedback address? (A) When should this email address be
relayed to a customer? (B)</SPAN><SPAN class=MSTheme-Label id=Label7
style="FONT-WEIGHT: 700; Z-INDEX: 13; LEFT: 6.007cm; OVERFLOW: hidden; WIDTH: 19.001cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 21.986cm; HEIGHT: 1.586cm">5.
If a customer is using the new Windows Vista operating system along with a
Huawei modem, what will they not be able to use when setting up their broadband
connection? (A) What is being done to rectify this? (B)</SPAN><SPAN
class=MSTheme-Label id=Label8
style="FONT-WEIGHT: 700; Z-INDEX: 14; LEFT: 6.007cm; OVERFLOW: hidden; WIDTH: 19.009cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 25.982cm; HEIGHT: 1.586cm">6.
If a LLU customer wishes to cancel whilst they are in the 'Accepted' status,
what actions should you follow? (A). How would you process ADSL and WLR order
cancellations if they are in the 'Accepted' status? (B)</SPAN><SPAN
class=MSTheme-Label id=Label9
style="FONT-WEIGHT: 700; Z-INDEX: 15; LEFT: 6.007cm; OVERFLOW: hidden; WIDTH: 19.009cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 29.977cm; HEIGHT: 1.586cm">7.
A new Second Line Voice Faults Team has been created. What priority Netsuite
tickets will this team handle? (A). What are the transfer numbers for the new
team? (B)</SPAN><SPAN class=MSTheme-Label id=Label10
style="FONT-WEIGHT: 700; Z-INDEX: 16; LEFT: 6.007cm; OVERFLOW: hidden; WIDTH: 19.009cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 33.973cm; HEIGHT: 1.586cm">8.
When obtaining a MAC code, what are the key actions you should take? (A,B, &
C)</SPAN><BUTTON id=Command0
style="FONT-WEIGHT: 700; FONT-SIZE: 10pt; Z-INDEX: 17; LEFT: 26.01cm; WIDTH: 2.487cm; COLOR: red; FONT-FAMILY: Arial; POSITION: absolute; TOP: 46.99cm; HEIGHT: 0.61cm"
tabIndex=32 MsoTextAlign="General">Submit</BUTTON>
<SCRIPT language=javascript event=onclick for=Command0>
try { if (MSODSC.DataPages.Count > 0)
if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).Save();
else
MSODSC.CurrentSection.DataPage.Save(); }
catch (e)
{ alert (e.description);}
</SCRIPT>
<SPAN class=MsoRectangle id=Box1
style="Z-INDEX: -1; BORDER-LEFT-COLOR: #030157; LEFT: 6.007cm; BORDER-BOTTOM-COLOR: #030157; WIDTH: 7.296cm; BORDER-TOP-COLOR: #030157; POSITION: absolute; TOP: 0.079cm; HEIGHT: 5cm; BORDER-RIGHT-COLOR: #030157"
ACCESS_CB_FORMAT></SPAN><SPAN class=MsoRectangle id=Box0
style="Z-INDEX: -2; BORDER-LEFT-COLOR: #030157; LEFT: 17.701cm; BORDER-BOTTOM-COLOR: #030157; WIDTH: 7.296cm; BORDER-TOP-COLOR: #030157; POSITION: absolute; TOP: 0.107cm; HEIGHT: 5cm; BORDER-RIGHT-COLOR: #030157"
ACCESS_CB_FORMAT></SPAN><SPAN class=MSTheme-Label id=Label11
style="FONT-WEIGHT: 700; Z-INDEX: 19; LEFT: 17.991cm; OVERFLOW: hidden; WIDTH: 1.243cm; FONT-FAMILY: Arial; POSITION: absolute; TOP: 0.292cm; HEIGHT: 0.396cm">Links</SPAN><A
id=Hyperlink12_Anchor
href="http://10.144.75.142/contactcentre/SelfServiceViewFile.aspx?fileGUID=bf44f9e9-2f0e-4c65-8ac5-accfd3c57c92"><SPAN
class=msoHyperlinkDisplayText id=Hyperlink12
style="FONT-WEIGHT: 700; FONT-SIZE: 14pt; Z-INDEX: 1; LEFT: 17.991cm; OVERFLOW: hidden; WIDTH: 2.751cm; COLOR: #99ccff; FONT-FAMILY: Agency FB; POSITION: absolute; TOP: 1.006cm; HEIGHT: 0.74cm; TEXT-DECORATION: none"
MsoTextAlign="General">Knowledge Base</SPAN></A><SPAN class=MsoRectangle id=Box2
style="LEFT: 0cm; WIDTH: 31.977cm; POSITION: absolute; TOP: 51.01cm; HEIGHT: 1.978cm; BACKGROUND-COLOR: #030157"></SPAN></DIV>
<P> </P></BODY></HTML>
Please Help!
I have a local intranet where I have a link in a web page to .mdb file. For some reason it does not consisitenly open the database when clicked? Any ideas? Links to Excel work fine.
thanks!
Check around and can't find anything useful, more of a case of can't see the woods for the trees really :p but here we go:
I doing a very simple form which I want to output to HTML (directly), it work fine and is ideal for what I need but I want to use a template to alter the colours and add a meta refresh tag but I cant get it working.
Help file next to useless so I wondered if anyone can point me in the right direction - Is it a css file ? or can I use a html file ? I've tried with both but still no joy :(
and I want to write in some places
I know to open the word
and write in to the word
to write in to word:
Dim objWord As Word.Application
Set objWord = CreateObject("Word.Application")
objWord.Visible = False 'True is visible
objWord.Documents.Add ("C:DocumentsTest.dot")
objWord.ActiveDocument.Bookmarks("bmCusDetails").Select
objWord.Selection.Text = Forms![a]![b]
objWord.Visible = True
but how am I write in a special place?
thanks alot, and sorry on my english
Hi all,
Is there anybody out there that has created a help file for their access db?
im debating on creating one for my users, but do not know where to start to create a helpful, meaningful file.
is there a template or something that i could follow? or can someone show me an example of a decent one that thye have created? thanks!
it is possible to add new column in existing given template which is in my case called Projects template.
View 1 Replies View RelatedI've used Access 2003 to create a database which contains a table linked directly to the "Orders" table on my mysql server. This table holds all of the customer orders placed on our website. I next created a form in access to give me a nice justified view of the orders.
My Problem? The field on the mysql server that holds the line item details for each order is a "Memo" field, and all of the text is formatted in html it appears. When viewed on the form, I see the all of the raw code, and not the nicely formatted text. If i highlight a section of the code from the form, and paste it in a Html editor (Frontpage for example), I see the line items nicely formatted as intended.
Is there a way to get this memo field to display the formatted html text instead?
My access skills are pretty limited, so detailed steps would be appreciated.
I'm trying to get a field in my Data Access Page to display the last time a field was updated, I figured I would have to do this in HTML, after a lot of dead ends elsewhere. Here is the code:
<SCRIPT language=vbscript event=BeforeUpdate(dscEventInfo) for=MSODSC>
<!--
Dim DateModified
DateModified = Date 'Current System Date
dscEventInfo.DataPage.Recordset.Fields("DateModified") = Date
-->
</SCRIPT>
Any clues where I would enter this in the HTML source?
.HTMLBody = .HTMLBody & "<LI>Resolution Description: " & Nz(Me!ResolutionDesc, "")
How can I keep the formatting of the ResolutionDesc memo field (ie Line Feeds and carriage returns) when I add it to an HTML email like this?
Thanks
I'm really hoping someone can help with a topic which has cropped up from time to time in the past but which never seems to have been answered satisfactorily, and that's displaying html in a database.
I have a large database which already includes html codes in the fields - it's a complete set of email digest posts with fields for date, sender, message number, subject and body text - which I'd like to display in it's original form. An ordinary form shows all the html code making the contents difficult to read; is there a simple way of being able to view this so that the correct original message layout is shown, i.e., the html is parsed (is that the right expression)?
Perhaps I should point out I'm a complete novice when it comes to Access; I can write a simple form easily enough, but I have zero knowledge of VBA or anything similar, so non-technical answers or a step by step example would be very much appreciated.
HI .
I have a problem thats over my head.
I use vbs to download the page from a certain URL.In order to import data I go to get external data ,html format.Wizard shows that there are 5 different tables whithin the page.I need only one of them ,and more important I need it automaticly imported everytime I open my DB.
Tnx in advance
I've visited a few forums didnt get an answer.
Here is the URL : http://www.nbs.yu/kl/today.php?vrsta=3
Trying to feed 2 browser components paths to some html docs
browser.Navigate (CurDir + "dirdocument.htm")
browser2.Navigate (CurDir + "dir2document2.htm")
it always looks for these in My Documents directory even if the database is placed somewhere else. why?
thanks for your help,
rob
Hello,
Is is possible to save Access forms in HTML and add data using these forms withouth any kind of special software?
I would like to interact beteween MS Front Page and Access.
I will use front page to design my web site and map to the tables in Access into which add or query data.
Thanks.