Search results for query: *

This seems like a very elegant solution to the problem. I have tried to use this on similar data but get an error message when I try to run the query.. (ambiguous name) I'm sure I've overlooked something, but would appreciate any advice. Thanks

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...

Pass Thru query? I will investigate... Thanks

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 tried the 1st method and it works. Thanks a million!

Thanks, but is there a way to create a table or query with all these values without using forms or reports? Thanks again!! :)

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!

Thank you so much!!! :-)

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