Importing HTML Code. Not From HTML... ;)
Dec 27, 2004
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
View Replies
ADVERTISEMENT
Apr 12, 2005
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
View 1 Replies
View Related
Apr 27, 2005
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?
View 1 Replies
View Related
Aug 27, 2015
I can create PDF's, DOCX's retaining the PDF formatting save them back to different network locations and then retrieve and attach to emails that are generated for different areas, however I have been asked to scrap the attachment and insert the content of the attachment directly into the body of the email. I have had a good browse around the net with no real approach. The code below simply gets the recepients email address adds the subject and then is looking for the .HTMLBody which simply comes through in the body as
"O:divAKLResgroupE - ReportsHTML FilesDRAFT TEST .html".
.To = RScoloumdetail(2) ' Gets Email Address
.CC = ""
.BCC = ""
[code]....
View 2 Replies
View Related
May 10, 2014
I would like it to be formated the same on the web page as it is in the MS Access code module.For Example:
Code:
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.
' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True
[code]...
Is there a free online HTML code editor that will do this?
View 7 Replies
View Related
Jul 22, 2015
I'm try to centre a logo image in the middle of email but I having issue doing it doesn't seem to matter what I try I can't seem to get it to do what I want . The code below works but doesn't centre the image
Code:
Dim txtLogoURL As String 'this is for your logo
txtLogoURL = "C:UsersDellPicturesoie_transparent.png"
strHTML = strHTML & "<p>"
strHTML = strHTML & "<a href=""http://www.testing.com/""><img border=""0"" src=" _
& txtLogoURL & "' align='Centre' width =200" & " alt=""testing"" /></a>"
View 6 Replies
View Related
Jun 26, 2014
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?
View 10 Replies
View Related
Apr 2, 2007
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!
View 2 Replies
View Related
Apr 19, 2007
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!
View 6 Replies
View Related
Jan 23, 2008
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 :(
View 1 Replies
View Related
Apr 14, 2006
I'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.
View 3 Replies
View Related
May 4, 2007
.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
View 4 Replies
View Related
Mar 14, 2008
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.
View 1 Replies
View Related
Jun 1, 2005
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
View 2 Replies
View Related
Oct 17, 2005
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.
View 2 Replies
View Related
Jun 1, 2015
I have a form that needs to be updated by multiple users. The information must be entered in the following format:
<a href="http://website.com">Write any title here</a> and then they can add a description
The users are not familiar with HTML and often submit it with incorrect syntax. I would like to prevent these errors prior to submission by writing some sort of validation. Is there a way to accomplish this? I imagine a macro is best for this situation. Multiple entries are often entered in a single cell (not sure if this would mess with the validation?)
View 1 Replies
View Related
Dec 6, 2005
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].
View 2 Replies
View Related
Jan 20, 2006
HI!! I've a problem
I have a table with 10 records
I would create many pages html how many are the records :eek:
better still if every page with a various name
It's possible? :confused:
thanks!!! :o
View 14 Replies
View Related
Nov 8, 2007
Hey again all!
Implementation is going fabu, but I had a request to add a button on the main form to open the HTML FAQ I wrote. I thought I would be able to quickly point the button to the file using the button creation wizard, but that doesn't seem to work so well. (not at all)
Did I miss something or is this something that needs to be coded with VBA (very little knowledge of VBA here... negligible even.)
View 1 Replies
View Related
Apr 28, 2005
First quetion
how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever.
i am trying to build somthing like asp with two frames and a record set and i dont know how.
the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.
please advice.
thanks.
View 3 Replies
View Related
May 4, 2005
First quetion
how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever.
i am trying to build somthing like asp with two frames and a record set and i dont know how.
the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.
please advice.
thanks.
View 1 Replies
View Related
Aug 29, 2004
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 Related
Nov 29, 2004
In my website I've created a admin login with some ASP pages to edit and update stories.
I use an acces database and installed HTMLarea for WYSIWYG editing.
When I update text, all the HTML tags show als plain text in my website.
For example: I make a headline bold in my wysiwig editor and I update my text, it just shows: <B> here's a new story </B>
If I look in my database I have a field 'text' wich is a memofield and I can see the html tags have been stored into my database. <B>here's a new story</B>
It looks like it doesnt recognize the html tags as HTML, but just as plain text...
Can I use HTML-tags in an acces database and how do I get them to show up right in my website?
View 1 Replies
View Related
Nov 30, 2004
Hello 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
View 3 Replies
View Related
Dec 9, 2004
I'm using the sendobject method from access and it always puts the body of the email in plain text. Is there a way to specify HTML (besides the obvious of changing the format once it's open)?
Thanks,
C
View 1 Replies
View Related
Apr 1, 2006
I have a scenario at work I need some help with. I'm just checking to make sure it is possible before I dive further into it.
We need a database for approximately 40 people to access at one time. They don't really need to access the database itself just be able to update it.
The question that was posed to me was this: Can we use an HTML page to update the database?
This will not be run through SQL or IIS or anything of that nature. It will just be an HTML page that is accessed through a users folder. On the HTML page will be the input boxes and a submit and reset button.
I made a data access page, but I really don't want the users to be able to go through the previous entries. I also wasn't sure if more than one person could be accessing the page at once.
Is a simple form page with a submit button possible not running on a web server?
View 2 Replies
View Related