These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Choosing a record from a DB to populate a form

Forum Index > Forms: LiveCycle Designer > Choosing a record from a DB to populate a form
2007-07-20 08:55:06
mrichman
Registered: Jul 20 2007
Posts: 6

This will be my first LiveCycle application. I have an Access 2007 database that contains contact data (first name, last name, etc.). This data will be editable in a PDF of a scanned paper form with databound fields that I've overlaid (that part is already done). I'd like to implement a "Find Contact" dialog that allows for search and selection of a single record from the database, which then gets its details populated into the PDF form. Any suggestions on how to do this?

Thanks,
Mark

Top
2007-07-20 09:14:16
#1
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4307
Have you looked at the AUC articles, tutorials, advice?

Adobe' s Developer Center for LiveCycle Designer for samples, tutorials or articles?

http://www.adobe.com/devnet/

http://www.adobe.com/devnet/livecycle/


Adobe's Acrobat Forums?


http://www.adobeforums.com/cgi-bin/webx/.3bc14efe/13


Stefan Cameron's blog?

http://forms.stefcameron.com/

George Kaiser

Top
2007-07-20 09:18:48
#2
mrichman
Registered: Jul 20 2007
Posts: 6
Thanks -- I wasn't aware those existed!
Top
2007-07-20 13:05:12
#3
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4307
You might want to search for messages and documents. This topic is covered in chapters, yes more than one chapter, in books. You have to pass quoted strings within strings, not the easiest code to write. Adobe has a lookup example that is seven pages long and that is just looking up an item. Adding, deleting, or modifying an item requires additional checks prior to processing.

George Kaiser

Top
2007-07-20 13:07:33
#4
mrichman
Registered: Jul 20 2007
Posts: 6
Can you point me to that seven page sample please?
Top
2007-07-26 08:32:21
#5
crowbar
Registered: Jul 19 2007
Posts: 9
mrichman wrote:
Can you point me to that seven page sample please?
Hi, I am trying to research a similar project, just a simple lookup for me,

I think I found the 7 page document previously mentioned, here is the link -

http://www.adobe.com/devnet/livecycle/articles/lc_designer_db_lookup_tip.pdf

staff here seems to be overworked and underpaid, answers don't seem to come easy.

HTH
Top
2007-07-26 09:16:32
#6
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4307
If the majority of the responders salarys were doubled by Adobe, almost all would stilll be paid the same.

At least mine would be!

George Kaiser

Top