Search results

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

i really like to ask you could you recommend me a VBA book or anything where i could learn the VBA and get even more grip on that subject.

The Code is on the ONDelete Event of the Form. The System Prompts i have disabled them Docmd.Setwarnings False in the BEforeDeleteConfirm Event of the Form. because I created my own prompt in the code. It Should work right?

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

THanks A lotlottttttttttttttttttttttttttttttttttttt. VBAINET. you are truely , genuinely a friend. I mean it . Thanks a lot

Case 2 If the User By mistake tries to delete a participant on the form and selects yes on the delete message prompt. But the deletion would be unsuccessful because the participant has got records in the linked tables as well. The participant won't get deleted because the user is trying to...