code filing

[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

 

[Douglas J. Steele]

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.

 

[Jason]

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.

 

[Jason]

Also access keeps crashing on the VBA line also when trying to debug!

 

[Jason]

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.

 

[Jason]

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.