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
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
Till now I managed to publish and save all in C:Reports. What I'm trying to do is Save to path specified in Path. DB attached.
Private Sub PrintAll_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim MyPath As String
Dim MyFileName As String
[Code] ....
After some help from one of the threads here I managed to install a Browse button in a form that inserts a file path to a text box. What I need is the folder path from that file path in another text box. For example if the file path is
C:Documents and SettingsmixupSketchesowl.jpg
I would like to get either
C:Documents and SettingsmixupSketches
Or,
C:Documents and SettingsmixupSketches
in my second text box.
I do not have much experience with Access; therefore please give a little detail on how to accomplish this.
Thanks.
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!
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 :(
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.
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
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 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?)
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].
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
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.)
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.
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.
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 RelatedIn 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?
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
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
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?
TextBox1 is Rich Text:-
I want to replace my String ("Evidence required of this please" ) in this code 1) following which works fine, with a variable (textToPaste) as in code 2) which doesn't work.
1) TextBox1 = "<div><font style=""BACKGROUND-COLOR:#FFFF00"">Evidence required of this please</font>"
2) TextBox1 = "<div><font style=""BACKGROUND-COLOR:#FFFF00"">textToPaste</font>"
Can I persuade the statement to accept "textToPaste" as a variable and not a normal string?
If I have an XML file, I can load it into an XML document and parse it.
For an HTML file, I have been unable to find similar parsing methods - that is, using DOM and not involving a browser (other than simply treating the file as text). I'd prefer to avoid the browser control because it is different for a number of different Access versions, so the only option remaining that I see is to run Internet Explorer with visibility off.
Can one parse HTML using the DOM without a browser?