Well, this is a weird one.
I created a database for another group to track employee probation reports.
Whenever an employee is promoted, they get a new probation in the new position and relevant data is tracked.
If an existing employee's data changes, the clerk would just select filter by form, enter in the relevant emp #, hit the apply filter button, et voila! The employee's data would fill the form for modification.
But, I was recently told that it had stopped working. When the clerk hit apply filter, the form would remain blank. But, the employee data was clearly in the table.
I figured that the clerk had inadvertently stuck some data in one of the other fields on the form - something that has happened before - and told him to make sure all the non-searching fields were clear before applying the filter.
No good. Still, the employee's data doesn't come up.
So, I'm going over the data in the table and the form itself and I can't get the filter by form to bring up this guy. Thinking perhaps the data was corrupted in some manner, I deleted the employee record and re-typed everything directly in the table and tried the search again.
No good. He won't show.
I tried another employee - he didn't show up. But, I then noticed that the dropdowns that show up when you are applying criteria to the filter by form, the ones where you can scroll through the field's data and select an entry, those dropdowns DID show the data for these two employees. For example, their employee numbers were in the dropdowns.
I tried another employee and he DID show up. His data was retrieved. So, apparently, the filter by form function works, but not for those particular two employees.
Then, I tried entering a dummy employee and filtered by form for his data.
No good, his data would come up. I tried filtering for random employees in the table. Most filtered fine, but some did not.
The only answer I can think of is that something has happened to where employee data entered after some point in the past will not come up in the filter by form. I can't determine a specific cut-off date, since the date when an employee is first entered into the table wasn't necessary, so it's not recorded.
Anyone have any idea what could cause this?
If my explanation isn't clear enough, please ask me for details and I'll give what ever I can.
Thanx in advance!
I created a database for another group to track employee probation reports.
Whenever an employee is promoted, they get a new probation in the new position and relevant data is tracked.
If an existing employee's data changes, the clerk would just select filter by form, enter in the relevant emp #, hit the apply filter button, et voila! The employee's data would fill the form for modification.
But, I was recently told that it had stopped working. When the clerk hit apply filter, the form would remain blank. But, the employee data was clearly in the table.
I figured that the clerk had inadvertently stuck some data in one of the other fields on the form - something that has happened before - and told him to make sure all the non-searching fields were clear before applying the filter.
No good. Still, the employee's data doesn't come up.
So, I'm going over the data in the table and the form itself and I can't get the filter by form to bring up this guy. Thinking perhaps the data was corrupted in some manner, I deleted the employee record and re-typed everything directly in the table and tried the search again.
No good. He won't show.
I tried another employee - he didn't show up. But, I then noticed that the dropdowns that show up when you are applying criteria to the filter by form, the ones where you can scroll through the field's data and select an entry, those dropdowns DID show the data for these two employees. For example, their employee numbers were in the dropdowns.
I tried another employee and he DID show up. His data was retrieved. So, apparently, the filter by form function works, but not for those particular two employees.
Then, I tried entering a dummy employee and filtered by form for his data.
No good, his data would come up. I tried filtering for random employees in the table. Most filtered fine, but some did not.
The only answer I can think of is that something has happened to where employee data entered after some point in the past will not come up in the filter by form. I can't determine a specific cut-off date, since the date when an employee is first entered into the table wasn't necessary, so it's not recorded.
Anyone have any idea what could cause this?
If my explanation isn't clear enough, please ask me for details and I'll give what ever I can.
Thanx in advance!
