select multiple data from a form

[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…

 

[George Walsh]

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.

 

[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.