Adding record to Another Table

[MHamid]

Hello,

I was wondering if it is possible to create a macro to paste record from a form (Student ID, using Student ID Table), into a different table (main_data) and delete record?

If so, how is this possible?


Thank you

 

[Micron]

Use an append query to copy the data from tbl1 to tbl2, then another query to delete from tbl1, assuming that's what you mean. If you need a macro because this is not a one-time thing, then create the macro to execute those steps. You might want to practice on copies of those tables first.

 

[MHamid]

Hello,

Can you give a example on how to do both options?


Thank you

 

[Micron]

You want me to tell you how to create an append query and a delete query? Or are you asking about code? You asked for a macro, but I don't do macros so I'm very unfamiliar with them. There's lots of instructions on the web on how to do either of these things and you'd be better off if you found one or more that apply to your situation. Here's what a query sql might look like if I wanted to copy from tblAscii into tblAscii2 where the key values in the 1st table are less than 40

INSERT INTO tblAscii2 ( [CodeValue], [Character], [Desc] )
SELECT tblAscii.CodeValue, tblAscii.Character, tblAscii.Desc
FROM tblAscii WHERE (((tblAscii.CodeValue)<40));

 

[nancywilson]

The MS Access is the well-known database. We can add data from one table to another table by using these query below.
INSERT INTO TABLE2 SELECT * FROM TABLE1
INSERT INTO TABLE2 SELECT * FROM TABLE1 WHERE COL1 = 'X'
These queries will help you so much. I am getting the issue in MS Access because it is not working properly means virus issue. What should I do to resolve this issue? I install Avast antivirus and also try on avast customer service for the help purpose but did not get any response.