KRM240_

Drop Down field - Adobe LiveCycle 28-11-2010

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 question is:If I have the drop down populated already, how do I retrieve the text value of item X from a button?Note: The drop down may be set at 1 (Level 1), I need to retrieve the description of 5 (Level 5...

365

Re: Update and Insert Into query into Access DB - Adobe LiveCycle 20-10-2010

I have been trying to build one.But if I do not know the exact syntax options, it becomes difficult 🙂If I knew where to look for the documentation for this code, then the building of a sample becomes much easier.Ken

247

Re: Update and Insert Into query into Access DB - Adobe LiveCycle 20-10-2010

Yes, this is what I am looking for.Where can I find the syntax (or an example) for this?

248

Re: Update and Insert Into query into Access DB - Adobe LiveCycle 20-10-2010

Unless I am missing something, your link provides a sample on how to use a select queryie: SELECT id as catId, name AS catName FROM movie_categories GROUP BY name ORDER BY name;I have the SELECT query working using the WHERE clause to get a spcific record. Works great.I use this to pre-populate the form. Once I have the forms edited via data input from the users, they send the forms back to an administrator who has the ODBC connection and this admin person will update the database. I would prefe...

245

Update and Insert Into query into Access DB - Adobe LiveCycle 19-10-2010

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 hidden fields to update the databaseI see how this would work, but means I need to have 2x the data fields in my form. To get away from this, I was hoping to have another option.What I would like to d...

2.0K

Re: Drop Down referencing - Adobe LiveCycle 22-09-2010

Yes!this.boundItem(xfa.event.newText) works here!Many thanks

184

Drop Down referencing - Adobe LiveCycle 22-09-2010

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 itemQuestion: How do I get the VALUE of the new selected item?

655

Re: Drop Downs - Adobe LiveCycle 22-09-2010

Thanks allfrom the example I could see what I was doing wrongI found that you need to set the DD.rawValue = to the hidden value that you want, not the Display value (assuming that the 2 are different)

194

Re: Drop Downs - Adobe LiveCycle 22-09-2010

Sorry - should have been more explicitWould like to set these values using JS and if possible, by using either the text value or the hidden value..

194

Drop Downs - Adobe LiveCycle 22-09-2010

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 list specific value of the text selected

839

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe