Barcode location

  • Thread starter Thread starter koobelek
  • Start date Start date
K

koobelek

I need to create a report containing barcodes. The barcodes should be
displayed in different location on the report depending on the value of
the current record. For example if the current record value is FA01R1
(F = front, A = tray A number 01, R1 = 1st right position; max. 2 right
positions, and so on) the barcode should be displayed in the upper-top
corner of the report (landscape view). This would look like some sort
of a map. Has anybody ever worked on something similar?

Regards,
Koobel
 
When you print a report in Access, an "OnFormat" event is fired each
time the detail section of the report updated with data from each data
record that the report is based on. This event allows you to modify
the report using VBA code while the report is being printed.
If you were to use a bar code ActiveX control in your reports to
generate the bar codes and then add code to the OnFormat event handler
for the report, you could examine the message being encoded in the bar
code and modify the "Left" and "Top" properties of the ActiveX control
based on the data being encoded in the bar code.
If you decide to use a bar code ActiveX control to generate the bar
codes, I would recommend the TAL Bar Code ActiveX control. It is the
best bar code tool that I know of for Microsoft Access.
For more information on the TAL Bar Code ActiveX control, please
visit:
http://www.taltech.com/products/activex_barcodes.html
The tech support department at TAL Technologies should be able to
provide you with some sample code to demonstrate the technique of
moving the control in the OnFormat event handler for the report based
 
Back
Top