RE: [AccessDevelopers] Re: Need Help Creating MS Access Database

Tue, 20 Dec 2005 09:41:19 -0800

I did.  Please try to upload your file to the group website.  If you absolutely can't make that happen, email it to me and I'll upload it for you.
 

Tom Oakes
Personal PC Consultants, Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946 (C)
734.264.0911 (F)



From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of peaches1979_2001
Sent: Tuesday, December 20, 2005 8:37 AM
To: [email protected]
Subject: [AccessDevelopers] Re: Need Help Creating MS Access Database

Tom

Did you got my email about my Access file that I send to you?



--- In [email protected], "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 [email protected], "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: [email protected]
> > [mailto:[EMAIL PROTECTED] On Behalf Of
> peaches1979_2001
> > Sent: Sunday, December 18, 2005 9:07 AM
> > To: [email protected]
> > 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 [email protected], "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: [email protected]
> > > [mailto:[EMAIL PROTECTED] On Behalf Of
> > peaches1979_2001
> > > Sent: Saturday, December 17, 2005 12:55 PM
> > > To: [email protected]
> > > 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 [email protected], "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: [email protected]
> > > > [mailto:[EMAIL PROTECTED] On Behalf Of
> > > peaches1979_2001
> > > > Sent: Friday, December 16, 2005 10:52 PM
> > > > To: [email protected]
> > > > 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/> .
> >
> >
> >   _____
> >
>


Please zip all files prior to uploading to Files section.


YAHOO! GROUPS LINKS



Reply via email to