Using in MS Access

 

 

This example illustrates how to use BarCodeWiz ActiveX Control in Microsoft Access Reports.

 

We will use an already existing inventory table (Table1) for bar code data.

Access2000-Table1

 

Double click on Create report in Design view.

Access2000-CreateReport

 

To insert BarCodeWiz into Microsoft Access, go to Insert->ActiveX Control ...

Select BarCodeWiz Class, and click OK.

Access2000-InsertControl

 

BarCodeWiz component will appear in the Detail section of your report design page.

Double-click on the square in the upper left part of the report window in order to show the properties window.

Access2000-ShowProperties

 

Select the Data tab and choose the table (Record Source) to use in our report. In our case, there is only one table - Table1

Access2000-SelectTable

 

Click on BarCodeWiz ActiveX to bring up its properties.

From the properties window select the data column from your table for the Control Source. In our case, the bar code information is stored in the Barcode field of the table.

Access2000-SelectControlSou

 

If you wish to show other data-bound information on your report page, simply drag the item and drop it onto the report page. In the example below, we are adding ItemName under the bar code image.

Access2000-InsertOther

 

That's all there is to it! Click on Print Preview or Print to see your generated report.

Access2000-GeneratedReport