Enter data between range then split

[Kereng]

Hi,

I am very new to Access and am struggling as to whether the following is possible:

We have a situation where we need to enter a range of pallet numbers into a form, but then have the table behind the form store the numbers in the range individually.

For example, the data entry may be Pallet Numbers 1 - 50. We would need it stored in the table as Pallet Number 1, Pallet Number 2, Pallet Number 3 and so on. This is so that we could then assign an action to each pallet - for instance, we may release one or two out of the range at one time, then the rest later, or we may dump certain pallet numbers.

I can't have the user always enter each pallet number individually as this would take too long, though in some instances there may only be one or two pallet numbers, in which case they would enter them individually.

Is it possible to do this? If so, how do I go about it? As said, I am very new to Access and therefore don't know any VBA or SQL coding. I want to be able to do this through general Access, if at all possible.

Any help gratefully received.

 

[Rabbie]

It certainly is possible using VBA to write the individual records from a range entered on your form. I don't think you can do this easily using SQL.

The VBA should be pretty straight forward and if you have specific problems just post them and we will do our best to help you

 

[Kereng]

Thanks for the reply. Unfortunately, I don't know any VBA (haven't done any since programming PLCs in uni, far too long ago). Is there a way of doing it without using VBA, just with general Access commands? If not, I'll investigate VBA but would prefer this as a last resort.