I am working on creating two table. Title_Copy and Rental
I created Title_Copy as such
Create Table Title_Copy
(
Title_ID Integer
Constraint Title_ID_FK
Foreign key(Title_ID)
References Title(Title_ID),
Copy_ID Integer,
Status Varchar(15) Not Null,
Constraint Status_PK
Check (Status...
below is the code i am using in a form
'" Begining of Code"
Private Sub AppenCD192_Click()
Dim strSQL1 As String
strSQL1 = "INSERT INTO Tbl_CO_CD_192 Select * FROM tbl_CD_192 " & _
" INNER JOIN tbl_CD_192 ON tbl_Employee_Computer_Data.Collector_Code = tbl_CD_192.CCODE;"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.