Very Computer

In PDW, we would like to have the ability to enter new orders (records), then
whenever desired throughout the day, batch print all orders which have not
been printed previously.  We don't want to use a date to determine which
records to print as we desire to be able to print these new records at more
times that once during the day.

In order to do this, we are considering adding a field to our table that would
be blank at the time the order is entered, then programming a button that
would locate all records in which this field was blank (or could be a certain
status number), then print these new records, then change the field in each of
these records in order to indicate that they had been printed.

Is this the best way to accomplish this task or are there better or simpler
ways to accomplish this task.  All suggestions will be appreciated!  Feel free
to post or e-mail any responses.

Thanks in advance.

Bobby Hankins

: In PDW, we would like to have the ability to enter new orders (records), then
: whenever desired throughout the day, batch print all orders which have not
: been printed previously.  We don't want to use a date to determine which
: records to print as we desire to be able to print these new records at more
: times that once during the day.

: In order to do this, we are considering adding a field to our table that would
: be blank at the time the order is entered, then programming a button that
: would locate all records in which this field was blank (or could be a certain
: status number), then print these new records, then change the field in each of
: these records in order to indicate that they had been printed.

: Is this the best way to accomplish this task or are there better or simpler
: ways to accomplish this task.  All suggestions will be appreciated!  Feel free
: to post or e-mail any responses.

Well, I would use a Logical or A1 field instead. Just mark the ones you
want to print, then print only those, and those printed will be UNmarked.
This way you don't have to mess with the timestamp if you want to reprint
something.

--
=========================================================================
Kasey K. S. Chang (a guy)             | Paradox for Windows Programmer

URL> http://userwww.sfsu.edu/~kschang | X-COM Guru   General PC expert
--------------------------------------+----------------------------------
Editor of XCOM and XCOM2 UN-official Strategy Guide -- FREE!  (See URL)