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 gkittelson 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. 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