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

Likes
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
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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

329

Likes

0

Replies

1
Re: Update and Insert Into query into Access DB
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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

186

Likes

0

Replies

0
Re: Update and Insert Into query into Access DB
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
Yes, this is what I am looking for.Where can I find the syntax (or an example) for this?

Views

187

Likes

0

Replies

0
Re: Update and Insert Into query into Access DB
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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

184

Likes

0

Replies

0
Update and Insert Into query into Access DB
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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

1.9K

Likes

0

Replies

7
Re: Drop Down referencing
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
Yes!this.boundItem(xfa.event.newText) works here!Many thanks

Views

152

Likes

0

Replies

0
Drop Down referencing
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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

623

Likes

0

Replies

2
Re: Drop Downs
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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

131

Likes

0

Replies

0
Re: Drop Downs
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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

131

Likes

0

Replies

0
Drop Downs
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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

776

Likes

0

Replies

5
Re: Ascii Codes
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
Thanks - this solved my issue.

Views

425

Likes

0

Replies

0
Ascii Codes
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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.

Views

1.5K

Likes

0

Replies

2
Button to save XML Data
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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 some one please confirm this.Also, if I can not save XML, can I save in another format (ie: text) to a specified path and file name?Next, if not possible, I read that the doc must be certified and then I...

Views

434

Likes

0

Replies

1
Re: Sample Forms
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
If you did a standard instal, look hereC:\Program Files (x86)\Adobe\Acrobat 9.0\Designer 8.2\EN\Samples\Forms

Views

100

Likes

0

Replies

0
getField
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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?

Views

1.4K

Likes

0

Replies

1
Re: Database connection and what is the best method
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
Case solved, used data drop down lists from the custom object library and with slight mod in the code, have it all working just great.

Views

140

Likes

0

Replies

0
Re: Windows 7 64 bit and ODBC connections
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
64 bit drivers do NOT work, while the 32 bit drivers do.Took awhile, but finally got them doing what they need to do.

Views

123

Likes

0

Replies

0
Re: 2 Drop downs to Filter Data
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
Case closed - have it working. Look at the custom drop down lists and pull down a Data drop-down, the code needs work, but it works!

Views

121

Likes

0

Replies

0
Jump code
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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.

Views

340

Likes

0

Replies

1
Re: Drop down with filtered ODBC data source
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
Problem solved, was able to get 3 drop downs to work that filter the ODBC data that I needed.Solution was actually in the Custom object library "Data DropDownList"Had to make some code changes, but works!Oh yes, the other issue is I believe that there is a bug with the ODBC drivers for Windows 7 64 bit. I could only get the 32 bit drivers to work.

Views

101

Likes

0

Replies

0
Drop down with filtered ODBC data source
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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 data in to an array, then filter based on the year;orHave the form allow you to select the year, then make the call to get the data for that 1 yearLooking for a good example so I can learn the process.Th...

Views

649

Likes

0

Replies

1
Re: Windows 7 64 bit and ODBC connections
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
Oh, interesting that the 64 bit ODBC works fine with Microsoft Access to link into the SQL database.I can see and update the tables fine.So, my first thought would be that LiveCycles has a problem on Windows 7 64 bit or some settings that I am not aware of that need to be set.

Views

123

Likes

0

Replies

0
Re: Windows 7 64 bit and ODBC connections
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
Anyone that you can ask at Adobe that may know about any such issues?

Views

124

Likes

0

Replies

0
Re: Windows 7 64 bit and ODBC connections
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
Hi PaulI am trying to get the 32 bit drives to work connected to a SQL remote database and I get the following errorGeneralError:Operation failed.......Index is out of boundsI am using a simple script to clone the datasource so a drop down can bring up the other row valuesThe lines that it is failing on iswhile(xfa.sourceSet.nodes.item(nIndex).name != "DataConnection2"){ nIndex++; }worked fine in Vista, but not windows 7 (using 32 bit drivers)Any suggestions?

Views

124

Likes

0

Replies

0
Windows 7 64 bit and ODBC connections
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
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:Does lifecycle work with windows 7 64 bit version?Do the 64 bit ODBC drivers work?Do the 32 bit drivers work?If issues, any threads out there?

Views

1.9K

Likes

0

Replies

6
Drop Downs not reading data
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
This is probably a very dumb question, but ...I have 2 forms, one is working great, reading from the database and showing the drop downs properlyThe other is set up the same way, started from a new form, but is not allowing any drop down interaction.Just shows the first record. and is greyed out.Question: What would cause this and where do I look to try and fix this?

Views

450

Likes

0

Replies

1
Re: Database connection and what is the best method
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
No errors reported.

Views

140

Likes

0

Replies

0
Re: Database connection and what is the best method
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
wrtAre the values that populate the DDlists in different tables or the same one? - Yes different onesIf they are in different tables then I think you will need a different data connection per table. I agree.If they are the same then you shodul be able to define the SQL statement that you want to run in the current code.I suggest that you use the exit event of the DDList and not the change event. - Will tryAt the moment, using a button to initiate the data source for the #2 dDown with the followi...

Views

141

Likes

0

Replies

0
Re: Database connection and what is the best method
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
Hi PaulFirst - thanks for the tips so far!Working on a project that requires 2 drop downs to filter the next third drop down.Need user to select ClientID and YearIDI have the code working for the first dropdown (ClientID), but unable to get the second drop down to show JUST the data related to the selected clientID.I am using these Data connections:Clients - providing the ClientID'sClientsDetail - Same as above but is the selected record from the first Drop down (ClientID)Years - providing the C...

Views

141

Likes

0

Replies

0
Re: Joining 2 fields
Avatar
Ignite 10
Level 2
KRM240_
Level 2

Likes

0 likes

Total Posts

34 posts

Correct reply

0 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
KRM240_
- Adobe LiveCycle
Hi, Using the arrays looks great for what I need to do too.But the data is hard coded and thus not as flexibleeg: you use var caCodeStr = "Canada,AB,BC,MB,NB,NL,NS,NT,NU,ON,PE,QC,SK,YT";If this data was in a relational database that I want to connect to One table with CountryID and CountryName and other dataAnother table with CountryID, StateID, StateName and other dataQuestion:How would I load the required data from these tables to populate the arrays?

Views

88

Likes

0

Replies

0