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

Jstaab
Jstaab
Offline

Badges

Badges
11

Accepted Solutions

Accepted Solutions
1

Likes

Likes
2

Posts

Posts
30

Discussions

Discussions
6

Questions

Questions
24

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by Jstaab
Customize the badges you want to showcase on your profile
Re: Script to exclude field from calculations - Adobe LiveCycle 11-12-2012
Thank you for responding. I tried this, but I think my script is wrong:if (Court.rawValue == 1){ this.rawValue = 0;} else{ this.rawValue = (Fine+PassFine)*.7;}Any suggestions.Tracy

Views

202

Likes

0

Replies

0
Script to exclude field from calculations - Adobe LiveCycle 10-12-2012
Merry Christmas everyone.I am creating a form in Designer that includes a calculation. I need script to set the value of a particular field to zero and then exclude it from re-calculating when a particular selection is made in a drop-down list. Setting the presence to "inactive" works great, except that it is highly likely that some people using the form will not be using a newer version of reader. Is there a way to do this with script?

Views

804

Likes

0

Replies

3
Re: Dynamic Drop Down Lists with MS Access Database - Adobe LiveCycle 13-09-2011
I GOT IT! Paul, you are amazing!!! Every time I get to the end of my rope and finally ask for help, I figure it out before I get the answer. Maybe I should start asking sooner.My problem was in the second data connection. I was still linking the second data connection to a table. I changed this to a SQL command " SELECT * FROM WHERE 0=1Then it worked! Oh, I am sooooo excited. The things I can with this. Skippyidy Doo Dah.... Thank you a million times over.

Views

1.1K

Likes

0

Replies

0
Re: Dynamic Drop Down Lists with MS Access Database - Adobe LiveCycle 13-09-2011
You are correct. The actual SQL statement reads: oDataConn.nodes.item(1).query.select.nodes.item(0).value = "SELECT * FROM CourtDate WHERE Ctrm_ID = " + this.rawValue;

Views

1.1K

Likes

0

Replies

0
Re: Dynamic Drop Down Lists with MS Access Database - Adobe LiveCycle 13-09-2011
Yes (many times) I also found a pdf example called "populating a drop down list from database" which was very helpful. In an attempt to simplify (and learn the concept) I have tried setting up just two dropdown lists, with the second one being populated based on the selection in the first DDL. I am figuring out that DDL2 should not be linked in any way to the database when it is created. Then, in the exit event of DDL1, I have the following code (without the brackets):var oDataConn = xfa.sourceS...

Views

1.1K

Likes

0

Replies

3
Re: Dynamic Drop Down Lists with MS Access Database - Adobe LiveCycle 13-09-2011
Thank you! Everyone working on this form has the standard version of Acrobat, so extending the form is not an issue. I have watched your video on connecting to a database several times, and it is what finally helped me accomplish this. But every attempt I make at these dynamic drop downs fails miserably. I would really appreciate your help.P.S. I should have posted this on the Designer forum not the Forms forum, but I don't know how to change it.

Views

1.1K

Like

1

Replies

5
Dynamic Drop Down Lists with MS Access Database - Adobe LiveCycle 13-09-2011
Hello and thank you for looking at my problem.I am trying to create dynamic or cascading drop down lists in Livecycle Designer ES2 v.9. I need a total of three drop down lists. The third DDL would provide three or four possible dates depending on the selections made in DDL1 and DDL2. The list items in DDL1 and DDL2 do not change. DDL1 is to identify the first letter of the person's last name (which is already stated in a previous DDL linked to an Access Database). DDL2 is the event being request...

Views

282

Likes

0

Replies

0
Dynamic Drop Down Lists with MS Access Database - Adobe LiveCycle 12-09-2011
Hello and thank you for looking at my problem.I am trying to create dynamic or cascading drop down lists in Livecycle Designer ES2 v.9. I need a total of three drop down lists. The third DDL would provide three or four possible dates depending on the selections made in DDL1 and DDL2. The list items in DDL1 and DDL2 do not change. DDL1 is to identify the first letter of the person's last name (which is already stated in a previous DDL linked to an Access Database). DDL2 is the event being request...

Views

5.3K

Like

1

Replies

7
Reset Button deletes database information - Adobe LiveCycle 02-05-2011
Greetings: I have a developed a form connected to an Access database that scrolls through the records. The print button executes several commands to clean up the form by eliminating information that is not used. In order to the get the form back to the original condition and clear the existing record, I have included a reset button. I have discovered however, that the reset button deletes information in the database. In other words, once you hit reset, there is no going back and re-doing the for...

Views

295

Likes

0

Replies

0
Re: Does "inactive" presence work in Reader x? - Adobe LiveCycle 26-01-2011
Form users are working in Reader x (ten). I was getting a different error message when they were using the older version of reader, so I had them update. Now, when they hit the submit button, users are getting a message that all mandatory fields have not been filled out. The user should not get this message if the subform with the mandatory field is still inactive. Any solutions?

Views

206

Likes

0

Replies

0
Likes from