|
|
Thanks for the replies.
I didn't think about Password being a reserved word. I will change that. That
is not causing my errors because the form works when I take out the two date
fields and the three Yes/No fields.
The field for DateAdded and DateUpdated are date fields in the Access table.
The DateAdded field is queried when the form is called and kept in the form as
a hidden field. Seems like I have done exactly the same thing before with dates
and didn't have any problem with them. I am trying to fill the DateUpdated
field at the time the Update query runs, but all attempts at figuring that out
have been unsuccessful. I tried Now(), but that didn't work. That is when I
tried CreateODBCDateTime(now()).
How do I pass the date as a date? I thought that is what the
CreateODBCDateTime thing was for?
Active and the other two fields are Access Yes/No fields set to Yes/No,
however, if you query the table and output the result of the field, it actually
shows 1 or 0, so I was sending that back to it when I set the values. I tried
sending Yes and No to it, but that didn't work either.
I always struggle with Access.
Thanks,
Kirk
|
|