Print out invoices which are new

[rickyfong]

In my invoicing system, after front-end user creating new records. After the supervior review, those new records have to be printed out to send to customer. I just wondering which way is the best approach to deal with this.

For me to say, I will create a so called printnewrecord list for those newly created record. For instance, if the database got 124 records, the newly created records are 121, 122, 123 and 124. In that printnewrecords, it will hold those invocing number when they were being created. Then, when the user wanted to print out newly records, the program when located amoung the 124 records comparing with the invoicing number from the list and print them out. In case, some record needs to be re-print. User simply selected the invoicing number from selection box and then can be re-printed that particular record.

Just want to know is that 2 selection boxes, one from and one to also can achieve the same approach I mentioned before? Or please suggest other apprach which is the best practice for such kind of range printing! Thanks a lot!!

 

[rickyfong]

Anybody?? Thanks!!

 

[rickyfong]

Nobody!!??

 

[vbaInet]

Your first question should be how to determine newly created records. For this you need a DATE/TIME field with its Default Value property set to Now(). From that field you will be able to determine new records. But what are new records in your case? Records created today? If that's the case you can use Date().

Now, the criteria for your query will be where that field is = Date()

 

[rickyfong]

In practice, the situation is a little bit complicated. Cause, some transactions have to be printed out immediately. As such, how about to put a flag in the record to indicate whether the transaction has been printed out. And then a query to filter out for those transsactions that still have not been printed. Any idea?? Thanks!!

 

[vbaInet]

In a multi user environment it wouldn't work.

 

[rickyfong]

WHy in multi user environment, the simple query like this type won't work?? Then, is there any approach that can overcome this problem!!?? Thanks!!

 

[vbaInet]

As already mentioned, just use a date field. That should work much better. You will clear the field of data when it's no longer a new transaction. Why a date field would work better is because it ensures that all new transactions correspond to today.