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
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
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 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?
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 am simply trying to find text on a Web Browser Control htm page.
Using MS Access 2003, I have a form that includes the activeX Web Browser Control. On load of the form I initialize the web like below:
Code:
Dim strURL As String
strURL = "http://www.justice.gov/eoir/profcond/chart.htm"
Me.WebBrowser0.Navigate strURL
Me.WebBrowser0.Silent = True
The page loads fine.
Now, also, on my form is an unbound text box I call: [txtFind] and a command button I call [cmdFind]. I want [cmdFind] to find the first occurrence of the value in [txtFind]. My code below doesn't do anything when I click the [cmdFind] button.
Code:
Public oRange As Object
Public myfindFirst As Boolean
Public intTextLength As Long
Private Sub cmdFind_Click()
Dim sSearch As String
Dim strText As String
[Code] .....
I am new to Access so forgive me if this is a dumb question. I want to export a report to html but I want for it to be wider. Right now I can export to html but each record gets wrapped so that all the text can fit on a single screen. I would like for my webpage to scroll left-to-right so that each record only takes up a single line.
Here is an example of a report that I exported:
AudioVideo Report
As you can see the Album and Source fields are wrapped so that all the text can fit on the screen. Is there any way that I can make this same webpage but have every record appear on a single line? That way there would be a scroll bar on the bottom of the webpage and you'd just have to scroll to the right in order to read all the information.
Here is an example of how I'd like for it to look:
AudioVideo Report 2
Again, sorry if this is a stupid question. Thanks for your help.
I have a report which includes several subreports. There will be times when a subreport prints partially on one page and completes on the next. I don't always want to break to a new page with this subreport. However, I would want to break to a new page if the subreport cannot fully print on the current page.
View 3 Replies View RelatedI have a report that lists states and cities within the states. When a state name happens to be at the end of the page the individual cities appear on the next page with no State heading. I solved the second page problem by setting the "repeatSection = Yes" in the Section Header (though I haven't shown that in the example below).
But the previous page (which just shows the State Name and no cities looks dumb. Is there some sort of solution.??
(Actually I would also like any State that continues to a next page to not just have the state name but something like
" Colorado (Continued)" Is there anything I can do in VB to make a page break if the section is going to print but therer isn't enough room for one detail line?
This is what I currently see
Alaska
Ancorage
Prudo Bay
California
Whittier
Anaheim
Colorado
------------------------Page Break ---------------------------------
Denver
Pueblo
Colorado Springs
Deleware
Dover
-------------------------------------------------------------------------------------------
Thanks !
If I have a report and it has controls (labels representing column titles) in the page header. Now when I print the report - if it happens that the last page has no detail records - but there is text boxes and so forth in the report footer. Is there a way to not display the page header on the last page?
I have a report where the last page shows the page header - and the field/column labels on the page header - but for which there is no detail records left to display - on the last page. There is report footer information that should display. It just looks weird because the field/column labels show at the top of the page - but there is no data remaining to print under them on that last page.
Hi All,
I have a data access page needs a filter by a dropdownlist, the dropdownlist used is a html control and I use javascript to filter the data programmaticlly in the onchanged event of the control.
MSODSC.DataPages(0).Recordset.Filter="AppID = 3";
My problem is, when this statement runs, the page refreshes. But I don't need the page refreshes, it set the dropdownlist text to the default text, not the value user select. The browser is IE7.
How can I stop the page refresh itself?
Thanks and Happy New Year!!
I have one-page forms which print a second page, blank except for a block of grey shading at the top. I have tried moving the content of the form up but that doesn't eliminate the second page. If I look at print preview, every second page of the entire database shows up as blank, regardless of where that happens to appear in the record.
View 2 Replies View RelatedI have a report that should only show 1 page yet I have 2 and one is blank . I cannot find out why?
View 3 Replies View RelatedI am trying to create an invoice report. I want to add all the costs from the detail section in my footer. I have accomplished this in either the Report footer and/or the page footer, but the problem is that the report footer doesn't go to the bottom of the page, and the page footer doesn't go to just the last page. I have tested a bunch of suggestions that don't seem to work.
1. Print page footer with Report header = NO - only works if your report is two pages or more.
2. Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If Page = Pages Then
Me.[TextBoxName].Visible = True
Else
Me.[TextBoxName].Visible = False
End If
End Sub
The Page functions worked, but it did not change the results from page to page. If it was a two page report, then the if statement is false and the text box was not visible on page 1, but it also was not visible on page 2.
to automatically create a second, third, fourth... page depending on how many characters are in the narrative. The only other thing needed to be changed is the page# of Page#.
So right now my form looks like below
CAD#
Person name
Charge
Narrative
"
"
"
"
"
"
"
"
"
"
"
"
"
Officer name date page # of #
Thanks in advance.
Matt
Hi All
I have added the Allen Browne Calendar 2k control to my form.
My form consists of 4 pages. On pages 2 and 3 I have subforms and on page 4 I have Personal data. Page 1 is general data and the Calendar is on Page 1.
What is happening is that the Calendar is also being displayed on my 4th page, in the same position as page 1. When I try to move it, cover it or delete it from page 4, it is also gone from page 1.
Any suggestions please?
Many thanks
Tee :(
I've used the following code on the footer on print procedure:
Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
Me.PageFooterSection.Visible = (Me.[Page] = 1)
End Sub
This works fine when you view it in print preview, but the footer don't show up at all when you actually print it.The reports default view itself is set print preview.
I have made a report on my query. The page setup is all around merging 0.2" and page size A4
When i view this report in preview it looks all my data whatever i want in a page but after every page it will generate a blank page.
I have included my report.
I have a form with six tabbed pages on it. Since data entry follows in a logical order I would like to put a command button on the bottom of each page (subform) that can be used to go to the next page. What I am going to though? If i put a command button (open form) then it opens the whole form not as a subform on a tabbed page. if I try and put a command button (open page) then it will not let me enter the page number. Hope that makes sense! Any ideas
View 3 Replies View RelatedI am trying to create a report that has the dates go accross the page and not down the page .
Example:
Need:
Jan 2014 Feb 2014 March 2014
Ans so on. I will also need datat under each date.
I am having issues with the reports to give me the output that I need.
I have seen large projects in which there are clearly several printed database reports printed out to make one booklet.
1. How does one get page numbers for multiple reports to go in sequence instead of starting over again at 1 for each report.
2. How can you add a page reference in one report to something in another report?
Do you have to do these things by hand or is there a way to create a something with auto numbering capabilities? Do you do it by importing the reports to MS Word and creating a master document?
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?