Solved

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

Posted on 2004-08-29
3
190 Views
Last Modified: 2010-08-05
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
Comment
Question by:kpanitz
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
justinbillig earned 500 total points
ID: 11929922
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
 

Author Comment

by:kpanitz
ID: 11936351
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
 
LVL 15

Expert Comment

by:justinbillig
ID: 11941074
No Problem

BTW here is a really good reference for Javascript


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

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now