In Access 2003, I have a form with a combo box that is bound to a Projects table. I'd like the users to choose from a limited list of items to populate the Employee ID column that the combo box is bound to. Employee Name comes from another table and is linked to the Projects table via key...
My situation:
I wrote a bunch of complicated queries in Access 2000 that read linked SQL Server 2000 tables. For the most part, these tables have hundreds or a few thousand records and performance is good. Some of the queries use vba functions. The queries with the vba functions run so slowly...
I would like to create a counter column in a table/query that resets to 1 upon a change in a particular field.
For example:
PersonID Counter
100 1
100 2
100 3
200 1
200 2
300 1
400 1
Thanks in advance for help!
I've had several mdb files corrupted. I'm using Access97 SR-2 on Win NT. It is a multi-user environment. Anyone have any tips on avoiding this problem?
Thanks in advance
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.