M
MPM1100
Hi all,
I posted this earlier in Programming without response. So I thought I'd try
here.
I'm reverting back to Access 97 and running into a problem with the app and
the use of CurrentDB.OpenRecordset.
I am submitting a SQL statement for the domain which is where the problem
exists. In the SQL statment I am using the function Nz() which works fine
when viewing a queries in the query window. However, when I try to submit
the same SQL to OpenRecordset, I get an error telling me that the function
'Nz' is undefined.
It's been a while since I worked with A97, but I don't recall ever having
such problems. Is there a reference or otherwise I might be missing here?
Thanks in advance...
MPM
I posted this earlier in Programming without response. So I thought I'd try
here.
I'm reverting back to Access 97 and running into a problem with the app and
the use of CurrentDB.OpenRecordset.
I am submitting a SQL statement for the domain which is where the problem
exists. In the SQL statment I am using the function Nz() which works fine
when viewing a queries in the query window. However, when I try to submit
the same SQL to OpenRecordset, I get an error telling me that the function
'Nz' is undefined.
It's been a while since I worked with A97, but I don't recall ever having
such problems. Is there a reference or otherwise I might be missing here?
Thanks in advance...
MPM