Data Access Page Help


G

Guest

Is there a way to send data to the tables as well as to send an e-mail to a
specified e-mail address? Here is my coding... Please assist...

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40"
xmlns:st1="urn:schemas-microsoft-com:blush:ffice:smarttags" xmlns:blush: =
"urn:schemas-microsoft-com:blush:ffice:blush:ffice" xmlns:x =
"urn:schemas-microsoft-com:blush:ffice:excel" xmlns:a =
"urn:schemas-microsoft-com:blush:ffice:access" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD>
<o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:blush:ffice:smarttags"
name="date"></o:SmartTagType>
<OBJECT id=ieooui
classid=clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D></OBJECT><TITLE>Work
Order</TITLE><LINK
href="Work%20Order_files/filelist.xml" type=text/xml rel=File-List>
<META content=FrontPage.Editor.Document name=ProgId>
<META name=VBSForEventHandlers VALUE="TRUE">
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content=10.00.3420 name=DesignerVersion>
<META content="HTML 4.0" name=vs_targetSchema>
<OBJECT id=MSODSC tabIndex=-1
classid=CLSID:0002E553-0000-0000-C000-000000000046><PARAM NAME="XMLData"
VALUE="<xml xmlns:a="urn:schemas-microsoft-com:blush:ffice:access">
<a:DataSourceControl>
<a:OWCVersion>10.0.0.6765 </a:OWCVersion>
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=C:\Documents and Settings\lee.mossolle\My Documents\DATABASES\Lees
Databases\IAG Helpdesk.mdb;Mode=Share Deny None;Extended
Properties=&quot;&quot;;Persist Security Info=False;Jet OLEDB:System
database=&quot;&quot;;Jet OLEDB:Registry Path=&quot;&quot;;Jet OLEDB:Database
Password=&quot;&quot;;Jet OLEDB:Engine Type=0;Jet OLEDB:Database Locking
Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk
Transactions=1;Jet OLEDB:New Database Password=&quot;&quot;;Jet OLEDB:Create
System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy
Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False</a:ConnectionString>
<a:MaxRecords>10000</a:MaxRecords>
<a:GridX>24</a:GridX>
<a:GridY>24</a:GridY>
<a:OfflineType>2</a:OfflineType>
<a:XMLLocation>0</a:XMLLocation>
<a:XMLDataTarget></a:XMLDataTarget>
<a:ConnectionFile></a:ConnectionFile>
<a:ElementExtension>
<a:ElementID>Work OrderNavLabel</a:ElementID>
<a:RecordsetLabel>Work Order |0 of |2;Work Order |0-|1 of
|2</a:RecordsetLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Work Order #</a:ElementID>
<a:ControlSource>Work Order #</a:ControlSource>
<a:ChildLabel>WorkOrder#_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Date</a:ElementID>
<a:ControlSource>Date</a:ControlSource>
<a:ChildLabel>Date_Label</a:ChildLabel>
<a:Format>Short Date</a:Format>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>ContactLastName</a:ElementID>
<a:ControlSource>ContactLastName</a:ControlSource>
<a:ChildLabel>ContactLastName_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Section</a:ElementID>
<a:ControlSource>Section</a:ControlSource>
<a:ChildLabel>Section_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Room #</a:ElementID>
<a:ControlSource>Room #</a:ControlSource>
<a:ChildLabel>Room#_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Computer Make</a:ElementID>
<a:ControlSource>Computer Make</a:ControlSource>
<a:ChildLabel>ComputerMake_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Computer Model</a:ElementID>
<a:ControlSource>Computer Model</a:ControlSource>
<a:ChildLabel>ComputerModel_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Serial Number</a:ElementID>
<a:ControlSource>Serial Number</a:ControlSource>
<a:ChildLabel>SerialNumber_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Description</a:ElementID>
<a:ControlSource>Description</a:ControlSource>
<a:ChildLabel>Description_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Describe Problem</a:ElementID>
<a:ControlSource>Describe Problem</a:ControlSource>
<a:ChildLabel>DescribeProblem_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Tech Assigned</a:ElementID>
<a:ControlSource>Tech Assigned</a:ControlSource>
<a:ChildLabel>TechAssigned_Label</a:ChildLabel>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Start Time</a:ElementID>
<a:ControlSource>Start Time</a:ControlSource>
<a:ChildLabel>StartTime_Label</a:ChildLabel>
<a:Format>Short Date</a:Format>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>End Time</a:ElementID>
<a:ControlSource>End Time</a:ControlSource>
<a:ChildLabel>EndTime_Label</a:ChildLabel>
<a:Format>Medium Time</a:Format>
</a:ElementExtension>
<a:ElementExtension>
<a:ElementID>Repair Actions Taken</a:ElementID>
<a:ControlSource>Repair Actions Taken</a:ControlSource>
<a:ChildLabel>RepairActionsTaken_Label</a:ChildLabel>
</a:ElementExtension>
<a:GroupLevel>
<a:RecordSource>Work Order</a:RecordSource>
<a:DefaultSort></a:DefaultSort>
<a:HeaderElementId>HeaderWorkOrder</a:HeaderElementId>
<a:FooterElementId></a:FooterElementId>
<a:CaptionElementId>CaptionWorkOrder</a:CaptionElementId>

