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!

  • 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 icpsvt

  1. icpsvt

    Array of STL Queues

    Hi, small problem I'm having. I've created an array of queues: queue<Process> pqueue[NUM_PRIORITY_LEVELS]; I know I could have used a vector of queues, but I think this will be easier to debug. I can insert elements into the first element of the array: pqueue[0].push(p); But when I...
  2. icpsvt

    Help on Key Violatoin Errors and Left Join

    right. The idea is we'll have multiple tables, a sign-up, class taken, and future classes. So what I want to be able to say is: Client #1 has taken class 1 2 3 4 Client #2 has taken class 2 3 4 6 Client #4 has signed up for class #1 3 4 5 Client #5 has signed up for class #1 3 4 2 That...
  3. icpsvt

    Help on Key Violatoin Errors and Left Join

    So there are 2000+ entries in the client table, and 3 entries I manually created in the signups table. If that makes sense. -Jason
  4. icpsvt

    Help on Key Violatoin Errors and Left Join

    no a client can only have one signup. the problem is that in the database - the signups table is empty, unless i check one of the options. then it appears.
  5. icpsvt

    Help on Key Violatoin Errors and Left Join

    That's fair. Here's a second attempt: tblClient PK = ID Autonumber firstname text lastname text tblSignups ID longint - this is linked to ID from tblClient overview - yes/no test - yes/no and my SQL: UPDATE clients LEFT JOIN signups ON clients.ID=signups.id SET signups.test = 1; And what...
  6. icpsvt

    Help on Key Violatoin Errors and Left Join

    Alright- This seemed like such an easy idea - but it's not working for me. I'm kinda messing around with access preparing for an upcoming project. Here's what I'm trying to do: I have a table with a bunch of client information [client]. Primary key is an autonumber field [id]. I have another...
  7. icpsvt

    Update Access Database from Excel Spreadsheet

    I think I got myself over my head here. First off - I'll explain what I know. SQL - Have a really good understanding of it, but haven't used it too much, so I'm sure there's room for improvement, but I don't think I need it here. VBA - Don't know a whole heck of a lot about it. At all. What...

Part and Inventory Search

Back
Top