C
cleech
Hello All:
I've been working on an ongoing problem with Access 2000. I've
searched high and low for a solution and could not find one. I even
resorted to opening a ticket with MS. This resulted in the ticket
being closed and my company not being charged. Essentially I was told
it is a bug and I should buy a newer version of Access where the
problem is fixed.
Anyway, the problem is as follows:
When a user uses filter by selection to sort records based on data in a
column, once the user changes the data in the filtered column, the
filter is lost and returns to it's original recordsource.
Has anyone encountered this problem or better yet came up with a clever
solution? This is driving my users nuts. The closest I've come to a
solution is using the afterupdate event to change the recordsource.
This holds the filter, but drops the changed record b/c it no longer
meets the criteria of the recordsource.
My users like to use forms in datasheet view, so creating a cumbersome
form would not help. Also, I need to use an adp to take advantage of
stored procedures. If I link through an mdb, I would need to create
several queries to handle this.
Any help or suggestions is greatly appreciated.
Thanks,
Cleech
I've been working on an ongoing problem with Access 2000. I've
searched high and low for a solution and could not find one. I even
resorted to opening a ticket with MS. This resulted in the ticket
being closed and my company not being charged. Essentially I was told
it is a bug and I should buy a newer version of Access where the
problem is fixed.
Anyway, the problem is as follows:
When a user uses filter by selection to sort records based on data in a
column, once the user changes the data in the filtered column, the
filter is lost and returns to it's original recordsource.
Has anyone encountered this problem or better yet came up with a clever
solution? This is driving my users nuts. The closest I've come to a
solution is using the afterupdate event to change the recordsource.
This holds the filter, but drops the changed record b/c it no longer
meets the criteria of the recordsource.
My users like to use forms in datasheet view, so creating a cumbersome
form would not help. Also, I need to use an adp to take advantage of
stored procedures. If I link through an mdb, I would need to create
several queries to handle this.
Any help or suggestions is greatly appreciated.
Thanks,
Cleech