Recent content by mothi

Let me explain clearly, 4 tables connected in query. If you look at the data below ID( 2) is a duplicate one because it has got same records . And ID (3) has got two records but with different Dates So i want the report to only show the data assosciated with ID(3). Please Help me thank you...

Let me explain clearly, 4 tables connected in query. If you look at the data below ID( 2) is a duplicate one because it has got same records . And ID (3) has got two records but with different Dates So i want the report to only show the data assosciated with ID(3). Please Help me thank you...

Trying to achieve, capturing the deleted record information and storing it in a array in the ONDelete event and using that same array in the AfterDeleteConfirm event , writing the values to the table. iam calling the function in the AFTERDELEVEnt := modprocess([Form]) In my form's module at...

Hi , Problem Is When the user tries to multiple records at a time on the form . I do not want to let him do that. I should allow the user to delete one record at a time. So whenever the count of records ,that the user is trying to delete is more than 1 , cancel the operation . Whenever , the...

HI , the code in AFterDELCONFIRM of the form and the same goes to each and every form i have . SO instead of pasting code in the AFTERDELCONFIRM event of every form . Can i create a module which has the code and i can just call the module from every form. I do not know how to do that. Please...

Hi Code ONDELETE Private Sub Form_Delete(Cancel As Integer) Dim db As DAO.Database Dim cin As String Dim table As String cin = Nz(Me.frm_part_cin) table = Me.RecordSource end sub I am storing them in the temporary variable and i need to use these variables in the AFTERDELCONFIRM event and...

Hi, Please this is not a duplicate question. I need to save a delete record. the Purpose is same but the way i should do is different now. So thats why i need your help guys. Whenever a user deletes a record on the form I need to store that record in a separate table. I was told that i should...

Yes. I guess thats the only. But from the bottom of my heart, i really appreciate all the efforts you have put in. Thanks a lot and Take Care.

Thats because i asm asking query to return only the common records between the tables so table 1 and table 2 has 240 common records ( lets that includes ZZ12345Z record) but the table 1 and table 3 ( has 100 common records but it does not include zz12345z because table 3 does not have that...

I Did that Just now But You know what i explain it thru example Lets say table 1 ( Parent table ) has got records in table 2 ( Child) and onre more link to table 3 ( child ) So it is not returning the total number of rows because if the table 1 and table 2 has got common rows ( lets say...

Parent Table is connected to around 6 to 8 tables . But I Guess when you create a query having all the common records. I see what ur saying . But you know i have to repeat the same logic for children table as well . So, I have to create queries for each table .

Dim db As dao.Database Dim Response As Integer Set db = CurrentDb() Response = MsgBox("Do you want to delete this record ? ", vbYesNo) If Response = No Then Cancel = True Else If DCount("part_nod_cin", "tbl_Participant_NOD", "part_nod_cin= '" + Me.frm_part_cin + "'") > 0 Then Cancel = True...

One more thing is that In the COde I pasted below i am as of now, only checking for one table what if my parent table has got more linked tables. Instead of creating Dcount function for each linked table . Can i just have single line of code which checks whether that particular participant is...

Dim db As dao.Database Dim Response As Integer Set db = CurrentDb() Response = MsgBox("Do you want to delete this record ? ", vbYesNo) If Response = No Then Cancel = True Else If DCount("part_nod_cin", "tbl_Participant_NOD", "part_nod_cin= '" + Me.frm_part_cin + "'") > 0 Then Cancel = True...

One more thing is that In the COde I pasted below i am as of now, only checking for one table what if my parent table has got more linked tables. Instead of creating Dcount function for each linked table . Can i just have single line of code which checks whether that particular participant is...