Copy & Paste in VB

[technician]

hiya guys/gals

how can i copy certain information from one form/table to another iwith VB

i have a record in table "courses" called [course code] and i want to transfer it to table "delegate" record

i am new to the VB side of access but am slowly getting there

thanks for your help

Paul

 

[MStef]

Hello Paul!

You don't need the same data in two tables.

 

[Rich]

If you were to use a form/subform with linked Master/Child fields you wouldn't need vba to do this

 

[technician]

You don't need the same data in two tables.

Hi there

The database i am running has one linked table, and one permanant table

the linked table can change data whereas the permanant table is my record,
hence why i need to know how to copy the data from one table to the other.


Paul

 

[MStef]

Ok Paul!

Look at "DemoCopyRecordA2000.mdb",
look at Tables,query,form. Open form and try.

 

[technician]

Look at "DemoCopyRecordA2000.mdb",
look at Tables,query,form. Open form and try.

Hiya
Thanks for the info

Not sure if i am not getting this, but the db you sent appends all data from one table to another, what if i want just one part of the data to be appended to a specific record in another table ?

Paul

 

[technician]

Hiya
Thanks for the info

Not sure if i am not getting this, but the db you sent appends all data from one table to another, what if i want just one part of the data to be appended to a specific record in another table ?

Paul

Can anyone help me with this ? PLEASE

 

[gemma-the-husky]

we're not sure what you want

if you have a courses table, and a delegate table then what you need is another table called eg attendance

in this table you store the delgateid, and the courseid.

that information will enable you to extract all the information you need about who is attending which course. you don't want or need to copy course inforamtion into the delgate table.

 

[MStef]

Hello Paul!

You say my Demo copy "ALL DATA FROM ONE TABLE TO ANOTHER".
Not, only records when you CLICK on button.
As Gemma-the-husky say, I don't know exactly what you want.