Search results

Case 2 when a user tries to delete a participant but if the participant has related records in the linked tables. Even then the user selects yes on delete message prompt then that record should not be saved in the table I am EXTREMELY SORRY , i am not talking about the same participant in...

And Count of the each Participant would be only 1 in this table . Because the ID will be unique and Count is based on ID .

Yes you are right , this way i can be able to satify the CASE 1 But in the CASE 2, the deletion would be definitely unsuccessfull because it would have related records in the linked tables. But the problem is that the record is getting stored in the table . I do not want the record to get...

Dcount is 1 actually So its cancelling the operation .

I am in desperate need of Help.

VBAInet, Help me Help Help Help.

This is ONDELETE Event of the form .

Private Sub Form_Delete(Cancel As Integer) Dim db As dao.Database Dim Response As Integer Set db = CurrentDb() 'Set tbl_delete = db.OpenRecordset("tbl_delete") Response = MsgBox("Do you want to delete this record ? ", vbYesNo) If Response = No Then Cancel = True Else If...

Oh Alright , I will do that. But i was trying to ask you that whether the core concept is right ?

Dim sql As String sql = Nz(DLookup("part_cin", "tbl_Participant", "part_cin ='" + Me.frm_part_cin + "'")) Dim db As dao.Database Dim tbl_delete As dao.Recordset Dim Response As Integer Dim sum As String Set db = CurrentDb() Set tbl_delete = db.OpenRecordset("tbl_delete") Response = MsgBox("Do...

Help me VBAInet, Because u suggested that idea. And i going blank now.Please Help me.

Hey SOS and VBAInet . I figured it out thanks anyways for replying and helping me out. actually what iam doing is that i am using Dlookup Function ( Suggested by VBAInet) and checking whether it is still in the table or not . If it is then i am not saving that record . If its not , then iam...

Hi SOS, i can't do that , that way i will not delete any record i would just mark that but those records would be there in the table and i have to identify them by looking at archived field. No thats not what i want . I want the record to get deleted and the deleted record should be saved in...

Hi SOS could you please explain in detail about that. Please

I do not want to do the cascade delete . Because if the user by mistake selects yes on the record then the whole data will be lost.

Hi VBAInet, I did modified my code it is doing the same thing . If a User by mistake tries to delete a record on the parent table before deleting that record on the child table . It should not be saved in the table . and The problem is , that it is getting saved in a table because we are...

Yes i have done that . I am using the record set because it is a new table and i am using that table to store only the deleted records it is not linked to any other table . Its just a stand alone table saving the deleted record information. and I am posting the modified code here take a look at...

Hi , this is code is present onDelete event of the form .So when the user tries to delete a record he will be prompted with yes and no options . SO when he selects yes the record gets deleted and i am saving that deleted record in a table . But when the user tries to delete a record on the...

Hi , I have the code which stores the deleted records in a separate table . When the user tries to delete a record , upon select yes on the message box the record gets deleted and it is stored in a separate table . But there is a glitch , I will explain it by taking 2 tables ( tbl_customer...

H, I have two tables tbl_ new and tbl_copy both have same structure and field names but the data will vary among the tables So Tbl_ new (id, first name, last name ) has 3 records and tbl_copy ( id , first nbame, last name) has 2 records .So when you compare the data in both tables...