Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SATYR76

  1. SATYR76

    PRIMARY KEY CLUSTERED

    Thank you that worked perfect
  2. SATYR76

    PRIMARY KEY CLUSTERED

    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...
  3. SATYR76

    SQL in a Form

    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
  4. SATYR76

    SQL in a Form

    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;"...
  5. SATYR76

    Alternating Shading between records

    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?
See more

Part and Inventory Search

Back
Top