Search results for query: *

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

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

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

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

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

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

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

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