# Microsoft Access is melting my brain **URL:** \ **Category:** random\ **Created:** [March 24, 2003, 8:48pm UTC](https://forum.kirupa.com/t/microsoft-access-is-melting-my-brain/16410 "2003-03-24T20:48:48Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![JustSara](https://avatars.discourse-cdn.com/v4/letter/j/d26b3c/32.png) [@JustSara](https://forum.kirupa.com/u/JustSara)\ **Post date:** [March 24, 2003, 8:48pm UTC](https://forum.kirupa.com/t/microsoft-access-is-melting-my-brain/16410/1 "2003-03-24T20:48:48Z")
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. Sara ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [March 24, 2003, 9:00pm UTC](https://forum.kirupa.com/t/microsoft-access-is-melting-my-brain/16410/2 "2003-03-24T21:00:23Z")
What is it exactly you need help with? plus, posting the database would help a lot 🙂 ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [March 24, 2003, 9:13pm UTC](https://forum.kirupa.com/t/microsoft-access-is-melting-my-brain/16410/3 "2003-03-24T21:13:29Z")
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 > **[Save BIG with $9.99 .COMs from GoDaddy!](http://www.sweeperhead.com/database.htm)** > > Get your own corner of the Web for less! Register a new .COM for just $9.99 for the first year and get everything you need to make your mark online — website builder, hosting, email, and more. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [March 24, 2003, 9:19pm UTC](https://forum.kirupa.com/t/microsoft-access-is-melting-my-brain/16410/4 "2003-03-24T21:19:42Z")
thanks… im looking at it now :beam: ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [March 24, 2003, 9:24pm UTC](https://forum.kirupa.com/t/microsoft-access-is-melting-my-brain/16410/5 "2003-03-24T21:24:47Z")
i got access XP with office xp pro yesterday but not sure what its for…i know db but i dont know anything bout that. lol. but my mom needed it so… ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [March 24, 2003, 9:30pm UTC](https://forum.kirupa.com/t/microsoft-access-is-melting-my-brain/16410/6 "2003-03-24T21:30:24Z")
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! ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [March 24, 2003, 9:32pm UTC](https://forum.kirupa.com/t/microsoft-access-is-melting-my-brain/16410/7 "2003-03-24T21:32:57Z")
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 🙂 ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [March 24, 2003, 9:33pm UTC](https://forum.kirupa.com/t/microsoft-access-is-melting-my-brain/16410/8 "2003-03-24T21:33:41Z")
i want Splinter Cell thats on my ‘To rent then later Buy’ list. lol. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [March 24, 2003, 9:53pm UTC](https://forum.kirupa.com/t/microsoft-access-is-melting-my-brain/16410/9 "2003-03-24T21:53:19Z")
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. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [March 24, 2003, 10:04pm UTC](https://forum.kirupa.com/t/microsoft-access-is-melting-my-brain/16410/10 "2003-03-24T22:04:11Z")
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 🙂