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

Button for next recording in the database


Level 1


I currently testing Adobe LiveCycle to create a PDF form with data link to a database (Access).

The goal of my form is for the manager of each of our site to write variable about the paycheck of each employe. So first I create my AccessDatabase with a simple structure :

N : Auto Number

Matricule : Employe ID

Nom : Name

Prenom : First Name

Service : Service (Accounting...)

HeureMensuelBase : Contract hour information for the mouth

HeureSemBase : Contract hour information for the week

Mois : Mouth

Annee : Year

NbrHeureMensuelW : Write the number of hour the employe work this mouth

NbrHeureSupp25pc : Extra hour paid 25% more

NbrHeureSupp50pc : Extra hour paid 50% more

NbrHeureSupp100pc : Extra hour paid 100% more

NomPrime : Name of a special gratification

MontantPrime : Amount of a special gratification

So after, I create my ODBC connexion and insite AdobeLiveCycle, Data View, Create a connexion > Next > ODBC String connexion > SQL Request > SELECT * FROM Table_Access; > Next > Finish. Great I retreive all my fields. If I preview the PDF I can correctly see the first record of my database.

My goal is to create two differents buttons to navigate inside :

NEXT with the follow code :

formulaire1.#subform[0].Next::click - (JavaScript, client);

PREV with the follow code :

formulaire1.#subform[0].Prev::click - (JavaScript, client)


If i try to preview it, unfortunatly no button works.

I follow this video :

I  see the Adobe FAQ too :

Could help me ? Adobe Support don't want help me because I use a trial version for the moment (logical because my CTO wan't valide LiveCycle do the job before paid for it). Sorry for my english it's not my mother tongue.

1 Reply