Welcome to SPN

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

Sign Up Now!

select multiple data from a form

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

  1. Dire straits

    Dire straits
    Expand Collapse
    Guest

    Hi All,
    I have created despatch software for my small business. I manufacture ten
    different products. Every product that is manufactured is given a serial
    number. At one time all serial numbers started from 1. I want to log all
    dispatches that take place. I have created a database where all transactions
    will be recorded. Using a data entry form I am able to input products
    shipped. I have also created a table with all serial numbers. I would like
    to open this table and tick the serial numbers that are being dispatched
    against the product. This is very similar to a pop up ‘Calendar’. The only
    difference is that I would like to select multiple serial numbers and then
    update the despatch record.
    I am sure that for you all this is easy as. But I am in dire straits and
    need help urgently…
     
  2. Loading...


  3. George Walsh

    George Walsh
    Expand Collapse
    Guest

    Is this roughly correct? Your data entry form uses fields from a table you
    call something like tbldispatches - which includes fields similar to an
    order table allowing you to enter information regarding the individual who
    purchased your product(s) as well as the specific product(s) they purchased.
    One detail regarding your products is the serial number, and you have
    assigned a serial number to the unique occurrence of the specific product a
    buyer purchased from you (i.e., like a software serial number, rather than
    simply a generic product number).

    It sounds like you are at the stage of implementing your access application
    where you are getting caught-up on entering the dispatches-to-date. You
    want to expedite your initial massive data entry process. You have listed
    all the serial numbers you have already issued and have that data in a
    table. You want to link the specific rows of serial numbers in the
    tblserialnumbers to your tbldispatches table so they are associated - with
    the potential that may be in the form where there could be many
    tblserialnumbers records associated with each tbldispatches record. You
    would like a field on your entry form to pop-up and allow you to select
    multiple serial number records to be linked with the specific tbldispatches
    record.

    Once all the already-assigned serial numbers of the tblserialnumber table
    have been linked with tbldispatches records, will the field on the entry
    form that allows you to record serial numbers need to change so that it
    either engages a process that generates unique serial numbers or allows you
    to enter otherwise specified serial numbers - rather than selecting multiple
    records from tblserialnumber?

    The tbldispatches table needs to have an autonumber format field that does
    not allow duplicates "tblsdispatchesID". The tblserialnumber table needs a
    numeric format field that by the name of "tbldispatchesID", and the two
    tables need to be identified as having a relationship "one-to-many" (i.e.,
    one tbldispatches to many tblserialnumber) in the relationships window.

    Assuming your data entry form uses fields from tbldispatches as the
    datasource, you can include a listbox drop-down tool on the data entry form
    to display the serial numbers from your tblserialnumber table, and I have an
    example that I can email to you that shows how you can adapt it to allow for
    multiple selections. For each tblserialnumber record the tbldispatchesID
    will be updated with the unique number that identifies the specific
    tbldispatches record you have selected from the listbox. In this way, the
    serial numbers you specify conform with the relationship you prescribed for
    the two tables. Once the records are so linked, you can create a sub-form
    to display the related serial numbers or create a query including desired
    fields from both tables - for reports, etc.

    These comments make lots of assumptions from what you posted, but it should
    give you a general idea of my thoughts about your problem. If you would
    like to provide further clarification and let me know if you want an example
    of multiple selections from a listbox, I will try to help.

    "Dire straits" <Direstraits@discussions.microsoft.com> wrote in message
    news:D0FA2310-EDEF-4BC4-8E17-0AF5A89F787F@microsoft.com...
    > Hi All,
    > I have created despatch software for my small business. I manufacture ten
    > different products. Every product that is manufactured is given a serial
    > number. At one time all serial numbers started from 1. I want to log all
    > dispatches that take place. I have created a database where all
    > transactions
    > will be recorded. Using a data entry form I am able to input products
    > shipped. I have also created a table with all serial numbers. I would
    > like
    > to open this table and tick the serial numbers that are being dispatched
    > against the product. This is very similar to a pop up 'Calendar'. The
    > only
    > difference is that I would like to select multiple serial numbers and then
    > update the despatch record.
    > I am sure that for you all this is easy as. But I am in dire straits and
    > need help urgently.
     
  4. Dire straits

    Dire straits
    Expand Collapse
    Guest

    Hi George,
    I am very grateful of you taking time out and answering my query. You're
    assumptions are correct. To make it user-friendly for the operator to select
    the serial numbers, I was hoping to create a form that will list all serial
    numbers and a tick box ï’ for yes/no function. All the serial numbers
    selected will be assigned to that particular transaction. I will really
    appreciate your offer of sending an example.
    I will now explain in further detail of the database that I am creating. I
    manufacture microphones in Australia and export all around the world. There
    are twelve different types. Each and every finished product is assigned a
    serial number. I have created database to record all receivables (in) and
    dispatches (out). Part of the despatch procedure is recording of the serial
    numbers in the database before despatch. As mentioned before that all serial
    numbers started from 1. Currently, the serial numbers are entered manually.
    I would like to create a form that is opened and all available serial numbers
    are listed in the form. The serial numbers can be selected by ticking the
    box opposite the serial numbers. This method can be a time saver as it will
    eliminate manual data entry and multiple serial numbers can be selected by
    using mouse.
    I will be really grateful for any help that you can provide.
    Thanks again,
    Dire Straits.


    "George Walsh" wrote:

    > Is this roughly correct? Your data entry form uses fields from a table you
    > call something like tbldispatches - which includes fields similar to an
    > order table allowing you to enter information regarding the individual who
    > purchased your product(s) as well as the specific product(s) they purchased.
    > One detail regarding your products is the serial number, and you have
    > assigned a serial number to the unique occurrence of the specific product a
    > buyer purchased from you (i.e., like a software serial number, rather than
    > simply a generic product number).
    >
    > It sounds like you are at the stage of implementing your access application
    > where you are getting caught-up on entering the dispatches-to-date. You
    > want to expedite your initial massive data entry process. You have listed
    > all the serial numbers you have already issued and have that data in a
    > table. You want to link the specific rows of serial numbers in the
    > tblserialnumbers to your tbldispatches table so they are associated - with
    > the potential that may be in the form where there could be many
    > tblserialnumbers records associated with each tbldispatches record. You
    > would like a field on your entry form to pop-up and allow you to select
    > multiple serial number records to be linked with the specific tbldispatches
    > record.
    >
    > Once all the already-assigned serial numbers of the tblserialnumber table
    > have been linked with tbldispatches records, will the field on the entry
    > form that allows you to record serial numbers need to change so that it
    > either engages a process that generates unique serial numbers or allows you
    > to enter otherwise specified serial numbers - rather than selecting multiple
    > records from tblserialnumber?
    >
    > The tbldispatches table needs to have an autonumber format field that does
    > not allow duplicates "tblsdispatchesID". The tblserialnumber table needs a
    > numeric format field that by the name of "tbldispatchesID", and the two
    > tables need to be identified as having a relationship "one-to-many" (i.e.,
    > one tbldispatches to many tblserialnumber) in the relationships window.
    >
    > Assuming your data entry form uses fields from tbldispatches as the
    > datasource, you can include a listbox drop-down tool on the data entry form
    > to display the serial numbers from your tblserialnumber table, and I have an
    > example that I can email to you that shows how you can adapt it to allow for
    > multiple selections. For each tblserialnumber record the tbldispatchesID
    > will be updated with the unique number that identifies the specific
    > tbldispatches record you have selected from the listbox. In this way, the
    > serial numbers you specify conform with the relationship you prescribed for
    > the two tables. Once the records are so linked, you can create a sub-form
    > to display the related serial numbers or create a query including desired
    > fields from both tables - for reports, etc.
    >
    > These comments make lots of assumptions from what you posted, but it should
    > give you a general idea of my thoughts about your problem. If you would
    > like to provide further clarification and let me know if you want an example
    > of multiple selections from a listbox, I will try to help.
    >
    > "Dire straits" <Direstraits@discussions.microsoft.com> wrote in message
    > news:D0FA2310-EDEF-4BC4-8E17-0AF5A89F787F@microsoft.com...
    > > Hi All,
    > > I have created despatch software for my small business. I manufacture ten
    > > different products. Every product that is manufactured is given a serial
    > > number. At one time all serial numbers started from 1. I want to log all
    > > dispatches that take place. I have created a database where all
    > > transactions
    > > will be recorded. Using a data entry form I am able to input products
    > > shipped. I have also created a table with all serial numbers. I would
    > > like
    > > to open this table and tick the serial numbers that are being dispatched
    > > against the product. This is very similar to a pop up 'Calendar'. The
    > > only
    > > difference is that I would like to select multiple serial numbers and then
    > > update the despatch record.
    > > I am sure that for you all this is easy as. But I am in dire straits and
    > > need help urgently.

    >
    >
    >
     

Share This Page