asked on

MS Access "Page" : Want to use Java to write to textarea. But text area does not appear to be inside form.

I am attempting to write a MS Access Based page to allow access to my database via multiple iPaq over a wireless network. I have in the past used several pocket PC based database systems, but they all reley on maintaining a seperate recordset that is then updated via sync.

I want to have a webpage that links directly to the DB, that way the problems I have been having with multiple users sync'n the same record should be eliminated.

Im a little new to Java and HTML but the I have the following code. with a button I have added.

I want to setup the button to replace the contents of a TEXTAREA, which seems easy enough.. however MS Access does not use the testarea within the form.... so I can't work out how to reference it...

ie document.formname.textareaname.value = ?????

The formname does not exisit...

How can I write to this feild.

Cheers

Ken

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:x =
"urn:schemas-microsoft-com:office:excel" xmlns:a =
"urn:schemas-microsoft-com:office:access" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>Q Tasks</TITLE><LINK
href="./Pre%20-%20Roof%20Raise%20Checklist_files/filelist.xml" type=text/xml
rel=File-List>
<META content=Access.Application name=ProgId>
<META name=VBSForEventHandlers VALUE="TRUE">
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<SCRIPT type=text/javascript>

function Checked()
{
//var user_key = window.prompt("Please enter your Keycode","0");
//window.alert("The Keycode you entered is " + user_key);
//window.alert (HeaderQTasks.Checked_by.value);

window.document.taskform.Checked_By.value = 1;

}

</SCRIPT>

