Bar Code Functionality within Access

I'm in the process of developing an Access Application that will create legal documentation and am looking to have a bar code appear on the documents.  Any suggestions as to the best way to do this?  Does word or access have the capability of producing a barcode?
heseltonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

simonbennettCommented:
Simple - use a Barcode font (like code 39 etc etc)

Try at

www.fontsnthings.com

(sorry, my proxy forbids me from finding the font for you)

For a TType barcode font.

To print the barcode, simply create a field on a report pointing to the relevant key/number and select the barcode font. You can use a seial barcode hand held scanner to read the codes back in - they will appear as a string 'file' through the com port.

Let me know if you need more help

Simon
0
KostaCommented:
There are also an ActiveX controls for barcodes. I had checked one from marble.com. Fonts have some limitations, for example you can not control the length, spetially if you have to code a variable lenght strings. ActiveXes also have many drawbacks. I personally, after several monthes of dealing with fonts and ActiveXes, decided to write a program drawing barcodes by only Access's tools. The main principle is using a Line method on a report. I did a function for code128, it is compact (I mean code128 standard, not a function is compact) and codes small and capital letters and even some spetial simbols and (of couse) digits. It works unattended for more then 2 years in more than 100 sites.
0
isolomonCommented:
Use a bar code reader that intercepts the keyboard.  There are many, and it avoids all the serial port problems of baud rate, handshake, etc.
Plus you don't have use some 3rd party dll to talk to it.
When you read the barcode it will just appear in the text box as if you typed it.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

tomk120999Commented:
isoloman, that's exactly correct.  As a matter of fact, heselton, those readers also add a CRLF at the end of the string input from the reader.  It's as though the user typed an entry and then pressed the "Enter" key.  In one application, I was able to take advantage of that behavior.  Reading the barcode into a textbox triggered the update event and initiated a lookup for the matching entry in a table.  It worked great and produced a very slick, no-user-intervention interface.

good luck as usual...
0
gavindewCommented:
I'm looking for a barcode font as well. Simon, I went to fontsnthings, but couldn't find any barcode fonts...

Could you help me.

I have found tons, but a $500 to purchase. I am looking for free fonts if these exist...
0
KostaCommented:
gavindew, if you need tham only for Access, I would offer you my function. It has some advantages over fonts, the main is that it gives you possibility to absolutly control over all dimensions of the resulting barcodes.
0
heseltonAuthor Commented:
gavindew:  I would be interested in seeing the function that you developed in Access for the Bar Coding.
0
KostaCommented:
That I have wrote about the function, not gavindew. The text of the function is very large, and it uses a table where the barcodes stored. So I whould like to not post it here. I can send you the whole mdb with instructions. If you don't want to publish your e-mail here write me kosta@ipexsoft.com
0
KostaCommented:
I have sent Heselton the database with the function. If some body else interested in it, please post a separate 200 point question for me (sorry, but I have spent several weeks developing the function and whould like to have some fee (in points)).

Heselton: please provide some feedback, do you succeed whith it?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TrygveCommented:
I have an example database with Code39 and Code128 implemented. It uses the same method as described by Kosta "painting" lines into a control.

5-6 years ago, when I was a rookie, I wrote the 128 code based on a 39 version that I found on the net. I took me no more than two days tops... When we needed the 128 version some time ago, we could not find the old MDB so I searched a bit and found the code included in the example database. It is freely distributable.

Perhaps Kosta has invested more time in making it bulletproof etc. though...
0
KostaCommented:
Trygve, what do you mean "example database"? Where it is freely distributive? I didn't intend to ask for money for it, but you must agree that it is more then explanation of Nz() function (or something like this) and worth 200 point.
0
TrygveCommented:
I have a little database with a table, the code and a report to show the code in action that I have sent to other questioners earlier.

Making the functions from scratch sure is worth more than 200 points, but emailing the example database or copy/paste the code takes less time than even explaining the nz functions and why it is needed :-))

