Error message 1

[demon147]

When I try to open a table I get this message.

"The function you entered can't be used in this expression.

*You may have used a DoEvents, LBound, UBound, Spc, or Tab function in an expression.

*You may have used an SQL aggregate function, such as count, in a design grid or in a calculated control or field."


I don't recall doing any of the above but I have made a mistake. Could anyone tell me how to fix this problem.

Help Appreciated.

Thanks,
George

 

[JamesMeadlock]

Need more details...

 

[demon147]

The only other details that I can give is that this only happens when I try to open tables in design view or otherwise and this also prevents me from saving any changes that I make to a table in design view. The message does not appear when I open forms or reports.

The other thing that I noticed was that I have a date field in every table except one in those tables the statement #Name appears in that field in every table, but the table that does not have a date field does not give me this message when I open it.

Hope this helps
Thanks.

 

[Maquis]

That date field is definitely what's causing your problems. What is the field name? Is it "Date"? If so, change it to something else. Date is the name of a function in Access that returns today's date. Maq B-)
<insert witty signature here>