<a:RecordNavigationElementId>NavigationWorkOrder</a:RecordNavigationElementId>
<a:DataPageSize>1</a:DataPageSize>
<a:GroupFilterControl></a:GroupFilterControl>
</a:GroupLevel>
<a:Datamodel a:version="0816">
<a:SchemaRowsource a:id="Work Order" a:type="dscTable">
<a:SchemaField a:id="Work Order #" a:datatype="3" a:size="0" a:iskey="1"/>
<a:SchemaField a:id="Date" a:datatype="7" a:size="0"/>
<a:SchemaField a:id="ContactLastName" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="Section" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="Room #" a:datatype="130" a:size="8"/>
<a:SchemaField a:id="Computer Make" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="Computer Model" a:datatype="130" a:size="15"/>
<a:SchemaField a:id="Serial Number" a:datatype="130" a:size="20"/>
<a:SchemaField a:id="Description" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="Describe Problem" a:datatype="130" a:size="255"/>
<a:SchemaField a:id="Tech Assigned" a:datatype="3" a:size="0"/>
<a:SchemaField a:id="Start Time" a:datatype="7" a:size="0"/>
<a:SchemaField a:id="End Time" a:datatype="7" a:size="0"/>
<a:SchemaField a:id="Repair Actions Taken" a:datatype="130" a:size="255"/>
</a:SchemaRowsource>
<a:RecordsetDef a:id="Work Order">
<a:pageField a:id="Work Order #"/>
<a:pageField a:id="Date"/>
<a:pageField a:id="ContactLastName"/>
<a:pageField a:id="Section"/>
<a:pageField a:id="Room #"/>
<a:pageField a:id="Computer Make"/>
<a:pageField a:id="Computer Model"/>
<a:pageField a:id="Serial Number"/>
<a:pageField a:id="Description"/>
<a:pageField a:id="Describe Problem"/>
<a:pageField a:id="Tech Assigned"/>
<a:pageField a:id="Start Time"/>
<a:pageField a:id="End Time"/>
<a:pageField a:id="Repair Actions Taken"/>
</a:RecordsetDef>
</a:Datamodel>
</a:DataSourceControl>
</xml>"></OBJECT>
<META content="Microsoft FrontPage 5.0" name=GENERATOR>
<STYLE id=MSODAPDEFAULTS type=text/css>.MSTheme-Label {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px;
FONT-SIZE: 8pt; OVERFLOW: visible; BORDER-LEFT: 0px; WIDTH: 1in;
BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; HEIGHT: 0.156in; TEXT-ALIGN: left
}
..MsoTextbox {
PADDING-RIGHT: 3px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden;
WIDTH: 1in; FONT-FAMILY: Tahoma; HEIGHT: 0.197in
}
..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.2in; 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/redi...s&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:Revision>3</o:Revision>
<o:TotalTime>2</o:TotalTime>
<o:Created>2006-05-05T15:45:08Z</o:Created>
<o:LastSaved>2006-05-05T15:50:00Z</o:LastSaved>
<o:Version>11.6568</o:Version>
</o:DocumentProperties>
<o:OfficeDocumentSettings>
<o:RemovePersonalInformation/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<STYLE>st1\:* {
BEHAVIOR: url(#ieooui)
}
</STYLE>
</HEAD>
<BODY style="OVERFLOW: auto" vLink=#800080 link=#0000ff>
<CENTER>
<H1 class="" id=HeadingText>Information Technology Office</H1>
<P class=""><STRONG><FONT size=5>Trouble Ticket</FONT></STRONG></P></CENTER>
<DIV class=Mso2dSectionBanner id=CaptionWorkOrderBanner
style="MARGIN-LEFT: 0px; WIDTH: 6.792in" tabIndex=-1><SPAN
id=CaptionWorkOrderBannerCaption>Caption: Work Order</SPAN></DIV>
<DIV class=Mso2dSection id=CaptionWorkOrder
style="FONT-WEIGHT: bold; VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH:
6.792in; COLOR: white; HEIGHT: 0.396in; BACKGROUND-COLOR: steelblue"></DIV>
<DIV class=Mso2dSectionBanner id=HeaderWorkOrderBanner
style="MARGIN-LEFT: 0px; WIDTH: 6.792in" tabIndex=-1><SPAN
id=HeaderWorkOrderBannerCaption>Header: Work Order</SPAN></DIV>
<DIV class=Mso2dSection id=HeaderWorkOrder
style="VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 6.792in; HEIGHT:
3.5in"><SPAN
class=MSTheme-Label id=WorkOrder#_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 0.042in; HEIGHT: 0.177in">Work
Order #:</SPAN><TEXTAREA class=MsoTextbox id="Work Order #" style="LEFT:
1.125in; WIDTH: 154px; POSITION: absolute; TOP: 0.042in; HEIGHT: 17px;
TEXT-ALIGN: center" tabIndex=15 rows="1" cols="20"></TEXTAREA><SPAN
class=MSTheme-Label id=Date_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 0.292in; HEIGHT: 0.177in">Date:</SPAN><?xml:namespace
prefix = st1 /><st1:date><TEXTAREA class=MsoTextbox id=Date style="LEFT:
1.125in; WIDTH: 156px; POSITION: absolute; TOP: 0.292in; HEIGHT: 17px;
TEXT-ALIGN: center" tabIndex=16 cols=41 rows="1"></TEXTAREA></st1:date><SPAN
class=MSTheme-Label id=ContactLastName_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 0.542in; HEIGHT: 0.177in">ContactLastName:</SPAN><TEXTAREA
class=MsoTextbox id=ContactLastName style="LEFT: 1.125in; WIDTH: 154px;
POSITION: absolute; TOP: 0.542in; HEIGHT: 17px; TEXT-ALIGN: center"
tabIndex=17 rows="1" cols="20"></TEXTAREA><SPAN
class=MSTheme-Label id=Section_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 0.792in; HEIGHT: 0.177in">Section:</SPAN><TEXTAREA class=MsoTextbox
id=Section style="LEFT: 1.125in; WIDTH: 154px; POSITION: absolute; TOP:
0.792in; HEIGHT: 17px; TEXT-ALIGN: center" tabIndex=18 rows="1"
cols="20"></TEXTAREA><SPAN
class=MSTheme-Label id=Room#_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 1.042in; HEIGHT: 0.177in">Room
#:</SPAN><TEXTAREA class=MsoTextbox id="Room #" style="LEFT: 1.125in; WIDTH:
60px; POSITION: absolute; TOP: 1.042in; HEIGHT: 17px; TEXT-ALIGN: center"
tabIndex=19 rows="1" cols="20"></TEXTAREA><SPAN
class=MSTheme-Label id=ComputerMake_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 1.292in; HEIGHT: 0.177in">Computer
Make:</SPAN><TEXTAREA class=MsoTextbox id="Computer Make" style="LEFT:
1.125in; WIDTH: 154px; POSITION: absolute; TOP: 1.292in; HEIGHT: 17px;
TEXT-ALIGN: center" tabIndex=20 rows="1" cols="20"></TEXTAREA><SPAN
class=MSTheme-Label id=ComputerModel_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 1.542in; HEIGHT: 0.177in">Computer
Model:</SPAN><TEXTAREA class=MsoTextbox id="Computer Model" style="LEFT:
1.125in; WIDTH: 79px; POSITION: absolute; TOP: 1.542in; HEIGHT: 17px;
TEXT-ALIGN: center" tabIndex=21 rows="1" cols="20"></TEXTAREA><SPAN
class=MSTheme-Label id=SerialNumber_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 1.792in; HEIGHT: 0.177in">Serial
Number:</SPAN><TEXTAREA class=MsoTextbox id="Serial Number" style="LEFT:
1.125in; WIDTH: 104px; POSITION: absolute; TOP: 1.792in; HEIGHT: 17px;
TEXT-ALIGN: center" tabIndex=22 rows="1" cols="20"></TEXTAREA><SPAN
class=MSTheme-Label id=Description_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 2.042in; HEIGHT: 0.177in">Description:</SPAN><TEXTAREA class=MsoTextbox
id=Description style="LEFT: 1.125in; WIDTH: 154px; POSITION: absolute; TOP:
2.042in; HEIGHT: 17px; TEXT-ALIGN: center" tabIndex=23 rows="1"
cols="20"></TEXTAREA><SPAN
class=MSTheme-Label id=DescribeProblem_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 2.292in; HEIGHT: 0.177in">Describe
Problem:</SPAN><TEXTAREA class=MsoTextbox id="Describe Problem" style="LEFT:
1.125in; WIDTH: 304px; POSITION: absolute; TOP: 2.292in; HEIGHT: 17px;
TEXT-ALIGN: center" tabIndex=24 rows="1" cols="20"></TEXTAREA><SPAN
class=MSTheme-Label id=TechAssigned_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 2.542in; HEIGHT: 0.177in">Tech
Assigned:</SPAN><TEXTAREA class=MsoTextbox id="Tech Assigned" style="LEFT:
1.125in; WIDTH: 304px; POSITION: absolute; TOP: 2.542in; HEIGHT: 17px;
TEXT-ALIGN: center" tabIndex=25 cols=77 rows="1"></TEXTAREA><SPAN
class=MSTheme-Label id=StartTime_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 2.792in; HEIGHT: 0.177in">Start
Time:</SPAN><TEXTAREA class=MsoTextbox id="Start Time" style="LEFT: 1.125in;
WIDTH: 304px; POSITION: absolute; TOP: 2.792in; HEIGHT: 17px" tabIndex=26
cols=78 MsoTextAlign="General" rows="1"></TEXTAREA><SPAN
class=MSTheme-Label id=EndTime_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.083in; POSITION: absolute;
TOP: 3.042in; HEIGHT: 0.177in">End
Time:</SPAN><TEXTAREA class=MsoTextbox id="End Time" style="LEFT: 1.125in;
WIDTH: 304px; POSITION: absolute; TOP: 3.042in; HEIGHT: 17px" tabIndex=27
cols=77 MsoTextAlign="General" rows="1"></TEXTAREA><SPAN
class=MSTheme-Label id=RepairActionsTaken_Label
style="LEFT: 0.042in; OVERFLOW: hidden; WIDTH: 1.296in; POSITION: absolute;
TOP: 3.292in; HEIGHT: 0.177in">Repair
Actions Taken:</SPAN><TEXTAREA class=MsoTextbox id="Repair Actions Taken"
style="LEFT: 1.412in; WIDTH: 276px; POSITION: absolute; TOP: 3.292in; HEIGHT:
17px" tabIndex=28 cols=1 MsoTextAlign="General" rows="1"></TEXTAREA></DIV>
<DIV class=Mso2dSectionBanner id=NavigationWorkOrderBanner
style="MARGIN-LEFT: 0px; WIDTH: 6.792in" tabIndex=-1><SPAN
id=NavigationWorkOrderBannerCaption>Navigation: Work Order</SPAN></DIV>
<DIV class=Mso2dSection id=NavigationWorkOrder
style="VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 6.792in; HEIGHT:
0.437in; BACKGROUND-COLOR: gainsboro">
<TABLE class=MsoNavContainer id=WorkOrderNavigation
style="LEFT: 4px; WIDTH: 568px; POSITION: absolute; TOP: 4px; HEIGHT: 18px"
cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavFirst id="Work OrderNavFirst" tabIndex=1
src="owc://GIF/#11200"></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavPrevious id="Work OrderNavPrevious" tabIndex=2 height=20
src="owc://GIF/#11202" width=20></TD>
<TD style="VERTICAL-ALIGN: middle; WIDTH: 100%; TEXT-ALIGN: center"
noWrap><SPAN class=MsoNavRecordsetLabel id="Work OrderNavLabel"
style="VISIBILITY: hidden" tabIndex=3>Work Order |0 of |2</SPAN></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavNext id="Work OrderNavNext" tabIndex=4 height=20
src="owc://GIF/#11204" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavLast id="Work OrderNavLast" tabIndex=5 height=20
src="owc://GIF/#11206" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavAddNew id="Work OrderNavNew" tabIndex=6 height=20
src="owc://GIF/#11208" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavDelete id="Work OrderNavDelete" tabIndex=7 height=20
src="owc://GIF/#11210" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavSave id="Work OrderNavSave" tabIndex=8
src="owc://GIF/#11214"></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavUndo id="Work OrderNavUndo" tabIndex=9 height=20
src="owc://GIF/#11212" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavSortAsc id="Work OrderNavSortAscending" tabIndex=10
height=20
src="owc://GIF/#11216" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavSortDesc id="Work OrderNavSortDescending" tabIndex=11
height=20 src="owc://GIF/#11218" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavFilter id="Work OrderNavFilterBySelection" tabIndex=12
height=20 src="owc://GIF/#11220" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavToggleFilter id="Work OrderNavFilterToggle" tabIndex=13
height=20 src="owc://GIF/#11222" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavHelp id="Work OrderNavHelp" tabIndex=14 height=20
src="owc://GIF/#11224" width=20></TD></TR></TBODY></TABLE></DIV>
<P> </P></BODY></HTML>
 
Ad

Advertisements

K

Ken Snell \(MVP\)

From a Data Access Page (DAP), you can use an ADO recordset to add records
to a table. That can be done in VBScript (the programming language commonly
used in DAPs.
--

Ken Snell
<MS ACCESS MVP>


lmossolle said:
Is there a way to send data to the tables as well as to send an e-mail to
a
specified e-mail address? Here is my coding... Please assist...


< snipped >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top