Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 30th, 2006, 01:51 AM
Authorized User
Join Date: Nov 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default Barcode Image Control


I am designing a report it will show the monthly statement for a customer, the spec's are:

1- On Each Page of the statement report the client wants to implement the barcode vertically to the left of each page.

2- The barcode is string of concatenated data contains: user type, userID, statement No, Page Number

3- the Barcode is going to be an image on the statement

The Problem is Access does not allow the content of image control in a page to be modified before formatting the page or the section in the report.

I have created a VBA program obtain all the data in the barcode string but the problem appears with obtaining the Page No and attached to the barcode, even I have managed to obtain Page No programmatically ... but I still can not change the image control to get the barcode for each page before Access formats it.

If any body has a Solution please Help


Old October 31st, 2006, 08:56 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

Isn't the bar code a Font, and not an image?

In any event, if this is on a report, you need to get the image during the Detail section's On Format event. Then what I would do is set the image visible property to false, and substitute a new image with your data, like

Me.OldImage.Visible = False
Me.NewImage = Me.OldImage & page number?

Did that work?

Old October 31st, 2006, 07:00 PM
Authorized User
Join Date: Nov 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts


Thanks for your reply.

Yes the bar code is a font stored as an image and inserted vertically to the left of each page of the statement, the problem that access can't produce the page no till the formating been done.
and inserting the barcode as a text control on the report will not be positioned correctly, that inthe middle of left hand side of each page, so I had to picture property.

I have used on format, on page, and on retreat events but it did not work, I am still trying.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Loading Image to Image Control using JavaScript ctranjith General .NET 1 May 28th, 2013 05:43 AM
Problem with Image Control...!!!!!!!!!!! kaushalparik ASP.NET 2.0 Professional 9 April 18th, 2007 03:03 AM
How to get the id of an image control jasdeephere ASP.NET 1.0 and 1.1 Professional 3 January 30th, 2007 09:06 AM
image control paulevision Dreamweaver (all versions) 0 November 18th, 2004 05:45 PM
Image Control edcaru Access 3 June 22nd, 2004 06:41 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.