Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

KRM240_
KRM240_
Offline

Badges

Badges
9

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts

Posts
34

Discussions

Discussions
1

Questions

Questions
33

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by KRM240_
Customize the badges you want to showcase on your profile
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...

Views

365

Likes

0

Replies

1
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

Views

247

Likes

0

Replies

0
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?

Views

248

Likes

0

Replies

0
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...

Views

245

Likes

0

Replies

0
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...

Views

2.0K

Likes

0

Replies

7
Re: Drop Down referencing - Adobe LiveCycle 22-09-2010
Yes!this.boundItem(xfa.event.newText) works here!Many thanks

Views

184

Likes

0

Replies

0
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?

Views

655

Likes

0

Replies

2
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)

Views

194

Likes

0

Replies

0
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..

Views

194

Likes

0

Replies

0
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

Views

839

Likes

0

Replies

5