Hello,
I wrote a VBA excel program for tag printing with a thermal printer.
the program will store all the information printed in a spreadsheet called product_all, it will add the data at the end (first empty row).
in the last column, I save on every row, the date and the time when this tag was printed.
example:
code1 data1 data2 data3 12/11/2020 10:20:16
code2 data1 data2 data3 12/11/2020 10:25:30
and so on.
from this report_all, I would like to generate another report based on the date, so when the operator requests a report, he will get a message asking from-to what date, and the report will be generated based on that.
also, if it is possible to have a kind of calendar displayed so he can make a selection instead of typing the date.
the generated report will have the information of the starting and ending dates and times.
it will be also more convenient if in the generated report groups all the items that have the same code (the first column).
example:
production report> from: to:
code1 data1 data2 data3 5
code2 data1 data2 data3 3
and so on.
I wrote a VBA excel program for tag printing with a thermal printer.
the program will store all the information printed in a spreadsheet called product_all, it will add the data at the end (first empty row).
in the last column, I save on every row, the date and the time when this tag was printed.
example:
code1 data1 data2 data3 12/11/2020 10:20:16
code2 data1 data2 data3 12/11/2020 10:25:30
and so on.
from this report_all, I would like to generate another report based on the date, so when the operator requests a report, he will get a message asking from-to what date, and the report will be generated based on that.
also, if it is possible to have a kind of calendar displayed so he can make a selection instead of typing the date.
the generated report will have the information of the starting and ending dates and times.
it will be also more convenient if in the generated report groups all the items that have the same code (the first column).
example:
production report> from: to:
code1 data1 data2 data3 5
code2 data1 data2 data3 3
and so on.