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.
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
.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
first i'm sorry on my english.
I have in my work some computers with network.
I want to send mail to one computer, the mail is like form in HTML
have 3 things:
1. textbox
1 select
1 submit
is it possible to get the mail and to write in the mail and send it (by submit button) then to update the access db.
I have no idea.
if there is an easy way to do it, I will happy to hear.
[I think to do it with an asp page in each computer that the HTML send the items to the ASP page (by request.get) then the asp page update the db].
I'm updating a database that automatically sends an email to the drafts folder of Outlook. The developer that created the database used VBA code to call html code written in a table. The html code contains the body of the letter. I've figured out most of it but I need to include a date (one month from the current date) in the body of the letter. Unfortunately I've been researching java script and html all weekend and still haven't managed to figure that one out. Can anyone out there help with this? Also is this normal to include html and javascript in Access, I have never seen it before. Are the benefits good? I have serious studying to do if this is the case.
View 1 Replies View RelatedHello 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
Hi im kinda a newbie here so, any helpful comments or links of creating a ms access database where it can be viewed in html is welcome. thanks
View 1 Replies View RelatedHas anyone else encountered this?
I wrote a Access 2000 database which has a linked table to a HTML file which worked perfectly. However, I Have recently installed Access 2007 and now when I use my database to try to open the HTML linked table it says it is either empty or not in the right format!
Any ideas anyone?
Regards,
Dalien51
HI All,
I have scoured the net and these forums looking for the answer but cannot find a good solution.
I am producing flow charts in Visio, and then saving them as HTML documents for use on our Intranet. Within the Visio flow diagrams I am using Hyperlinks on various shapes and text, to enable the viewer to open various other documents in various other applications. This seems to work fine in my web browser for normal office documents, like word and excel, but I need to be able to do it for MS Access databases too! Because the web browser tries to open it in the browser itself, the database won't open and I just get the normal "Web Page Could not be found" screen.
Another useful feature would be to be able to open to a number of different specific forms from a database, depending on which hyperlink is clicked. I assume this is not possible as you only seem to be able to define on page to be displayed upon opening the DB. Am I correct?
Any assistance would be greatly appreciated.
I did not know where to ask this question or how to ask, so please excuse me.
We have an Access 2007 database that updates an Access 2003 database. My problem is, the data in 2007 is formatted and when the 2003 table is updated, it displays the html formatting tags. Is there a way to remove the formatting (convert to plain text from rich text?) during the update?
Could anyone explain me the best way to fill external HTML pages automatically with data from an Access dbase?
I have spotted several commercial tools that use macro recording. Surely there must be another way using visual basic for example?
Hi,
I have a database which I can add to, edit and delete via an asp.net page, it also allows me to add html tags.
My problem is when the data is then rebinded to the page any HTML tags are changed from '<' to '<' and from '>' to '>' this results in the tags and contents being displayed on the page as text instead of being interpreted as HTML and then formatting the page - most frustrating!
Any help is greatly appreciated, this is a relatively new area for me so many thanks in advance.
Steve
I have a database to send e-mails from access trough Outlook. The issue is that I would like the body of the e-mail to have hyperlinks, colours, bolds and that I can get it from plain text.
This is the code I have:
Dim MyDB As Database
Dim MyRS As Recordset
Dim MyTable As Recordset
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim objOutlookAttach As Outlook.Attachment
[Code] ....
How can I make the body to be HTML format, or, can I have a e-mail template storaged in my PC and then indicate to use it whenever the e-mail is sent?
I want to import HTML data which I get with email, to MS Access (2007). The problem is that files are badly formatted and standard import options are not avaliable for me.Basicly part of a file looks like that:
Code:
<tr>
<td style="font:bold 11px/15px Arial,Geneva,Helvetica;width:220px">Name</td>
<td style="font:normal 11px/15px Arial,Geneva,Helvetica">:</td>
<td style="font:normal 11px/15px Arial,Geneva,Helvetica">John</td>
</tr>
Before and after that there are many lines of code which is useless to me. Is there a way to access "Name", connect it to a row in my Access table and insert it's value (John) into the table?
I am trying to build a database to store product information and also the product page in HTML. I was able to do this in MS Access, however the export process would alter the code....(the field is in long text, and in Rich Text format)
For example, this is the code I store in the table:
<html>
<head>
<title></title>
</head>
<body>
........
</body>
</html>,
however when I exported in Text File or XML File, < got replaced by < and > got replaced by > the code after export becomes:
<div><html xmlns=""></div>
<div><head></div>
<div><title></title></div>
<div></head></div>
<div><body></div>
..................................
<div></tbody></div>
<div></table></div>
<div><!--End Template FreeAuctionDesigns.com Copyright 2008 All Rights Reserved.--></body></div>
<div></html></div>
Good morning! I'm using Access to redesign our company's electronic phonebook. Our intranet uses SharePoint technology and our IT people have cranked our security settings up pretty high, so I can't use data access pages or ASP. Therefore, I'm going to use static HTML, producing a single page which the CEO's secretary will upload once a month, allowing our 800+ employees to view the entire phonebook at once. CTRL-F is their friend.
I've managed to design a data access page that looks very much like we want it to, but I don't know how to export it to static HTML. Can such a thing be done, or am I just being wacky? If so, is there a way to automate it so the secretary can just push a button to generate the page?
Thanks,
Andreas
I have small program in access database which contains about 100 cca tables, querys, forms, macros in total. Customer which both program from me, wants me to enable him to access this program not just from work, it wants to access it from home or when he is on business trip from hotel etc.
I am little confused how to achieve this and what are my options? I assume I have to set by database somewhere on server and so my customer could access it any time? Do I have to upsize access database to SQL express or similar?
Also, one more important question: is it possible to "convert" access database into HTML code or similar so it could be accessed via web browser without need to install microsoft access and with freedom that it can be opened from any type of PC OS (Linux, Mac etc)?
I am new to microsoft access and i am currently using microsoft access 2010...I have a students table in my access database and i have now append this table with data from a HTMLhow can i do that? using append query
View 10 Replies View RelatedI have a downtime system that was created by our IT department that records the downtime of the line stops, it has export to excel button that will export the downtime to excel based off the parameters of date and time. I want to do the export then import to access for downtime analysis. The problem I am having is the programmers export it as HTML with .xls file format. and the worksheet has a date associated with it as well as the spreadsheet has a tab that contains a date and I can't figure away to import to a fixed table. So I tried the transfer spreadsheet not knowing it was in HTML, couldn't recognize the format, then I tried transfer HTML, can't find the file because of .xls file format. I know I could re-save it as a excel file but was trying to keep the steps to a min. Is there a way to import even though it has a date attached to the file and spreadsheet tab.
View 7 Replies View RelatedI use this bit of code to generate an Outlook email body with the contents of strBody. How can I modify this so the HTML generated is in "Courier new" font size 11?
With MailOutLook
.To = Recipient
.CC = RecipientCopy
.Subject = Subject
.BodyFormat = olFormatHTML
.Body = StrBody
.display
End With
Can i make an html of login form, whose data is saved in access as back end. I am curious to know. but of course simultaneous saving is considered yes in here...
View 1 Replies View RelatedCan I use html to format the message body in send object method ? If I can, how to do that.
View 5 Replies View RelatedI'm about to connect my DB to word. So I made a form where the user has to choose what entry to export. The data is inserted in a word file in different bookmarks. But there is one special task to insert the rich text so in this case the html formatted text is displayed like this:
Code:
<html><div>asdf</div></html>
My Text is inserted like this:
Code:
wdApp.ActiveDocument.Bookmarks("-Bookmarkname-").Range.Text = Lrs("-ColumnName-")
Lrs is a Recordset.
So how is it possible to display the html code right in the Word doc?
My company recently upgraded our MS Office from 2007 to 2010 (except for Access).
Previously, when I had Access 2007 and Outlook 2007, I had a process that generated 50+ dynamic emails from an Outlook template file (.oft).
The code would loop through a listbox and replace the template's default text to a string of text specific to the selection in the listbox by utilizing the Replace() function on the MailItem .HTMLBody.
Since the upgrade to Outlook 2010, the code is able to run, however, the Replace() function is no longer working; Instead, each email that is generated maintains the template's default text.
The only thing that is not working is the Replace() function, all other aspects of the code work fine.
I've provided a simplified version of the code below:
Dim myOlApp As Outlook.Application
Dim objMailMessage As MailItem
Dim stBody As String
Set myOlApp = Outlook.Application
Set objMailMessage = myOlApp.CreateItemFromTemplate("C:UsersDesktop emplate.oft")
[Code] .....
I've recreated the template file in Outlook 2010, thinking that the template created with Outlook 2007 would be the culprit, but to no avail.
What could have changed from Outlook 2007 to Outlook 2010 that would render my previously valid code ineffective?
Are there certain references I need to enable in both Access and Outlook to allow VBA in Access modify the content in an Outlook email?
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.
Hello
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!