Enter a list of numbers

[Guest]

I'm having a bad day. I want for my users to be able to enter a list of
numbers.
The numbers will be 6 digits, no alphas. But i don't know how many numbers
will be entered, from 1 to 20 ish.
They are to be stored with the rest of the details on the form.
What would be the best way to do this?
1 field on the form if so what sort text or list box with no row source, or
a linked subform?
What format restrictions can I put on the entry to ensure they only enter
numbers?

Thanks in advance
Dean

 

[Guest]

Dean,

If you do not know the amount of numbers to be entered then I would use a
linked Table and a Subform.

In order to ensure the users input numbers only use the Input Mask on the
field

For example:
000000 forces the user to input 6 digits
999999 Digits or spaces required by not compulsory

HTH
Mark

 

[Douglas J. Steele]

Data isn't stored on forms: it's stored in tables. You need a table with a
Long Integer field to hold the numbers. If there can be multiple numbers
associated with the rest of the data on the form, you'll need two tables:
one to hold "the rest of the data", linked to the one that holds the
numbers.

 

[Joseph Meehan]

I'm having a bad day. I want for my users to be able to enter a list
of numbers.
The numbers will be 6 digits, no alphas. But i don't know how many
numbers will be entered, from 1 to 20 ish.
They are to be stored with the rest of the details on the form.
What would be the best way to do this?
1 field on the form if so what sort text or list box with no row
source, or a linked subform?
What format restrictions can I put on the entry to ensure they only
enter numbers?

Thanks in advance
Dean

Forms don't store data. Tables store data.

It would appear you would want Table A with the basic record data and a
related Table B to store these numbers. Table A needs to have one unique
field for every entry in Table A. This unique value is then added to every
new record in Table B so Access knows that all the records in table B with a
value of 1 in the linked field belong with record 1 of Table A

Table A
ID# FieldA FieldB FieldC ...
1, DataA1, DataB1, DataC1, etc
2, DataA2, DataB2, DataC2, etc


Table B
LinkID#, Number
1 259872
1 548871
1 015473
2 456743
2 002500


Using queries forms and reports will allow you to display this
information in many different ways. If you make the field "Number" (BTW
"Number" would be a bad name to use for a field name) a number filed type,
then only numbers could be entered. You can make additional restrictions as
well as needed.

 

[Guest]

Douglas,

Could you help a bit more, as I stated at the begining "I'm having a bad day".
I want
Text field
Supplier

Date/Time

Yes/No
Booking _Form
Untimley_changes

The supplier is a combo box that is inked to the system, he user selects a
name from the dropdown list.
They then enter the date/Time and click the Yes/No as appropriate.
The user should then enter the list of PO numbers into the sub form.

Can you tell me how I can do this?
I am a very basic user.

Thank you.

Dean