PDF-Forms is a service provided by PDFzone.com | http://www.pdfzone.com/
__________________________________________________________________
Hi ALL....
I'm attempting to create a button that will receive info from a Access DB.
When I select the button, It opens the "Select Dada Source" Screen waiting for a DSN
selection. (see attached "pop-up" file). If I select the DNS, all is fine.
I do not want to go around to all PC's that will be accessing the Web form and set up
a DSN.
Is there a way to put the information in a string? What are MY other choices?
All insight would be GREATLY APPRECIATED....
My code is this: (simple at the moment intill I get this problem resolved):
==========
try {
var connectDB = ADBC.newConnection('Tbl_PosReq');
if (connectDB == null) throw "Could not connect";
var statement = connectDB.newStatement();
if (statement == null) throw "Could not execute newStatement";
statement.execute('Select Department from [tbl_PosReq]')
statement.nextRow();
var row = statement.getRow();
this.getField("Department").value = row.Department.value ;
} catch(e) {
app.alert(e);
}
============
To change your subscription:
http://www.pdfzone.com/discussions/lists-pdfforms.html