I'm running into a problem that is going to start causing me a lot of consternation... I have a couple of tables, each set up with a field called 'date entered'. The default value is Date(). For the most part this works pretty well, however inexplicably some times this field is blank. (Users enter information into a form instead of the table itself)
Why does this work at some parts of the day and not at others?
All I can think of is that several users have access to the database and the forms used to enter the information into the system, could multiple users cause this?
It doesn't seem like this would be it though, as the blanks are usually in groups, not interspersed throughout. And it doesn't seem to be connected to any particular date, as I've seen blank date fields sandwiched bewteen 6-13 and 6-14 (I also have an auto-number to keep track of the order they are entered).
Has anyone had gremlins like this before?
Thank you for any guidance you can provide!
Why does this work at some parts of the day and not at others?
All I can think of is that several users have access to the database and the forms used to enter the information into the system, could multiple users cause this?
It doesn't seem like this would be it though, as the blanks are usually in groups, not interspersed throughout. And it doesn't seem to be connected to any particular date, as I've seen blank date fields sandwiched bewteen 6-13 and 6-14 (I also have an auto-number to keep track of the order they are entered).
Has anyone had gremlins like this before?
Thank you for any guidance you can provide!
