I have a drop down that is pre-populated from Access.The drop down uses both values and text description.ie: 1, Level 1; 2, level 2; 3, Level 3 etcIn another section of the form, I need to retrieve the text description of a specific value of a drop down based on a different field value.So my questio...

I have seen examples (and have them working) of the select * queries with Access to prepopulate a form.My question is is it possible to use a data connection with an update or INSERT INTO queryI have seen an example on PDF Scripting with hidden fields and connecting to the Database, then update the ...

I have a drop down list as follows:Text, valueJan, 1Feb, 2....Dec, 12Select Mth, 0 (Default)I wish to use the change event and get the new value.this.xfa.event.newText = the new selected TEXT itemthis.xfa.event.prevText = previous selected TEXT itemthis.rawValue = VALUE of the previous selected item...

Question on drop downs:How does one PRE set a drop down list value with a set choice. (ie: not changing the raw data behind the drop down but choosing one value to initially display - eg: select the current yr within a group of years)Interested in knowing how to set using  specific text within the l...

Is there a function that can convert an ascii code to the proper character?ie: in excel, one can use code() and char() to go back and forth.Found some ref to \u0041 = A, but not sure if this is the right method?Any assistance greatly appreciated.

Trying to create a button to save the form data in xml format with a specified path and file name.My understanding is this is not possible.It is possible to save but the user must choose the file name and path. ie: xfa.host.exportData("", false);Is this true even if using a trusted function??Can som...

I have seen code examples using getFieldWanted to try it: So I have a field on my form called nYearBut when I use this codevar nYear = this.getField("nYear").value;I get the errorthis.getField is not a function2:XFA:myday[0]:Page1[0]:Button1[0]:clickAny ideas why?

Is there a way to jump to another page if a button is clicked?ie: an index at the top and buttons to go to various parts of the form.

Does anyone have sample code that can show me how to link a drop down to a remote database tableie: I have a list of projects by year and I would like to have the drop down show me all projects for 1 specific year where more than 1 year is present.I am not sure which way to do this, read all the dat...

Curious, has anyone recently ported over to Windows 7 64 bit version from Vista and having ODBC issues?I have a very simple form that works fine on Vista 64, but when I connect with Windows 7 64 bit,  it stops working.Looks like the 32 bit ODBC drivers work a little better, but not much.So questions...