Tom Did you got my email about my Access file that I send to you?
--- In AccessDevelopers@yahoogroups.com, "peaches1979_2001" <[EMAIL PROTECTED]> wrote: > > I am unable to upload the file to the folder called "Need help". Can > I email the zip file to you? I couldn't cause of my internet > connection. Let me know if I can email you the file. > > > --- In AccessDevelopers@yahoogroups.com, "Tom Oakes" <[EMAIL PROTECTED]> > wrote: > > > > Please zip it and upload it to the files section of the group site > under > > "Need Help With". > > > > Tom Oakes > > Personal PC Consultants, Inc. > > [EMAIL PROTECTED] > > 503.230.0911 (O) > > 402.968.6946 (C) > > 734.264.0911 (F) > > > > > > > > _____ > > > > From: AccessDevelopers@yahoogroups.com > > [mailto:[EMAIL PROTECTED] On Behalf Of > peaches1979_2001 > > Sent: Sunday, December 18, 2005 9:07 AM > > To: AccessDevelopers@yahoogroups.com > > Subject: [AccessDevelopers] Re: Need Help Creating MS Access > Database > > > > > > Tom > > > > Could I email you the file so that you can take a look at it and > if > > you can make any changes to it? I think it is better that way if > you > > want to help me with it. > > > > Thanks > > > > > > > > > > --- In AccessDevelopers@yahoogroups.com, "Tom Oakes" <[EMAIL PROTECTED]> > > wrote: > > > > > > You need to add a field in your "Sold" table that represents the > > customer > > > number. FYI, naming a field "Number" is not a good idea, > generally > > > speaking. > > > > > > I'd suggest naming the AutoNumber field in the customers > > table "CustomerID", > > > and adding a field of type Long, also named CustomerID to > > the "Sold" table. > > > Without the CustomerID field in the Sold table, you wouldn't > know > > to which > > > customer a given record relates. > > > > > > Tom Oakes > > > Personal PC Consultants, Inc. > > > [EMAIL PROTECTED] > > > 503.230.0911 (O) > > > 402.968.6946 (C) > > > 734.264.0911 (F) > > > > > > > > > > > > _____ > > > > > > From: AccessDevelopers@yahoogroups.com > > > [mailto:[EMAIL PROTECTED] On Behalf Of > > peaches1979_2001 > > > Sent: Saturday, December 17, 2005 12:55 PM > > > To: AccessDevelopers@yahoogroups.com > > > Subject: [AccessDevelopers] Re: Need Help Creating MS Access > > Database > > > > > > > > > I think you need to create a query form. > > > Here is a list of two tables that I have in them > > > > > > Customer tabe----number (Auto number), id, name, address, city, > > > state, zip, email addresss > > > > > > Sold----Number they bought (auto number), Qty, discription, price > > > > > > I want the subform to match the customer information on each > > record > > > and be different on each of the cutomer that i ave sold to. > > > > > > > > > > > > > > > > > > > > > --- In AccessDevelopers@yahoogroups.com, "Tom Oakes" <[EMAIL PROTECTED]> > > > wrote: > > > > > > > > I don't think you need to join tables in a query for this one. > > > > > > > > 1) create your main form; with the customer table as the source > > > > 2) add a subform to your main form; with the "sold" table as > the > > > source > > > > > > > > The "sold" table needs to have a customer id in it, or > something > > > to link it > > > > to the customer record. You'll specify the relationship > between > > > the form > > > > and subform when you add the subform. > > > > > > > > Tom Oakes > > > > Personal PC Consultants, Inc. > > > > [EMAIL PROTECTED] > > > > 503.230.0911 (O) > > > > 402.968.6946 (C) > > > > 734.264.0911 (F) > > > > > > > > > > > > > > > > _____ > > > > > > > > From: AccessDevelopers@yahoogroups.com > > > > [mailto:[EMAIL PROTECTED] On Behalf Of > > > peaches1979_2001 > > > > Sent: Friday, December 16, 2005 10:52 PM > > > > To: AccessDevelopers@yahoogroups.com > > > > Subject: [AccessDevelopers] Need Help Creating MS Access > Database > > > > > > > > > > > > I am trying to create a database for my customers where I just > > > type in > > > > the information in the form. My main problem is trying to > create > > a > > > > subform where I just want the following: > > > > > > > > Number have bought > > > > Qty > > > > Discription > > > > Price > > > > > > > > I hvae one table for my cutomers and another table for sold. I > > > know I > > > > need to have two tables in the Quries..but I don't know what > > other > > > > table should have? Any ideas? I am going to be using this with > > > Ebay > > > > when I sell stuff. > > > > > > > > IF anyone can help me out, I apprecitate it. > > > > > > > > > > > > > > > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > > > > > > > > > > > > > > > > > > > SPONSORED LINKS > > > > Microsoft > > > > <http://groups.yahoo.com/gads? > > > t=ms&k=Microsoft+access+developer&w1=Microsoft > > > > > > > > > > +access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databa > > > se&w4=M > > > > > > > > > > icrosoft+access+training&w5=Microsoft+access+training+course&w6=Micro > > > soft+ac > > > > cess+programming&c=6&s=193&.sig=d-CjBIrYOH9NCKHYFeGZJA> access > > > developer > > > > Microsoft > > > > <http://groups.yahoo.com/gads? > > > t=ms&k=Microsoft+access+help&w1=Microsoft+acce > > > > > > > > > > ss+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4 > > > =Micros > > > > > > > > > > oft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+ > > > access+ > > > > programming&c=6&s=193&.sig=crx-d4AAhdklv_VozGVAUw> access help > > > Microsoft > > > > <http://groups.yahoo.com/gads? > > > t=ms&k=Microsoft+access+database&w1=Microsoft+ > > > > > > > > > > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databas > > > e&w4=Mi > > > > > > > > > > crosoft+access+training&w5=Microsoft+access+training+course&w6=Micros > > > oft+acc > > > > ess+programming&c=6&s=193&.sig=qg2hDuQNweByMCX0NU7cEA> access > > > database > > > > Microsoft > > > > <http://groups.yahoo.com/gads? > > > t=ms&k=Microsoft+access+training&w1=Microsoft+ > > > > > > > > > > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databas > > > e&w4=Mi > > > > > > > > > > crosoft+access+training&w5=Microsoft+access+training+course&w6=Micros > > > oft+acc > > > > ess+programming&c=6&s=193&.sig=bLZHqTqWUQny609X1OkmNA> access > > > training > > > > Microsoft > > > > <http://groups.yahoo.com/gads? > > > t=ms&k=Microsoft+access+training+course&w1=Mic > > > > > > > > > > rosoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+ > > > databas > > > > > > > > > > e&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6 > > > =Micros > > > > oft+access+programming&c=6&s=193&.sig=d8GQXfQW3RZ64rOfzIMo8A> > > > access > > > > training course Microsoft > > > > <http://groups.yahoo.com/gads? > > > t=ms&k=Microsoft+access+programming&w1=Microso > > > > > > > > > > ft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+data > > > base&w4 > > > > > > > > > > =Microsoft+access+training&w5=Microsoft+access+training+course&w6=Mic > > > rosoft+ > > > > access+programming&c=6&s=193&.sig=iXDlL79-kkgjv6fLyFu3Sg> > access > > > programming > > > > > > > > > > > > _____ > > > > > > > > YAHOO! GROUPS LINKS > > > > > > > > > > > > > > > > * Visit your group "AccessDevelopers > > > > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > > > > > > > > > > * To unsubscribe from this group, send an email to: > > > > [EMAIL PROTECTED] > > > > <mailto:[EMAIL PROTECTED] > > > subject=Unsubscribe> > > > > > > > > > > > > * Your use of Yahoo! Groups is subject to the Yahoo! > Terms > > of > > > Service > > > > <http://docs.yahoo.com/info/terms/> . > > > > > > > > > > > > _____ > > > > > > > > > > > > > > > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > > > > > > > > > > > > > > SPONSORED LINKS > > > Microsoft > > > <http://groups.yahoo.com/gads? > > t=ms&k=Microsoft+access+developer&w1=Microsoft > > > > > > +access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databa > > se&w4=M > > > > > > icrosoft+access+training&w5=Microsoft+access+training+course&w6=Micro > > soft+ac > > > cess+programming&c=6&s=193&.sig=d-CjBIrYOH9NCKHYFeGZJA> access > > developer > > > Microsoft > > > <http://groups.yahoo.com/gads? > > t=ms&k=Microsoft+access+help&w1=Microsoft+acce > > > > > > ss+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4 > > =Micros > > > > > > oft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+ > > access+ > > > programming&c=6&s=193&.sig=crx-d4AAhdklv_VozGVAUw> access help > > Microsoft > > > <http://groups.yahoo.com/gads? > > t=ms&k=Microsoft+access+database&w1=Microsoft+ > > > > > > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databas > > e&w4=Mi > > > > > > crosoft+access+training&w5=Microsoft+access+training+course&w6=Micros > > oft+acc > > > ess+programming&c=6&s=193&.sig=qg2hDuQNweByMCX0NU7cEA> access > > database > > > Microsoft > > > <http://groups.yahoo.com/gads? > > t=ms&k=Microsoft+access+training&w1=Microsoft+ > > > > > > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databas > > e&w4=Mi > > > > > > crosoft+access+training&w5=Microsoft+access+training+course&w6=Micros > > oft+acc > > > ess+programming&c=6&s=193&.sig=bLZHqTqWUQny609X1OkmNA> access > > training > > > Microsoft > > > <http://groups.yahoo.com/gads? > > t=ms&k=Microsoft+access+training+course&w1=Mic > > > > > > rosoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+ > > databas > > > > > > e&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6 > > =Micros > > > oft+access+programming&c=6&s=193&.sig=d8GQXfQW3RZ64rOfzIMo8A> > > access > > > training course Microsoft > > > <http://groups.yahoo.com/gads? > > t=ms&k=Microsoft+access+programming&w1=Microso > > > > > > ft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+data > > base&w4 > > > > > > =Microsoft+access+training&w5=Microsoft+access+training+course&w6=Mic > > rosoft+ > > > access+programming&c=6&s=193&.sig=iXDlL79-kkgjv6fLyFu3Sg> access > > programming > > > > > > > > > _____ > > > > > > YAHOO! GROUPS LINKS > > > > > > > > > > > > * Visit your group "AccessDevelopers > > > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > > > > > > > * To unsubscribe from this group, send an email to: > > > [EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED] > > subject=Unsubscribe> > > > > > > > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms > of > > Service > > > <http://docs.yahoo.com/info/terms/> . > > > > > > > > > _____ > > > > > > > > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > > > > > > > _____ > > > > YAHOO! GROUPS LINKS > > > > > > > > * Visit your group "AccessDevelopers > > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > > > > * To unsubscribe from this group, send an email to: > > [EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED] > subject=Unsubscribe> > > > > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service > > <http://docs.yahoo.com/info/terms/> . > > > > > > _____ > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
