• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

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=&quot;urn:schemas-microsoft-com:office:access&quot;>&#13;&#10; <a:DataSourceControl>&#13;&#10;  <a:OWCVersion>9.0.0.3821</a:OWCVersion>&#13;&#10;  <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=&amp;quot;&amp;quot;;Jet OLEDB:Database Password=&amp;quot;&amp;quot;</a:ConnectionString>&#13;&#10;  <a:MaxRecords>10000</a:MaxRecords>&#13;&#10;  <a:GridX>10</a:GridX>&#13;&#10;  <a:GridY>10</a:GridY>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>QTasksNavigation</a:ElementID>&#13;&#10;   <a:ConsumesRecordset/>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>Sections</a:ElementID>&#13;&#10;   <a:ControlSource>Sections</a:ControlSource>&#13;&#10;   <a:ChildLabel>Sections_Label</a:ChildLabel>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>Task No</a:ElementID>&#13;&#10;   <a:ControlSource>Task No</a:ControlSource>&#13;&#10;   <a:ChildLabel>TaskNo_Label</a:ChildLabel>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>Task</a:ElementID>&#13;&#10;   <a:ControlSource>Task</a:ControlSource>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>Detail</a:ElementID>&#13;&#10;   <a:ControlSource>Detail</a:ControlSource>&#13;&#10;   <a:ChildLabel>Detail_Label</a:ChildLabel>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>Comments</a:ElementID>&#13;&#10;   <a:ControlSource>Comments</a:ControlSource>&#13;&#10;   <a:ChildLabel>Comments_Label</a:ChildLabel>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>Checked By</a:ElementID>&#13;&#10;   <a:ControlSource>Checked By</a:ControlSource>&#13;&#10;   <a:ChildLabel>CheckedBy_Label</a:ChildLabel>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>Check Date-Time</a:ElementID>&#13;&#10;   <a:ControlSource>Check Date-Time</a:ControlSource>&#13;&#10;   <a:ChildLabel>CheckDate-Time_Label</a:ChildLabel>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>Confirmed By</a:ElementID>&#13;&#10;   <a:ControlSource>Confirmed By</a:ControlSource>&#13;&#10;   <a:ChildLabel>ConfirmedBy_Label</a:ChildLabel>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>Confirmed Date-Time</a:ElementID>&#13;&#10;   <a:ControlSource>Confirmed Date-Time</a:ControlSource>&#13;&#10;   <a:ChildLabel>ConfirmedDate-Time_Label</a:ChildLabel>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:GroupLevel>&#13;&#10;   <a:RecordSource>Q Tasks</a:RecordSource>&#13;&#10;   <a:DefaultSort></a:DefaultSort>&#13;&#10;   <a:HeaderElementId>HeaderQTasks</a:HeaderElementId>&#13;&#10;   <a:FooterElementId></a:FooterElementId>&#13;&#10;   <a:CaptionElementId></a:CaptionElementId>&#13;&#10;   <a:RecordNavigationElementId>NavigationSectionQTasks</a:RecordNavigationElementId>&#13;&#10;   <a:DataPageSize>1</a:DataPageSize>&#13;&#10;  </a:GroupLevel>&#13;&#10;  <a:Datamodel version=&quot;0816&quot;>&#13;&#10;   <a:SchemaRowsource id=&quot;Q Tasks&quot; type=&quot;dscView&quot;>&#13;&#10;    <a:SchemaField id=&quot;Sections&quot; datatype=&quot;202&quot; size=&quot;50&quot;/>&#13;&#10;    <a:SchemaField id=&quot;Task No&quot; datatype=&quot;131&quot; size=&quot;0&quot;/>&#13;&#10;    <a:SchemaField id=&quot;Task&quot; datatype=&quot;202&quot; size=&quot;255&quot;/>&#13;&#10;    <a:SchemaField id=&quot;Detail&quot; datatype=&quot;203&quot; size=&quot;0&quot;/>&#13;&#10;    <a:SchemaField id=&quot;Comments&quot; datatype=&quot;203&quot; size=&quot;0&quot;/>&#13;&#10;    <a:SchemaField id=&quot;Checked By&quot; datatype=&quot;202&quot; size=&quot;50&quot;/>&#13;&#10;    <a:SchemaField id=&quot;Check Date-Time&quot; datatype=&quot;7&quot; size=&quot;0&quot;/>&#13;&#10;    <a:SchemaField id=&quot;Confirmed By&quot; datatype=&quot;202&quot; size=&quot;50&quot;/>&#13;&#10;    <a:SchemaField id=&quot;Confirmed Date-Time&quot; datatype=&quot;202&quot; size=&quot;50&quot;/>&#13;&#10;    <a:SchemaField id=&quot;Task Type&quot; datatype=&quot;3&quot; size=&quot;0&quot;/>&#13;&#10;    <a:SchemaField id=&quot;Section No&quot; datatype=&quot;202&quot; size=&quot;50&quot;/>&#13;&#10;   </a:SchemaRowsource>&#13;&#10;   <a:RecordsetDef id=&quot;Q Tasks&quot;>&#13;&#10;    <a:PageField id=&quot;Sections&quot;/>&#13;&#10;    <a:PageField id=&quot;Task No&quot;/>&#13;&#10;    <a:PageField id=&quot;Task&quot;/>&#13;&#10;    <a:PageField id=&quot;Detail&quot;/>&#13;&#10;    <a:PageField id=&quot;Comments&quot;/>&#13;&#10;    <a:PageField id=&quot;Checked By&quot;/>&#13;&#10;    <a:PageField id=&quot;Check Date-Time&quot;/>&#13;&#10;    <a:PageField id=&quot;Confirmed By&quot;/>&#13;&#10;    <a:PageField id=&quot;Confirmed Date-Time&quot;/>&#13;&#10;   </a:RecordsetDef>&#13;&#10;  </a:Datamodel>&#13;&#10; </a:DataSourceControl>&#13;&#10;</xml>'&quot;"></OBJECT>
<META content="MSHTML 6.00.2800.1458" name=GENERATOR><!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>Thiess Pty Ltd</o:Author>
  <o:LastAuthor>Thiess Pty Ltd</o:LastAuthor>
  <o:Revision>32</o:Revision>
  <o:TotalTime>129</o:TotalTime>
  <o:Created>2004-08-27T01:05:18Z</o:Created>
  <o:LastSaved>2004-08-30T01:08:11Z</o:LastSaved>
  <o:Company>Thiess Pty Ltd</o:Company>
  <o:Version>9.3821</o:Version>
 </o:DocumentProperties>
 <o:OfficeDocumentSettings>
  <o:DownloadComponents/>
  <o:LocationOfComponents HRef="file://thiess.aus/application$/Software/Office2000SR-1/Professional/msowc.cab"/>
 </o:OfficeDocumentSettings>
</xml><![endif]--></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>&nbsp;<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>&nbsp;</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>&nbsp;</P></BODY></HTML>
0
kpanitz
Asked:
kpanitz
  • 2
1 Solution
 
justinbilligCommented:
you dont have any form tags in your code ... so trying to access the text area via document.formname won't work ..

you should use


document.getElementById( "idName" );

hence in your case you would use

document.getElementById( "Sections" ).value

that will allow you to get / set the value of the text area
0
 
kpanitzAuthor Commented:
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
0
 
justinbilligCommented:
No Problem

BTW here is a really good reference for Javascript


http://www.devguru.com/Technologies/ecmascript/quickref/javascript_index.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now