Adding New Column

[danny123]

Hi there,

I am trying to add a new column to my table say name2 with data type Text.
as soon as i hit save it gives me error
"Unknown function Date in validation expression or default value on Contcts.LastUpdated. (Error 3388)"

Any clue?

One more thing what is the maximum number of columns permitted in a table?

Thanks

 

[Dennisk]

I am assuming you have something like <= Date() in your validation criteria.

the Date() function is contained in the VBA for Applications DLL and is probally missing.

Open a code module and click tools | references

VBA for Applications should be your first reference. If it is not in your list scroll down the list until you find it then check it. You should now see it your list of references.

to answer your second question - click help and enter specification and you will find the max number of columns is 255.