473,324 Members | 2,531 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Bar coding a report.

52
Hi

Does anyone know anything about using barcodes in reports??

I have the correct font, and I am using:
Expand|Select|Wrap|Line Numbers
  1. ="*"+Trim([intKeyHere])+"*"
in the control source for the field.

The barcode produced doesn't seem to scan though.

I know that FoxPro uses:
Expand|Select|Wrap|Line Numbers
  1. ="*"+AllTrim(int_Key_Here)+"*"
and this seems to work for our FoxPro based DB.

Any thoughts appreciated.

Using Access 2007 on XpOS.
Mar 30 '09 #1
3 1424
Stewart Ross
2,545 Expert Mod 2GB
Hi Chinde. I use a free 3-of-9 font. I have never found a problem reading the bar codes it produces at any reasonable size - but it is set up to be much larger than the normal 10 or 12 point text which might be used for textbox characters. I set mine up to print the bar code at around 1-1.5cm in height using a point size of around 26 points, if my memory is correct.

I would suggest that you run a number of print trials from Word initially (as you can set up different bar code sizes so easily on a Word page) and check which ones are and are not readable.

If none can be read it suggests that the bar code font you are using is not compatible with your particular reader, or perhaps with what you are outputting (some will only output numeric characters, others alphabetic text and numerics but no other characters).

There are many different types of bar code and many different fonts available. Some bar code fonts are better than others. If you are using one of the free ones these tend to be somewhat restricted in their uses compared to paid-for fonts (though the one I'm using does what I need OK).

Good luck in your checks on this one.

-Stewart

ps make sure that you do indeed need the start and stop characters and that they are asterisks (which is indeed the case with the one I use). I note you use the "+" operator to concatenate the value you are trimming - it won't make any difference to your current problem, but for strings in VBA use the ampersand for concatenation instead
(eg "*" & Trim(...) & "*").
Mar 30 '09 #2
Chinde
52
I guess I should have said that I have already run the tests you suggested via word and I'm using 3of9 too. it must be an issue between the reader and the bar code. Although the reader will read anything produced by our stock control system which also uses 3of9 but with the slight code alterations which I showed before.

I'll continue to experiment with the reader and my bar codes.

I wondered if it might be my usage of the Trim function?? is there any difference between Trim() and Trim$()?? and when you produce the bar codes do you use the *'s before and after??

All codes are (at present) just number based.
Mar 30 '09 #3
Chinde
52
ok all sorted. It was the font size and word was placing paragraph markers at the end of the bar code. I ran the same codes through a report at a selection of sizes and the 26pt's worked a treat with the
Expand|Select|Wrap|Line Numbers
  1. ="*" + Trim(Number) + "*"
Thanks again.
Mar 30 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

13
by: Sara | last post by:
I have a query that pulls data for the month, using the Month End Date from a form (user enters) as criteria. It works. I want to use the same query to pull "month to date" data, on a weekly...
1
by: dappy | last post by:
<cr:CrystalReportViewer id=CrystalReportViewer2 style="Z-INDEX: 101; LEFT: 200px; POSITION: absolute; TOP: 184px" runat="server" Width="1030px" Height="1073px" ReportSource='<%#...
2
by: Rabbit | last post by:
I like the feature of "Publish Web Site", because it can deploy a compiled version of my web solution. But currently I need to deploy Crystal report onto IIS with only .Net 2.0, so I'm trying to...
7
by: Mark | last post by:
Hi, I am creating application in VB 2005. and when I print report it adds extra 0.45 cm margin on left and top, and the reason for this is physical margins of printer. Is it possible to change...
3
by: juliehg | last post by:
Hi, I'm currently using MS Access 2000 to keep all my actors measurements, resumes and personal details on a database. To upload their details onto our website, I have built an event so when I...
4
by: Peter Herath | last post by:
I need to create an access report uisng VBA code. i want to be able to create a report name and save it and also create labels and text boxes in the report using the vba code and those fields should...
0
by: PerumalSamy | last post by:
Hi all, i am new to asp.net platform. I am using vb.net coding in asp.net. could you tell me how to generate crystal report in asp.net and to access in webpage and converting into pdf
2
by: dowannafly | last post by:
I am new to Visual Basis. I want to create report for my application using Crystl Report. I don't know anything about Crystl Report. Please guide me
2
by: Shrividya | last post by:
Hello, How to set Database Path(Access) for Crystal Report XI by coding in VB. I am setting the path during Crystal Report Design but if i install the software on client's PC the path is...
2
by: paul01420 | last post by:
This is from an Access report designed to sort donors based on their node assignments within our campaign structure and add up total donations for each node. Ex. –all donors who have given through...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.