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
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.
SPONSORED LINKS
| Microsoft access developer | Microsoft access help | Microsoft access database |
| Microsoft access training | Microsoft access training course | Microsoft access programming |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
