I have an application with a VB6 front-end and an Access 97 back-end. The primary table in the database is a general information Group table. The Primary Key for the table is GroupNo. I am looking for the best method to copy an existing record to a new record with the same GroupNo concatenated with a designated suffix. This is quite easy entirely within Access using Insert SQL. What is the best way in VB?
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.