Table field named "no"

[Paolo]

I have a programme with several tables whose fields have the ISO639 language abbreviations as fieldnames. Now I need to add Norwegian as a language - official abbreviation = "no".

There seem to be problems with having "no" as a fieldname!
In particular, I can't get DLookup("no", ... ) to work.

Is this an Access bug?

thanks, Paolo

 

[Tim Ferguson]

There seem to be problems with having "no" as a fieldname!
In particular, I can't get DLookup("no", ... ) to work.

Try DLookup("[No]", ...

but in general it's better just to steer away from all reserved words as
field names: this includes things like Name and Date and Day and so on. In
any case, there should be no need to change database object names (fields,
tables, and so on) since the user should not be coming into contact with
them -- even if you do have to go round and change the labels on the forms
and reports.

B Wishes


Tim F

 

[Paolo]

Try DLookup("[No]", ...

Thank you very much! This solves the problem.
Paolo