Search results

Well, I had a LOT of errors and bugs to work thru, but I FINALLY got it to actually write the copy of the record upon deletion. The problem now is it wrote it to the same table that it deleted from, the one named main. The code is below, and I don't know what is wrong with it. Private Sub...

Private Sub Form_Delete(Cancel As Integer) history.AddNew history!Name = main!Name history!Age = main!Age history!Sex = main!Sex history.Update End Sub Is that the right way? Is it being inside the form_delete function correct? Also, can I use an autonumber on the history...

To simplify this for me, could you give me an example for how to do this with the following info? Database Name=tester Table 1=main Table 2=history The fields are identical for each table, for this example they are=name,sex,age Also, to put this function into the ondelete event, does it...

Where can I find this sample code? I searched the sample database forum for .addnew and got no hits. I saw an example of it for a DAO database, which I am not sure I have, mine is access MDB. But it was pretty confusing for me, having no VB experience at all. Looking at your small example...

How do I tell it what values or records to actually add? Will it automatically know that I only mean the single record I am viewing of the other table?

My 2nd post, and I am very new to DB and Access. I have a problem that I want to get help on. I want to set up a main form that is used to enter and delete all data for my table. I wish to add either a button or to make it automatically happen when a record is deleted, that it is first copied to...

I am very new to Access, and I am not sure how best to ask this question, so I am going to give an example of what I want to do. Table(Example): Fields -- Possible Values Date -- Date/Time Number -- PK Sex -- Male/Female Only (One of my fields I want on report) Race -- W/B/H/A (White, Black...