468,140 Members | 1,641 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,140 developers. It's quick & easy.

Daily Packing Number

Hi all

I need some advice.

the daily packing number will be used to match a box with its label.

the guys in the warehouse will get a list of items to pack. they will
find the item - put it in a box and click a button [packed] at this
point the daily packing packing number will be genrated. the packing
guy will write it on the box.

later the labels will be printed, for each box. andthe packing guy will
know which label goes where.

reuirement, the packing number must be easy to remeber, no more than 4
digits.
must be unique, and must start over every day or every week.

what is the best way to do this?
any ideas?

Nov 13 '05 #1
2 1600
On 17 Feb 2005 13:58:19 -0800, gbb0330 <gb*****@gmail.com> wrote:
the daily packing number will be used to match a box with its label.

the guys in the warehouse will get a list of items to pack. they will
find the item - put it in a box and click a button [packed] at this
point the daily packing packing number will be genrated. the packing
guy will write it on the box.

later the labels will be printed, for each box. andthe packing guy will
know which label goes where.

reuirement, the packing number must be easy to remeber, no more than 4
digits.
must be unique, and must start over every day or every week.

what is the best way to do this?
any ideas?


A mix of two letters and two numbers would, IMHO, be easiest to remember,
if you can do that.
Darryl Kerkeslager
Nov 13 '05 #2
To start over every day ---

Me!PackingNum = IIF(DCcount("*","TblPacking","[PackedDate] = #" & Date() &
"#") = 0,1, _
DMax("[PackingNum]","TblPacking","[PackedDate] = #" & Date() & "#") +1
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"gbb0330" <gb*****@gmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
Hi all

I need some advice.

the daily packing number will be used to match a box with its label.

the guys in the warehouse will get a list of items to pack. they will
find the item - put it in a box and click a button [packed] at this
point the daily packing packing number will be genrated. the packing
guy will write it on the box.

later the labels will be printed, for each box. andthe packing guy will
know which label goes where.

reuirement, the packing number must be easy to remeber, no more than 4
digits.
must be unique, and must start over every day or every week.

what is the best way to do this?
any ideas?

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by ZaGras | last post: by
1 post views Thread by gbb0330 | last post: by
18 posts views Thread by Edward Diener | last post: by
1 post views Thread by Gajendra | last post: by
2 posts views Thread by Sonnich | last post: by
9 posts views Thread by fraz | last post: by
1 post views Thread by QbProg | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.