Setting date to null 1

[crysma]

Hi,

I'm working on an application with VB interface and an Access backend. I need a way to let userschange and/or delete certain dates of they so desire. While it will change the dates just fine, if I try to delete a date by setting its value to null, it throws an error. Is there another way to do this? If you could help me out, or point me to somewhere that might have the answer, I'd appreciate it muchly

Thanks in advance

Sheryll

 

[SonOfEmidec1100]

UPDATE MyTable Set Mydate = NULL should work, check the
Required property for this field it must be set to No. If this does not fix it maybe check the validation rules as well.

Hope this helps you.

 

[crysma]

Thanks for your help. I will try this out and let you know how it goes

 

[crysma]

Thank you, it worked