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 Rhinorhino 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: *

  • Users: Nalgene
  • Order by date
  1. Nalgene

    Waiting for audioClip to finish loading.

    Well, I've fixed it myself after a coffee and much thinking :) Since the search didn't bring up anything I'll post my solution here and hopefully it can help others that could use the search feature in the future. Basically I had no idea what I was doing when I started looking into how to...
  2. Nalgene

    Waiting for audioClip to finish loading.

    Hi everyone, I have an applet and I want it to have a background midi file. I've so far implement the classes found on Sun's site AppletSoundList and AppletSoundLoader. This is working well if I give it enough time to load the midi before starting it...so far I've been doing that using a...
  3. Nalgene

    Table design and relations logic problem...

    Hi lespaul, Yeah if I do an invoice I expect a shipping address. In the end that is the solution I implemented. I pick a shipping address when I start a new invoice which is working quite well so far. I populated a dropdown box with the records from a query which display the client and the...
  4. Nalgene

    Table design and relations logic problem...

    Well I think I've found another way to get it to do what I want. Instead of doing invoice by customers.cID I do it using shippingAddress.saID... I then pick the shipping address in a drop down menu that is populated from a query consisting of saID, cID and the name of the customer. I hide the...
  5. Nalgene

    Table design and relations logic problem...

    Alright, I've tried to dumb the query down to something very simple and still no go. I did it using SQL this time. I have this : SELECT invoice.*, customers.cName, customers.cFirstName, customers.cTel, customers.cEmail, customers.cStreet, customers.cCity, customers.cState, customers.cZIP...
  6. Nalgene

    Table design and relations logic problem...

    I have at the moment 1 entry in the shipping address table for testing purpose. I've tried with different join type like you said but I'm not really sure how those work so maybe I did it wrong. Right now as soon as I do a Query that include shipping address Access let me save it but its not...
  7. Nalgene

    Table design and relations logic problem...

    Ok, had some time to draw a quick representation in Paint its not pretty but shows what I have so far, all relations are 1-to-many : http://img123.imageshack.us/my.php?image=untitled1tw.jpg
  8. Nalgene

    Table design and relations logic problem...

    Hi everyone, I'm new to Access; I'm trying to learn it by myself at the moment and trying to apply some of the concepts from the example database that comes with access (Northwind). So I've decided to try to develop a software for my small business. I have tables for products, customers...

Part and Inventory Search

Back
Top