You are here:
I have experience in working with Access queries, forms and reports.
have been programming in access for the past 2 years.
| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| Harry92 | 05/03/08 | 10 | 10 | 10 | Thank you |
| Roark | 05/26/06 | 10 | 10 | 10 | |
| Philip Smith | 10/01/04 | 10 | 10 | 10 | |
| Philip Smith | 09/29/04 | 10 | 10 | 10 | |
| Philip Smith | 09/27/04 | 10 | 10 | 10 |
Hi, you got to create a join between these two tables on ClientID and then perform the delete query. For eg DELETE FROM tbltrcclient WHERE ClientID IN ( SELECT T.ClientID FROM tbltrcclient T
Hi Enrico, there has to be some common column or matching criteria. What's the structure of the two tables?
Hi Laura, I don't think you need to create any macro. Seems there is some conflict/error in the control name. Just delete that checkbox control and add a new one (this time give it a name without any
Hi Laura, yes that is possible. Drag and drop a checkbox onto the form. Next add the following code to the checkbox's AfterUpdate event - Private Sub Check4_AfterUpdate() If Me!Check4.Value = True
Hi Ron, you will pass that data to your query. You will have to check the exact syntax for that. For ex - SELECT * FROM TableName WHERE LocationID = intLocationID AND UserID = intUserID where
Answers by Expert:

©2012 About.com, a part of The New York Times Company. All rights reserved.