Table field named "no"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top