Comments by kabifarm (Top 6 by date)

thank u Ron Beyer. I have tried the codes but it can only show sent from gmail mbut does not get to destination any suggestions

you can also do it thiis way

On the same databse use:
SELECT * into stock_record1
FROM stock_record

in another database
SELECT * into [pos].[dbo].[bank]

from [school].[dbo].[bank]

Thanks very much CHill6024K for ur quick response. am very grateful for painstakingly going through the code and refactoring them for me. these will help me to refactor most of my othe codes.

but there is this statement of urs that i wish to understand more: "you have left yourself vulnerable to sql injection by inserting text directly into your queries.". what does that mean so that i can know how to avoid same subsequently

Also, i ve tried the first set of codes in my form and the worked perfectly. but for the second set with parameters am still twieaking

why not create delete statement that will delete all related information from both tables at once

like delete from table 1 where code = 1
and delete from table where code = 1.1,2.1,3.1