Would anyone be willing to help me out with Access? I’ve created some tables and some forms and I have a book but just when I think I have a handle on everything it becomes very obvious that I’m clueless.
For instance, I started with a simple form and table and everything worked great when I input text but now I’ve moved up to subforms and when I enter text it just overwrites itself. This is one hard mofo to learn on my own. Any help would be appreciated. If anyone wants to see the DB that I’m working on I will post it.
Here’s the database. Remember this is my very first one so there will probably be mistakes. Feel free to point them all out!
Here’s my problem. I inserted a subform into the Form ‘frmCustomerInformation’ so that I can list multiple products that a customer has bought.
Something’s wrong because when I input the customer information and the product information it just overwrites the first line. Instead of going onto Line 2 for the second customer it just overwrites line 1. Same with Products…
Any idea what I did wrong?
Ok… I can’t upload the database because it’s too big. You can download the zip file here: h
When I’m not trying to learn databasing I’m playing Splinter Cell on my new Xbox. I really, really stink at the game… I get scared too easily… but I can’t stop playing it!
hm… i cant seem to spot the error either I cant really understand the structure of the database. If you dont mind explaining that a bit i would probably to be able to look at it again
Basically, I have about a zillion invoices dating back to the early 80’s that have never been electronically filed. So, I’m trying to create a form where I can input the customer’s name, address, phone number etc., what they bought (using a drop down menu that already has all our products listed so I can just choose what I want instead of typing it), when they bought it and how much they paid for it.
I’m doing this so I can print reports to show my bosses who bought what and when (if they should want to know) and more importantly… we send out CD mailings of our catalog so I want to be able to print a list of customers that bought products between Xdate and Ydate. Or… a list of customers that bought a specific product…
I can create the form I’m just not sure how to set up the relationship between the tables.
hmm… can you have all the customers in a table, all the purchased items in another, and then make queries that get the cusotmer name from the customers table and the items they purchased from the other table. Then you will not need to use any subforms, unless you wanted to use them for some other reason.
would that work or am i missing something?
sorry, its just that it has been a long while since i worked with access
I cant really understand the structure of the database. If you dont mind explaining that a bit i would probably to be able to look at it again 