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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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?

Part and Inventory Search

Back
Top