handling serial numbers of a product

[hasanainf]

I have been trying to get a code for my project but have failed so
far. I hope the gurus will be able to help me and any help will be
highly appriciated

I have a form that has a quantity field, if I enter 10 (meaning 10pcs
of harddisk) into this field, another form opens, this time it allows
me to enter serial numbers of hard disks. After I am done entering the
tenths serial number, it should not allows me to enter anymore serial
numbers.

I hope I have explained myself well

Many thanks

 

[Pat Hartman \(MVP\)]

Having the count stored violates standard data normalization practices.
What is the purpose of making the user enter a count when you can count the
rows for him and display it when he closes the popup form?

 

[Guest]

In the second form, does the user enter the serial numbers in a subform, or
just enters that values one at a time into a text box?

1. You could pass the value to the 2nd form as the OpenArgs argument when
you open the 2nd form.

2. Then, each time the user enters a serial number (either in a textbox or
in a subform), you could check to see whether the user has entered the proper
number of serial numbers, and if so, change the AllowAdditions property of
the form to False.

Hope this gives you some ideas where to start.

Dale

 

[Tony Toews [MVP]]

Having the count stored violates standard data normalization practices.
What is the purpose of making the user enter a count when you can count the
rows for him and display it when he closes the popup form?

In this case I agree with him. He is selling 10 items so that's the
first part of his process and he is using that number for invoicing
purposes.

Then he wants to ensure that 10, and only 10, serial numbers get
entered.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/