Welcome to SPN

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

Sign Up Now!

Inputing of info inside selected data

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

  1. renebeets

    renebeets
    Expand Collapse
    Guest

    I have created a drop down in my table which allows me to choose Paragraph
    1,2 or 3 (see below) and then I need to ask for the relevant information
    required by the selected paragraph and this is where I'm stuck!!!

    My user needs to select one of the paragraphs and then depending on which
    one is selected, they then need to fill in additional information, as
    follows:-

    PARAGRAPH1
    'Property' means the immovable property described as [insert full property
    description] and includes all buildings on and improvements to the Property,
    and 'Properties', if more than one, is to be construed accordingly;

    PARAGRAPH2
    'Property' means a sectional title unit consisting of section number [insert
    number] in the sectional title scheme known as [insert name in full] together
    with an undivided share in the common property of such sectional title scheme
    and includes, where applicable, any right of exclusive use, and 'Properties',
    if more than one, is to be construed accordingly;

    PARAGRAPH3
    'Property' means the Borrower’s entire right, title and interest in and to
    the notarial deed of lease entered into between [insert full name and
    identity or registration number of landlord] and the Borrower in respect of
    the immovable property described as [insert full property description], and
    'Properties', if more than one, is to be construed accordingly;

    Any and all help is GREATLY appreciated

    Regards,
    Rene
     
  2. Loading...


  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Hi Rene,

    use a FORM to input data into your table. That is where you
    want to define the lookup, not in the table design. You can
    then use the AfterUpdate event of a control to determine
    what to do.

    Don't use lookup fields in table design
    http://www.mvps.org/access/lookupfields.htm


    Warm Regards,
    Crystal
    Microsoft Access MVP 2006

    *
    Have an awesome day ;)

    remote programming and training
    strive4peace2006 at yahoo.com

    *

    renebeets wrote:
    > I have created a drop down in my table which allows me to choose Paragraph
    > 1,2 or 3 (see below) and then I need to ask for the relevant information
    > required by the selected paragraph and this is where I'm stuck!!!
    >
    > My user needs to select one of the paragraphs and then depending on which
    > one is selected, they then need to fill in additional information, as
    > follows:-
    >
    > PARAGRAPH1
    > 'Property' means the immovable property described as [insert full property
    > description] and includes all buildings on and improvements to the Property,
    > and 'Properties', if more than one, is to be construed accordingly;
    >
    > PARAGRAPH2
    > 'Property' means a sectional title unit consisting of section number [insert
    > number] in the sectional title scheme known as [insert name in full] together
    > with an undivided share in the common property of such sectional title scheme
    > and includes, where applicable, any right of exclusive use, and 'Properties',
    > if more than one, is to be construed accordingly;
    >
    > PARAGRAPH3
    > 'Property' means the Borrower’s entire right, title and interest in and to
    > the notarial deed of lease entered into between [insert full name and
    > identity or registration number of landlord] and the Borrower in respect of
    > the immovable property described as [insert full property description], and
    > 'Properties', if more than one, is to be construed accordingly;
    >
    > Any and all help is GREATLY appreciated
    >
    > Regards,
    > Rene
     
  4. FinRazel

    FinRazel
    Expand Collapse
    Guest

    This answer will only get you part way there, but here it is anyway:
    I would set up a table for each paragraph (Par1, Par2, and Par3) having just
    an autonumber field and fields for the inputs for each paragraph. For
    example, my Par1 table included just Par1ID and the field FullDescription.
    Then, I'd make queries based on those tables to complete your paragraphs.
    Here is the SQL from my Par1Qry:

    SELECT Par1.Par1ID, Par1.FullDescription, "'Property' means the immovable
    property described as " & [Par1]![FullDescription] & " and includes all
    buildings on and improvements to the Property,
    and 'Properties', if more than one, is to be construed accordingly;" AS Par1
    FROM Par1;


    At this point, you could make forms based on these queries and have your
    listbox be a control for which form to open.
    --
    Anne Murray


    "renebeets" wrote:

    > I have created a drop down in my table which allows me to choose Paragraph
    > 1,2 or 3 (see below) and then I need to ask for the relevant information
    > required by the selected paragraph and this is where I'm stuck!!!
    >
    > My user needs to select one of the paragraphs and then depending on which
    > one is selected, they then need to fill in additional information, as
    > follows:-
    >
    > PARAGRAPH1
    > 'Property' means the immovable property described as [insert full property
    > description] and includes all buildings on and improvements to the Property,
    > and 'Properties', if more than one, is to be construed accordingly;
    >
    > PARAGRAPH2
    > 'Property' means a sectional title unit consisting of section number [insert
    > number] in the sectional title scheme known as [insert name in full] together
    > with an undivided share in the common property of such sectional title scheme
    > and includes, where applicable, any right of exclusive use, and 'Properties',
    > if more than one, is to be construed accordingly;
    >
    > PARAGRAPH3
    > 'Property' means the Borrower’s entire right, title and interest in and to
    > the notarial deed of lease entered into between [insert full name and
    > identity or registration number of landlord] and the Borrower in respect of
    > the immovable property described as [insert full property description], and
    > 'Properties', if more than one, is to be construed accordingly;
    >
    > Any and all help is GREATLY appreciated
    >
    > Regards,
    > Rene
     
  5. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Hi Rene,

    With all due respect, I would suggest putting each of the
    paragrahs into the SAME table structure -- you could have
    another field that numbers the paragraphs.

    Otherwise, what Anne suggested about seperating the
    paragraphs is a good idea. You would have an AutonumberID
    that is the primary key. You would also have a Long Integer
    field to act as a foreign key so you could match the
    paragrahs with where they belong, as well as an integer
    ParaNo field.

    The main record would be displayed on a form. Then, you can
    use a continuous subform to display the paragraphs for the
    main record.

    To fill the additional information, you could have a
    seperate subform control on the main form and swap the
    SourceObject to collect the pertinent data.

    Do you understand how to use LinkChildFields and
    LinkMasterFields? For the second subform, you would have a
    calculated control on your main form to use for its
    LinkMasterFields.

    Post back if you need any clarification.

    Warm Regards,
    Crystal
    Microsoft Access MVP 2006

    *
    Have an awesome day ;)

    remote programming and training
    strive4peace2006 at yahoo.com

    *

    FinRazel wrote:
    > This answer will only get you part way there, but here it is anyway:
    > I would set up a table for each paragraph (Par1, Par2, and Par3) having just
    > an autonumber field and fields for the inputs for each paragraph. For
    > example, my Par1 table included just Par1ID and the field FullDescription.
    > Then, I'd make queries based on those tables to complete your paragraphs.
    > Here is the SQL from my Par1Qry:
    >
    > SELECT Par1.Par1ID, Par1.FullDescription, "'Property' means the immovable
    > property described as " & [Par1]![FullDescription] & " and includes all
    > buildings on and improvements to the Property,
    > and 'Properties', if more than one, is to be construed accordingly;" AS Par1
    > FROM Par1;
    >
    >
    > At this point, you could make forms based on these queries and have your
    > listbox be a control for which form to open.
     

Share This Page