The 128 codes header indicates that the writer did not want money only "credit" so the code is freely distributable.
0
KostaCommented:
Did you receive your points when you "have sent to other questioners earlier"?
0
TrygveCommented:
Of course. It was a direct response to a question ;-)
0
KostaCommented:
So what did you mean by "It is freely distributable"? Did I asked for something more than you vave got for it? <:-(
0
TrygveCommented:
The code is freely distributable, although not written by me. In other words: There are no copyright restrictions on the code, so I have not "stolen" it.

The difference is that in addition to receiving 200 * Grade on this question, you want points for each EE member who also wants to receive the file. You are creating a point-machine, so to speak. Nothing wrong with that...
0
KostaCommented:
OK, guys, Trygve volunteers to work as free mail distributor. :-o
Trygve, no one point-machine able to reach your point level, you have nothing to worry about.
0
TrygveCommented:
0
KostaCommented:
I think I just now have understand. You are just taking revenge for what I have posted into question
http://www.experts-exchange.com/jsp/qShow.jsp?ta=msaccess&qid=10267093 
that no one is perfect.
0
TrygveCommented:
No such thing. We where both wrong on that one, you perhaps even more than me :-))
0
KostaCommented:
Yes, We where both wrong. But I am not the top expert, and you are. I have right to be wrong. And I even consider it an honour to be wrong in same thing with Trygve. And you IMHO, could try to leave more room for beginer experts.
0
TrygveCommented:
heselton: Sorry for using this thread as a debate forum.

Kosta: Even though I am the expert with the most points, I will still enjoy the privilege of being wrong and/or not knowing everything ;-)
"And you IMHO, could try to leave more room for beginer experts." - IMHO the beginer experts have way too much room these days:-)) There are hardly any questions to answer anymore...
0
TrygveCommented:
As the observant readers have noticed, I had a minor "bug" in the link I posted. There is a missing B. The reason for this, believe it or not, is that the B key on my keyboard are not feeling well these days. I am getting kind of tired of having to double check each B I type, so it is probably time to order a new "hand-to-maching-interface" :-))

The correct link is:
http://www.netservice.no/Trygve/WIZ/Downloads/wizBarCodes97.zip
0
JimMorganCommented:
Kosta:  I am a beginner expert.  I joined after you did.  :-)

What if we all held out for big points to share our knowledge?  What do you think would happen to EE?  How many times have you seen me come back AFTER the points were awarded to someone else and still give a viable alternate way to do the same task easier and simpler?

Most of the knowledge that I'm sharing in the Access topic on EE is the results of a concentrated 2+ years - over 6 man-years - of expensive development in creating a commercial Access application.  My partner is always saying "Jim, you're giving away valuable programming and design secrets nearly every time you get on EE.  Why do you do that?"

I feel that Access has gotten the short end on it's value and professionalism.  I called a company today who said that they were leading application developers in Access.  I found that they only had two part-time Access developers and everyone else was Delphi.  This was a come-on to find companies who were using Access so that they could change them to Delphi.  The two part-timers were there just to explain what the customers were trying to do in Access.  The firm would go back and say "This and that can't be done efficiently in Access" or "You are not going to be happy if we do this in Access.  It just isn't fast enough."

If more users were aware of all that Access can do and how well it can to the task, then these 'bait and switch' operators won't continue to get away with this.

So yes, I freely give the information to help make everyone more knowledgable and to help make things more exciting and competitive.

Jim
0
TrygveCommented:
Jim: "concentrated 2+ years - over 6 man-years" Lets see, a normal day at work is 8+ hours. Times 6/2 = 24+ hours a day! (leaving out the weekend) When do you ever sleep :-))

I agree with Jim. There are way to many out there who considers Access a toy based on rumours, old knowledge and/or a bias toward the product they have learned... Lets show them!
0
KostaCommented:
There are many places in the net where people can share knowlage and experience, like numerous newsgroups. The EE is defferent from tham in several aspects. One of the aspects (from expert point of view) is an gaming element, adding a passion by assigning points for right answer. Of couse I am interested in the knowlage share process as is too. I am doing this enough in a real world (I mean not virtual (not net)).
Trygve, Jim, Brewdog, Brian and fiew other experts able to cover the whole range of the EE questioners needs. If you will adress every(!) questions, even those already answered, adding a comment like "I have this information too." or like in case with the Nz(), where Trygve has added detailed explanation (that normal Access programmers should be able to anderstand from help) over my short comment that was a direct and sufficient answer, then other experts that also want to share knowlage, but have not anough time to adress every question too, can not enjoy this site.
This is my point of view. I understand that most of you will not agree. I fill offended. I am giving up. I am leaving this place. At least for a reasonable time.

Dood Bye.
Ex-Kosta.
0
JimMorganCommented:
Kosta:

I apologize if I said anything to offend you.  I was just getting used to you and the way you think.  I won't speak for others but I thought that I was trying to help other experts earn their place in the rankings.

Many times I come in an add some supplemental information not to steal the points but to expand the collaboration that is already started.  When I feel that someone else has earned the points and I'm awarded them because of my writing style, I will give those points (or at least split them if I felt I help further the knowledge) with the other expert.

I don't know what happended in question 10267093, I wasn't involved, but I was joking with you about holding back the barcode knowledge for points.  I didn't mean to offend you.

