Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Someone please help me!

Discussion in 'Information Technology' started by Candace, Jul 28, 2006.

Tags:
  1. Candace

    Candace
    Expand Collapse
    Guest

    I really need some help and I'm on a serious time crunch. I've set up a form
    that asks for a job number, then
    pulls up that record. I need to be able to type in the empty fields located
    on this form. When I try to enter data into the other fields I get an error
    that states that I can't enter value into blank field on 'one' side of join.
    Does anyone know how to do this?
     
  2. Loading...

    Similar Threads Forum Date
    What is view of Sikhism on lending money to someone? Questions and Answers Nov 17, 2015
    Ardas For Someone Questions and Answers Feb 20, 2015
    Leisure Can someone pls help me find this Waheguru Simran...?? Business, Lifestyle & Leisure Aug 5, 2014
    Is it wrong for a Sikh to marry someone with a different religion? Sikh Youth Apr 27, 2013
    Learn Punjabi Can someone pls translate for me?? Language, Arts & Culture Feb 7, 2013

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Is the form that asks for a job number bound to a field on the main form or
    is it an unbound field on a popup (or sub form) that is different to the form
    the you are trying to "fill-in" the fields.

    Are all the fields (includeing the "ask for a job number" field) based on
    the same table - query.

    Can you let us have some more details

    --
    Wayne
    Manchester, England.



    "Candace" wrote:

    > I really need some help and I'm on a serious time crunch. I've set up a form
    > that asks for a job number, then
    > pulls up that record. I need to be able to type in the empty fields located
    > on this form. When I try to enter data into the other fields I get an error
    > that states that I can't enter value into blank field on 'one' side of join.
    > Does anyone know how to do this?
    >
    >
     
  4. Candace

    Candace
    Expand Collapse
    Guest

    There are two tables which are joined in a query. When opened a parameter
    box pops up asking for the 'job number'. There are four fields being used
    from the first table(this is the information which is populated) and the rest
    are from the second table. All fields are bound and all are based on the
    same query. I must tell you I am not good at writing the code, I'm still
    using Access the old fashioned way, with the commands that are offered, plus
    it's Access 97.


    "Wayne-I-M" wrote:

    > Is the form that asks for a job number bound to a field on the main form or
    > is it an unbound field on a popup (or sub form) that is different to the form
    > the you are trying to "fill-in" the fields.
    >
    > Are all the fields (includeing the "ask for a job number" field) based on
    > the same table - query.
    >
    > Can you let us have some more details
    >
    > --
    > Wayne
    > Manchester, England.
    >
    >
    >
    > "Candace" wrote:
    >
    > > I really need some help and I'm on a serious time crunch. I've set up a form
    > > that asks for a job number, then
    > > pulls up that record. I need to be able to type in the empty fields located
    > > on this form. When I try to enter data into the other fields I get an error
    > > that states that I can't enter value into blank field on 'one' side of join.
    > > Does anyone know how to do this?
    > >
    > >
     
  5. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    You are trying to update a foreign field without the record being linked to a
    field in the primary table. (You can't enter apples, pears, etc without
    fruit being one of the categories). And in you case you can't enter
    information for a job that does not exist (in the main/primary table )

    Make sure the Primary Key field is shown in the query

    Check the referential integrity of the joins on the relationships page.

    Also when you have time check this link on the MS site

    http://support.microsoft.com/?scid=kb;en-us;304473&spid=2509&sid=216


    --
    Wayne
    Manchester, England.
    --
    --
    Wayne
    Manchester, England.



    "Candace" wrote:

    > There are two tables which are joined in a query. When opened a parameter
    > box pops up asking for the 'job number'. There are four fields being used
    > from the first table(this is the information which is populated) and the rest
    > are from the second table. All fields are bound and all are based on the
    > same query. I must tell you I am not good at writing the code, I'm still
    > using Access the old fashioned way, with the commands that are offered, plus
    > it's Access 97.
    >
    >
    > "Wayne-I-M" wrote:
    >
    > > Is the form that asks for a job number bound to a field on the main form or
    > > is it an unbound field on a popup (or sub form) that is different to the form
    > > the you are trying to "fill-in" the fields.
    > >
    > > Are all the fields (includeing the "ask for a job number" field) based on
    > > the same table - query.
    > >
    > > Can you let us have some more details
    > >
    > > --
    > > Wayne
    > > Manchester, England.
    > >
    > >
    > >
    > > "Candace" wrote:
    > >
    > > > I really need some help and I'm on a serious time crunch. I've set up a form
    > > > that asks for a job number, then
    > > > pulls up that record. I need to be able to type in the empty fields located
    > > > on this form. When I try to enter data into the other fields I get an error
    > > > that states that I can't enter value into blank field on 'one' side of join.
    > > > Does anyone know how to do this?
    > > >
    > > >
     
  6. Candace

    Candace
    Expand Collapse
    Guest

    Thank you

    "Wayne-I-M" wrote:

    > You are trying to update a foreign field without the record being linked to a
    > field in the primary table. (You can't enter apples, pears, etc without
    > fruit being one of the categories). And in you case you can't enter
    > information for a job that does not exist (in the main/primary table )
    >
    > Make sure the Primary Key field is shown in the query
    >
    > Check the referential integrity of the joins on the relationships page.
    >
    > Also when you have time check this link on the MS site
    >
    > http://support.microsoft.com/?scid=kb;en-us;304473&spid=2509&sid=216
    >
    >
    > --
    > Wayne
    > Manchester, England.
    > --
    > --
    > Wayne
    > Manchester, England.
    >
    >
    >
    > "Candace" wrote:
    >
    > > There are two tables which are joined in a query. When opened a parameter
    > > box pops up asking for the 'job number'. There are four fields being used
    > > from the first table(this is the information which is populated) and the rest
    > > are from the second table. All fields are bound and all are based on the
    > > same query. I must tell you I am not good at writing the code, I'm still
    > > using Access the old fashioned way, with the commands that are offered, plus
    > > it's Access 97.
    > >
    > >
    > > "Wayne-I-M" wrote:
    > >
    > > > Is the form that asks for a job number bound to a field on the main form or
    > > > is it an unbound field on a popup (or sub form) that is different to the form
    > > > the you are trying to "fill-in" the fields.
    > > >
    > > > Are all the fields (includeing the "ask for a job number" field) based on
    > > > the same table - query.
    > > >
    > > > Can you let us have some more details
    > > >
    > > > --
    > > > Wayne
    > > > Manchester, England.
    > > >
    > > >
    > > >
    > > > "Candace" wrote:
    > > >
    > > > > I really need some help and I'm on a serious time crunch. I've set up a form
    > > > > that asks for a job number, then
    > > > > pulls up that record. I need to be able to type in the empty fields located
    > > > > on this form. When I try to enter data into the other fields I get an error
    > > > > that states that I can't enter value into blank field on 'one' side of join.
    > > > > Does anyone know how to do this?
    > > > >
    > > > >
     
  7. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 8 Jun 2006 08:37:02 -0700, Candace
    <Candace@discussions.microsoft.com> wrote:

    >There are two tables which are joined in a query. When opened a parameter
    >box pops up asking for the 'job number'. There are four fields being used
    >from the first table(this is the information which is populated) and the rest
    >are from the second table. All fields are bound and all are based on the
    >same query. I must tell you I am not good at writing the code, I'm still
    >using Access the old fashioned way, with the commands that are offered, plus
    >it's Access 97.


    PLease open the Query in SQL view and post it here. It sounds like the
    error lies within the query (at least in part).

    Remember... we're volunteers here, not sorcerers. We *cannot see your
    database*. We don't know the structure of your query or of your form.

    Typically, if you have two tables to update, you'll be better off
    using a Form for the "one" side table of the relationship and a
    Subform for the "many", using the primary key and the corresponding
    foreign key field as the Master and Child Link Fields respectively.

    John W. Vinson[MVP]
     

Share This Page