hi can anyone help me i have a billing system, how can i save the data to another table? using sql? may 1 table name is transac and all i want is if what the record have been save to my transac then it will save to another table name it transac2. .
please help thanks a lot.
what is the database that you are using ?
access please i want to know the code. .
you only want to take back up of the table or want the transaction to be affected in both the tables.
if u want only back up then simply copy the table or the entire database file.
no all i want is this, if what is the record in my table 1 if i click my command button visual basic then the record of my table1 must save to table 2
simple crate the table2 and run the following
insert into table1 select * from table1
access please i want to know the code. .
If you want to know the code , you have to first attempt to writing it .
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.