how to save record to another table in the same ms access database

access Malaysia
  • 10 years ago

    im try to save certain fields from a table to another table. its l ike this:

    i have a form (created from table1) , once click on save button, textbox1,textbox2 value will be save in another table called table2 in the field 2 & 3 (table2 contains 3 fields but i only want to enter the 2nd & 3rd field)

    so how do i do this... any help .... with sample code appreciated

  • 10 years ago

    Maybe using of Insert Into table2 (Select 0 As id, col1, col2 From table1 where ???) would help

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“A computer is a stupid machine with the ability to do incredibly smart things, while computer programmers are smart people with the ability to do incredibly stupid things. They are, in short, a perfect match” - Bill Bryson