This topic is locked

BeforeEdit - key field not printing

4/5/2006 7:58:09 AM
ASPRunnerPro General questions
B
bluecells author

Hello,
This code works perfect and lists all my fields except one, actually the key column.
keys = dict.keys

For n = 0 To dict.Count-1

message = message & keys(n) & " : " & dict(keys(n)) & vbcrlf

Next
Why is that?
The key fied ("ID") displays correctly on the edit page.

All boxes for list, edit, add are checked.
Thanks for your help.

  • Jerome

Sergey Kornilov admin 4/5/2006

Jerome,
it seems that you set Readonly for your key field in the Edit as dropdown box on the Formatting tab. In that case this field doesn't print.

To show all fields try following code:

IDfield = rs("ID")

message = IDfield & vbcrlf

keys = dict.keys

For n = 0 To dict.Count-1

message = message & keys(n) & " : " & dict(keys(n)) & vbcrlf

Next

B
bluecells author 4/5/2006

Thank you Sergey.

Unfortunately, this does not work either.
Would that come from my table settings in Access?

  • Jerome

Sergey Kornilov admin 4/5/2006

What do you mean by "don't work"? Give me more detailed description.

Show me the recieved email text.

B
bluecells author 4/5/2006

I am trying to print the ID field. It does not print.
Here is the email. (The ID should be on top)
Ressource : BLUE CELLS

Company_name : Blue Cells

Address : 11 rue Soeur Audenet

Postal_code : 81100

City : Castres

Country : France

Email : architext@compaqnet.fr

Phone : +33 1 53 01 27 44

Mobile : +39 388 617 5009

Skype_ID : +33 870 444 363

Fax : +33 1 53 01 27 44

Web_site : www.bluecells.net

VAT_number : FR 33 440 200 848

Internet connection : Broadband

College_University : Lycée Barral - Bac D

Sup de Co Tours

Sony ITE

Mother_tongue : French

Year_of_experience : 2002

Trados : 0

Software_localization : 0

DTP : 1

Average_capacity :

Field_of_expertise : IT

Sworn : 0

Sworn_language : None

Sworn_court : None

Bank_name : Banque Populaire

IBAN : FR76 1050 70000 0820 8193 6099 557

BIC : None

PayPal : None

Login : 5BLU

Password : 5BLU

  • Jerome

B
bluecells author 4/5/2006

Solved. I had altered your code.
Thanks Sergey.