When we are working with someone we like, we have a tendency to joke around a bit.  Sometimes I have to go back and add extra smileys with Trygve as he always thinks that I'm serious.

Personally I hate newsgroups.  Stay away from them.  You are one of the few people I've met who agrees with my wife - "EE is addictive.  Just like gambleing."  There are challenges and rewards.  I remember when I first started out, I was so uninformed about the point system that I actually bragged to Trygve about getting my first 1000 points.  What a doofuss.  I considered Trygve as the match point that I would challenge.  It seemed I dogged him for weeks - always responding to the same questions but with different answers - Trygve with his code and me with my explanations.

After a while I stopped worry about the points and just enjoyed the intellectual challenge.  Suddenly the points started pouring in.

Brian is another eagar beaver like I was.  I've tried to work with Brian and urge him on to better answers, in my opinion - he might disagree.

I think that Trygve, Brewdog, and I are about ready to become 'Fellows' in the Access topic on EE.  Sure Brewdog wants to catch Trygve and stay ahead of me (and he is doing a darn good job of staying ahead of me) and Trygve wants to get into the top ten.  Me, all I wanted to do was be where I am now.  I want to break 100,000 points.

I don't have enought time to really enjoy this site.  I certainly don't have time to address every question.  I used to at one time but now I get to maybe 1 out of 20.  I'll look at questions that interest me and may make some remarks to get everyone back on the right track, if I think they are off.  I try to pick a few really tough questions each week or two and really work hard on those.  And they could be a 50 pointer or whatever.

The real audience out there is not you or me or the person who asks the question.  It is the other 350,000 members who don't ask questions or respond but are here to enjoy the repartee and soak up knowledge.  The 'lurkers' as I like to call them.  Little by little we lure them in and they may at first make a small comment, then they start asking questions, eventually even answering a few from the knowledge that they have gained.

Have you seen the number of questions that are being asked here everyday?  What are the statistics, Trygve?

So if you haven't left yet, please stick around for a while.  We do need every mind we can get if we want to continue to pry out every little bit of power from Access and let the world know how really great the product is.

I'm sorry.

Jim
0
KostaCommented:
Jim, thank you very much for warm words. I really deeply appreciate this. I am in bad spirits today. Thanks for the support. I will back some time.

Kosta.
0
TrygveCommented:
I will also like for you to stay around, Kosta. I like posting short, working answer myself, but these days every time I see a question that know I can answer, then someone has already posted something that will work. Then since I am already there, I will sometimes add comments explaining the proposed solution or perhaps debating it if there are other possibilities.

I am no longer sure if you think it was wrong of me to post the explanation on the NZ question. I thought I was being nice on that one, hmmm... The reason for posting such "obvious information" is that even though we can understand the help file, many access users will find it as usefull as a road map written in Swahili (and not knowing any Swahili that is ;-)). It often helps to refrase a bit...

If someone else has already posted the same information that we intended to post, then lucky us! We can go work on some other interesting question :-))

Humour is dangerous in the written media and what I believe is a funny remark, might be taken very seriously by someone else. Jim has fooled me more than once, even though I am trying to have an open mind... We try to keep this area a nice, warm and happy place and it would be terrible that you quit your work here because of our behavour: Please stay...
0
KostaCommented:
Thanks, Trygve, Jim. Now I fill that I was just too nervous, capricious, too sensitive and too serious. Soryy that I spent your attention and time on my reassurance. I will probably stick around for a while. Thank, guys, you are real gentelmen. And I just need to visit a psychologist.
0
TrygveCommented:
:-))
0
JimMorganCommented:
Kosta:  Picture me with a smile on my face and tongue firmly planted in cheek as I respond in this topic.

Stop by the Lounge and I'll buy you a relaxer (saves the cost of a trip to the shrink) and if you are REAL nice, I'll even let you have one of my 'happy' pills.

Jim
0
heseltonAuthor Commented:
I appologize for the legnth of time it has taken me to get back to you..but I have just had time to look at what you sent me this past weekend.  Looks great and works great.  i appreciate your help.  Thanks.
0
heseltonAuthor Commented:
Trygve:  I attempted to try your Bar Coding Solution in Access 95 and received the following error....
Expected: End of statment

Then the error highlighted at BarCode128

At
Function MD Barcode128(Ctrl As Control, Rpt As Report)

Any thoughts as to what I would need to do.  Thanks.
0
TrygveCommented:
The MDB is made in Access97 so this may not work very well in Access95.

Try downloading the 2.0 version and try importing this into your 95 database

http://www.netservice.no/Trygve/WIZ/Downloads/wizBarCodes2.zip
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.