<STYLE id=MSODAPDEFAULTS type=text/css rel="stylesheet">.mstheme-label {
      FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
TEXTAREA {
      FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
.msoboundhtml {
      FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
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
}
.msoHyperlinkDisplayText {
      FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BUTTON {
      FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
.MsoShowDesignGrid {
      BEHAVIOR: url(#DEFAULT#MsoShowDesignGrid)
}
</STYLE>

<OBJECT id=MSODSC
codeBase=\\thiess.aus\application$\Software\Office2000SR-1\Professional\msowc.cab
classid=CLSID:0002E530-0000-0000-C000-000000000046 VIEWASTEXT><PARAM NAME="XMLData" VALUE="<xml xmlns:a="urn:schemas-microsoft-com:office:access">
 <a:DataSourceControl>
 <a:OWCVersion>9.0.0.3821</a:OWCVersion>
 <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=\\darwinlng1\wwwroot$\Database\Roof Raise Checklist.mdb;Mode=Share Deny None;Jet OLEDB:System database=&quot;&quot;;Jet OLEDB:Database Password=&quot;&quot;</a:ConnectionString>
 <a:MaxRecords>10000</a:MaxRecords>
 <a:GridX>10</a:GridX>
 <a:GridY>10</a:GridY>
 <a:ElementExtension>
 <a:ElementID>QTasksNavigation</a:ElementID>
 <a:ConsumesRecordset/>
 </a:ElementExtension>
 <a:ElementExtension>
 <a:ElementID>Sections</a:ElementID>
 <a:ControlSource>Sections</a:ControlSource>
 <a:ChildLabel>Sections_Label</a:ChildLabel>
 </a:ElementExtension>
 <a:ElementExtension>
 <a:ElementID>Task No</a:ElementID>
 <a:ControlSource>Task No</a:ControlSource>
 <a:ChildLabel>TaskNo_Label</a:ChildLabel>
 </a:ElementExtension>
 <a:ElementExtension>
 <a:ElementID>Task</a:ElementID>
 <a:ControlSource>Task</a:ControlSource>
 </a:ElementExtension>
 <a:ElementExtension>
 <a:ElementID>Detail</a:ElementID>
 <a:ControlSource>Detail</a:ControlSource>
 <a:ChildLabel>Detail_Label</a:ChildLabel>
 </a:ElementExtension>
 <a:ElementExtension>
 <a:ElementID>Comments</a:ElementID>
 <a:ControlSource>Comments</a:ControlSource>
 <a:ChildLabel>Comments_Label</a:ChildLabel>
 </a:ElementExtension>
 <a:ElementExtension>
 <a:ElementID>Checked By</a:ElementID>
 <a:ControlSource>Checked By</a:ControlSource>
 <a:ChildLabel>CheckedBy_Label</a:ChildLabel>
 </a:ElementExtension>
 <a:ElementExtension>
 <a:ElementID>Check Date-Time</a:ElementID>
 <a:ControlSource>Check Date-Time</a:ControlSource>
 <a:ChildLabel>CheckDate-Time_Label</a:ChildLabel>
 </a:ElementExtension>
 <a:ElementExtension>
 <a:ElementID>Confirmed By</a:ElementID>
 <a:ControlSource>Confirmed By</a:ControlSource>
 <a:ChildLabel>ConfirmedBy_Label</a:ChildLabel>
 </a:ElementExtension>
 <a:ElementExtension>
 <a:ElementID>Confirmed Date-Time</a:ElementID>
 <a:ControlSource>Confirmed Date-Time</a:ControlSource>
 <a:ChildLabel>ConfirmedDate-Time_Label</a:ChildLabel>
 </a:ElementExtension>
 <a:GroupLevel>
 <a:RecordSource>Q Tasks</a:RecordSource>
 <a:DefaultSort></a:DefaultSort>
 <a:HeaderElementId>HeaderQTasks</a:HeaderElementId>
 <a:FooterElementId></a:FooterElementId>
 <a:CaptionElementId></a:CaptionElementId>
 <a:RecordNavigationElementId>NavigationSectionQTasks</a:RecordNavigationElementId>
 <a:DataPageSize>1</a:DataPageSize>
 </a:GroupLevel>
 <a:Datamodel version="0816">
 <a:SchemaRowsource id="Q Tasks" type="dscView">
 <a:SchemaField id="Sections" datatype="202" size="50"/>
 <a:SchemaField id="Task No" datatype="131" size="0"/>
 <a:SchemaField id="Task" datatype="202" size="255"/>
 <a:SchemaField id="Detail" datatype="203" size="0"/>
 <a:SchemaField id="Comments" datatype="203" size="0"/>
 <a:SchemaField id="Checked By" datatype="202" size="50"/>
 <a:SchemaField id="Check Date-Time" datatype="7" size="0"/>
 <a:SchemaField id="Confirmed By" datatype="202" size="50"/>
 <a:SchemaField id="Confirmed Date-Time" datatype="202" size="50"/>
 <a:SchemaField id="Task Type" datatype="3" size="0"/>
 <a:SchemaField id="Section No" datatype="202" size="50"/>
 </a:SchemaRowsource>
 <a:RecordsetDef id="Q Tasks">
 <a:PageField id="Sections"/>
 <a:PageField id="Task No"/>
 <a:PageField id="Task"/>
 <a:PageField id="Detail"/>
 <a:PageField id="Comments"/>
 <a:PageField id="Checked By"/>
 <a:PageField id="Check Date-Time"/>
 <a:PageField id="Confirmed By"/>
 <a:PageField id="Confirmed Date-Time"/>
 </a:RecordsetDef>
 </a:Datamodel>
 </a:DataSourceControl>
</xml>'""></OBJECT>
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY style="OVERFLOW: auto; WIDTH: 268px; HEIGHT: 260px" bottomMargin=48
vLink=#800080 link=#800080 leftMargin=24 topMargin=24 rightMargin=24>
<CENTER>
<H1 id=HeadingText style="FONT-WEIGHT: normal"><IMG id=Image0 title=Image0
style="WIDTH: 52px; HEIGHT: 44px; TEXT-ALIGN: left" tabIndex=11 height=44
alt=Image0 src="Roof%20Raise%20Checklist_files\image001.bmp"
width=63> <SPAN class=MSTheme-Label id=Label2 title=Label2
style="PADDING-LEFT: 1px; FONT-SIZE: 10pt; OVERFLOW: hidden; WIDTH: 203px; HEIGHT: 43px; TEXT-ALIGN: left">

<P><FONT size=4>Roof Raise Checklist</FONT></P>
<P> </P></SPAN></H1></CENTER>
<DIV class="" id=HeaderQTasksBanner
style="BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP: buttonhighlight 2px outset; DISPLAY: none; PADDING-LEFT: 1px; FONT-WEIGHT: normal; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: buttonhighlight 2px outset; WIDTH: 264px; BORDER-BOTTOM: buttonhighlight 2px outset; FONT-FAMILY: Tahoma; HEIGHT: 0.507cm; BACKGROUND-COLOR: buttonface">Header:
Q Tasks</DIV>
<DIV class=MSOShowDesignGrid id=HeaderQTasks
style="VISIBILITY: hidden; OVERFLOW: hidden; WIDTH: 264px; POSITION: relative; HEIGHT: 222px; BACKGROUND-COLOR: transparent; TEXT-ALIGN: center"
name="HeaderQTasks"><SPAN class=MSTheme-Label id=Sections_Label title=Sections
style="PADDING-LEFT: 1px; LEFT: 0cm; OVERFLOW: visible; WIDTH: 1.375cm; POSITION: absolute; TOP: 0.079cm; HEIGHT: 0.45cm">Sections</SPAN><TEXTAREA id=Sections title=Sections style="LEFT: 1.587cm; OVERFLOW: hidden; WIDTH: 5.316cm; POSITION: absolute; TOP: 0.079cm; HEIGHT: 0.45cm" tabIndex=1 readOnly cols=25></TEXTAREA><SPAN
class=MSTheme-Label id=TaskNo_Label title="Task No"
style="PADDING-LEFT: 1px; LEFT: 0.025cm; OVERFLOW: visible; WIDTH: 1.322cm; POSITION: absolute; TOP: 0.61cm; HEIGHT: 0.45cm">Task</SPAN><TEXTAREA id="Task No" title="Task No" style="LEFT: 1.562cm; OVERFLOW: hidden; WIDTH: 0.925cm; POSITION: absolute; TOP: 0.61cm; HEIGHT: 0.45cm" tabIndex=2 cols=3></TEXTAREA><TEXTAREA id=Task title=Task style="LEFT: 2.619cm; OVERFLOW: hidden; WIDTH: 4.232cm; POSITION: absolute; TOP: 0.61cm; HEIGHT: 0.45cm" tabIndex=3 readOnly cols=8></TEXTAREA><SPAN
class=MSTheme-Label id=Detail_Label title=Detail
style="PADDING-LEFT: 1px; LEFT: 0.025cm; OVERFLOW: visible; WIDTH: 1.243cm; POSITION: absolute; TOP: 1.163cm; HEIGHT: 0.45cm">Detail</SPAN><TEXTAREA id=Detail title=Detail style="LEFT: 1.561cm; OVERFLOW: hidden; WIDTH: 5.317cm; POSITION: absolute; TOP: 1.163cm; HEIGHT: 1.214cm" tabIndex=4 rows=1 readOnly cols=13></TEXTAREA><SPAN
class=MSTheme-Label id=Comments_Label title=Comments
style="PADDING-LEFT: 1px; LEFT: 0.025cm; OVERFLOW: visible; WIDTH: 1.349cm; POSITION: absolute; TOP: 2.433cm; HEIGHT: 0.45cm">Comments</SPAN><TEXTAREA id=Comments title=Comments style="LEFT: 1.587cm; OVERFLOW: hidden; WIDTH: 3.253cm; POSITION: absolute; TOP: 2.433cm; HEIGHT: 1.24cm" tabIndex=5 rows=1 cols=7></TEXTAREA><SPAN
class=MSTheme-Label id=CheckedBy_Label title="Checked By"
style="PADDING-LEFT: 1px; LEFT: 0.025cm; OVERFLOW: visible; WIDTH: 2.751cm; POSITION: absolute; TOP: 3.731cm; HEIGHT: 0.45cm">Checked
By</SPAN> <TEXTAREA id="Checked By" title="Checked By" style="LEFT: 2.779cm; OVERFLOW: hidden; WIDTH: 4.074cm; POSITION: absolute; TOP: 3.731cm; HEIGHT: 0.45cm" tabIndex=6></TEXTAREA>
<SPAN class=MSTheme-Label id=CheckDate-Time_Label title="Check Date-Time"
style="PADDING-LEFT: 1px; LEFT: 0cm; OVERFLOW: visible; WIDTH: 2.751cm; POSITION: absolute; TOP: 4.206cm; HEIGHT: 0.45cm">Check
Date-Time</SPAN><TEXTAREA id="Check Date-Time" title="Check Date-Time" style="LEFT: 2.751cm; OVERFLOW: hidden; WIDTH: 1.72cm; POSITION: absolute; TOP: 4.206cm; HEIGHT: 0.45cm" tabIndex=7></TEXTAREA><SPAN
class=MSTheme-Label id=ConfirmedBy_Label title="Confirmed By"
style="PADDING-LEFT: 1px; LEFT: 0.025cm; OVERFLOW: visible; WIDTH: 2.751cm; POSITION: absolute; TOP: 4.737cm; HEIGHT: 0.45cm">Confirmed
By</SPAN><TEXTAREA id="Confirmed By" title="Confirmed By" style="LEFT: 2.779cm; OVERFLOW: hidden; WIDTH: 4.074cm; POSITION: absolute; TOP: 4.737cm; HEIGHT: 0.45cm" tabIndex=8></TEXTAREA><SPAN
class=MSTheme-Label id=ConfirmedDate-Time_Label title="Confirmed Date-Time"
style="PADDING-LEFT: 1px; LEFT: 0.053cm; OVERFLOW: visible; WIDTH: 2.751cm; POSITION: absolute; TOP: 5.291cm; HEIGHT: 0.45cm">Confirmed
Date-Time</SPAN><TEXTAREA id="Confirmed Date-Time" title="Confirmed Date-Time" style="LEFT: 2.804cm; OVERFLOW: hidden; WIDTH: 4.074cm; POSITION: absolute; TOP: 5.291cm; HEIGHT: 0.45cm" tabIndex=9></TEXTAREA>
<INPUT id=Check_btn style="LEFT: 193px; POSITION: absolute; TOP: 159px" onclick=Checked() type=button value=Checked name=Check_btn>
</DIV>
<DIV class=MicrosoftAccessBanner id=NavigationSectionQTasksBanner
style="BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP: buttonhighlight 2px outset; DISPLAY: none; PADDING-LEFT: 1px; FONT-WEIGHT: normal; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: buttonhighlight 2px outset; WIDTH: 264px; BORDER-BOTTOM: buttonhighlight 2px outset; FONT-FAMILY: Tahoma; HEIGHT: 0.2in; BACKGROUND-COLOR: buttonface">NavigationSection:
Q Tasks</DIV>
<DIV class=MSOShowDesignGrid id=NavigationSectionQTasks
style="VISIBILITY: hidden; OVERFLOW: hidden; WIDTH: 264px; POSITION: relative; HEIGHT: 35px; BACKGROUND-COLOR: transparent">
<OBJECT id=QTasksNavigation
style="LEFT: 8px; WIDTH: 256px; POSITION: absolute; TOP: 5px; HEIGHT: 24px"
codeBase=\\thiess.aus\application$\Software\Office2000SR-1\Professional\msowc.cab
classid=CLSID:0002E531-0000-0000-C000-000000000046 VIEWASTEXT><PARAM NAME="_State" VALUE=""><PARAM NAME="RecordSource" VALUE="Q Tasks"><PARAM NAME="RecordsetLabel" VALUE="Q Tasks |0 of |2;Q Tasks |0-|1 of |2"><PARAM NAME="ShowFirstButton" VALUE="-1"><PARAM NAME="ShowPrevButton" VALUE="-1"><PARAM NAME="ShowNextButton" VALUE="-1"><PARAM NAME="ShowLastButton" VALUE="-1"><PARAM NAME="ShowNewButton" VALUE="0"><PARAM NAME="ShowDelButton" VALUE="0"><PARAM NAME="ShowSaveButton" VALUE="-1"><PARAM NAME="ShowUndoButton" VALUE="-1"><PARAM NAME="ShowSortAscendingButton" VALUE="-1"><PARAM NAME="ShowSortDecendingButton" VALUE="-1"><PARAM NAME="ShowApplyFilterButton" VALUE="-1"><PARAM NAME="ShowToggleFilterButton" VALUE="-1"><PARAM NAME="ShowHelpButton" VALUE="0"><PARAM NAME="ShowLabel" VALUE="0"><PARAM NAME="FontName" VALUE="Tahoma"></OBJECT>
</DIV>
<P> </P></BODY></HTML>

ASKER CERTIFIED SOLUTION

justinbillig

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kpanitz

ASKER

Justin

Thanks for the easy fix, I knew it was just a different tag but like I said my Java/HTML is a little new.. The Points are yours..

Cheers

Ken

justinbillig

No Problem

BTW here is a really good reference for Javascript

http://www.devguru.com/Technologies/ecmascript/quickref/javascript_index.html

MS Access &quot;Page&quot; : Want to use Java to write to textarea. But text area does not appear to be inside form.

MS Access "Page" : Want to use Java to write to textarea. But text area does not appear to be inside form.