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...
hello VJ
thanks for the help I had to add one thing to it but i got it to work
strSQL1 = "INSERT INTO Tbl_CO_CD_192 Select tbl_CD_192.* FROM tbl_CD_192 " & _
" INNER JOIN tbl_Employee_Computer_Data ON tbl_CD_192.CCODE = tbl_Employee_Computer_Data.Collector_Code;"
Thanks again
MJ
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;"...
Michael
I used your thread to alternate shading between records in a report. However i changed the "Const XorToggle = 4144959" to "Const XorToggle = VBYellow" and I get solid blue. Did i do somehting wrong or is it because i am still useing Access 97?
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.