Cub scout vest pattern. If I understand correctly what you are attempting, you need to concatenate the value of the recordset's NotificationDetailsOid column into the SQL statement: SQLD = 'INSERT into tblActivity (ReportSentDate,NotificationDetailsOid) ' & _ 'VALUES (' & sendDate & ',' &.Fields('NotificationDetailsOid') & ')' 'NotificationDetailsOid = PK datatype.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |