code filing

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Using Access 97 I coppied my db from this coputer to another - worked fine.
Now that I have coppied it back again the following code is failing:

nz(LastDate,dateserial(2005,12,31)) >= nz(DateFld,date())"), 0)

Run-time error '62436':
Function isn't available in expressions in query
 
You appear to have some extraneous suff at the end of that code.

It should be

nz(LastDate,dateserial(2005,12,31)) >= nz(DateFld,date())

Of course, it's hard to say, since we don't know the context in which that
snippet of code is supposed to be executing.
 
I tried to create a query. The query generated the error even without
putting everything in the query:

SELECT RegularTransactions.DateFld FROM RegularTransactions WHERE
(((RegularTransactions.DateFld)<=Date()))

Function Isn't available. If I can't get this part to work adding the rest
won't make any difference.
 
Must just be date() failing as I have a totally diferent table where the
default value = date(). In the table view (I opened the form first which did
the same thing) and the default value is #error.
 
I've tried recreating the database - the tables didn't display #error? but
now I get
Run-time error '3085':
Undefined Function 'DLookup' in expression.
 
Back
Top