Resolved Questions

Kinlene

Two Datamatrix Barcodes in MS Access 2010 on a single report when occasionally one of the fields may be Null?

Tagged With:-

To whom it may concern;

I am installing an MS Access Native Generator with the Datamatrix barcode onto an existing database that was created with MS Office 2010. It is working well with single barcodes and I can get it to print with two separate barcodes matching two different fields. The trouble I am having is when one of the fields is null in the database. I need it to print the report and produce a barcode even if one of the database fields is null. I have read the and attempted to complete an If/then/Else statement in VBA, however, this results in both barcodes failing. I am sure it is something I am missing in the If/Then/Else statement (See Below) Any assistance you can provide will be greatly appreciated.

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
If Len(Text58) > 0 Then
result= IDAutomation_NatG_Datamatrix (Text58, Me)
ElseIf Len (Text60) >0 Then
result= ID Automation_NatG_Datamatrix (Text60, Me)
Else
result= "
Exit Sub
End If
End Sub

Thanks,

Eddie

Operating System: Windows 7 (Govt Version)

Application: MS Office 2010

10-07-15 9 year(s) ago

Report Abuse


Ben	Best Answer The code in the Native Generator for Access works in another example that I tested. However, I could not quite produce issues with your database. However, there are some errors but I do not believe the errors are specifically related to the code. Posted 9 year(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet. Be the first to comment.

Other Answers (1)

Ben	Are you receiving an error message? If so, what is it? Posted 9 year(s) ago (0) (0) Report Abuse

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption	:
Link URL	:	(Must starts with "http://")
Add \| Cancel

Allow to insert an image. Must be among the following file types - .jpg, .gif, .png & .bmp.
Image Url	:	Upload New (Image url must always starts with " http:// ")
Width	:	pixels (Must not be greater than 450px. Enter 0px for no resize)
Add \| Cancel

Allow to insert YouTube video. Insert the video embed code.
Embed Code	:
Add \| Cancel

Up to 5000 Characters are allowed. Current Count: 0

Your comment on this answer

Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption	:
Link URL	:	(Must start with "http://" or "https://")
Add \| Cancel

Allow to insert an image. Must be among the following file types - .jpg, .gif, .png & .bmp.
Image Url	:	Upload New (Image url must always start with "http://" or "https://")
Width	:	pixels (Must not be greater than 450px. Enter 0px for no resize)
Add \| Cancel

Allow to insert YouTube video. Insert the video embed code.
Embed Code	:
Add \| Cancel

Up to 5000 characters are allowed. Current Count: 0

My Profile

You may answer and comment on any thread according to the Terms and Conditions.