473,378 Members | 1,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

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 1908
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: ZaGras | last post by:
after i pack my vb program using package and deployment wizard, i try to install the program on other computer instead of my computer and run the program. when i click to add a new record to the...
1
by: gbb0330 | last post by:
hi guys -the code (all capital letters) generates daily packing number, it is in the on click event of a command button that moves to the next record. dpkn is unbound control - i use it to...
18
by: Edward Diener | last post by:
Is the packing alignment of __nogc classes stored as part of the assembly ? I think it must as the compiler, when referencing the assembly, could not know how the original data is packed otherwise....
1
by: Gajendra | last post by:
How does the byte packing and the byte alignment work in VC++ compiler? What is the effect of #pragma pack(n) on the alignment and byte packing for example while using the structur struc double...
2
by: Sonnich | last post by:
Hi all! I am still playing around with databases. So here it goes: Is packing needed for MySQL (5.0)? I have a new DB, which already is 178 MB. Will that continue to grow, when I add and...
11
by: SKBodner | last post by:
Hello, I'm stumped and I'm hoping someone could help me figure out the best way to track daily attendance for the next 6-4 months. I have a list of 80 or so participants who should be attended...
9
by: fraz | last post by:
Does anyone have code to solve a 3-d bin packing problem in php? I am trying to solve the issue of packing various sized rectangular shaped objects into boxes of three different sizes so as to use...
1
by: QbProg | last post by:
Hello, what I'm saying here is about VS 2005 WITHOUT service pack. I have two DLL projects, with EXACTLY the same project preferences and settings. Both have alignment set to "default", it...
1
by: swethak | last post by:
hi, i have a code to disply the calendar and add events to that. It works fine.But my requirement is to i have to disply a weekly and daily calendar.Any body plz suggest that what modifications i...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.