×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Open barcode software from Access

Open barcode software from Access

Open barcode software from Access

(OP)
Hi all,
I wish to open Barcode software from Access 2000 and print a barcode label from detail data in Access.
I am not familiar with the "shell" of other softare from Access. Any help appreciated.
Thanks

RE: Open barcode software from Access

I think that there is no problem with use of shell.
Shell(pathname[,windowstyle])
You should use full reference for software that is not in the same directory as the Access program.
X = Shell("C:\Program Files\BARONE\Labels.exe", 3)
"3" means "Window is maximized with focus".
If you place software in the same directory as  the Access program.
X = Shell("IR_Read.exe", 1)
"1" means "Window has focus and is restored to its original size and position.".

RE: Open barcode software from Access

(OP)
Hi Andrey22,
I will apply your reply info and thanks for replying
Romnew

RE: Open barcode software from Access

You can also print barcodes from access, I have created several tools activex.  It was easier then using outside programs.

Jason

RE: Open barcode software from Access

(OP)
Thanks again.
Romnew

RE: Open barcode software from Access

(OP)
Hullo Jason,
You suggested that you could send me details of what you did in Access to print barcodes and make it easy.
If at all possible please let me have it.
Thanks
Romnew

RE: Open barcode software from Access

romnew,

If Jason simply sent you the code, how would you or any of the rest of us learn anything?  winky smile

RE: Open barcode software from Access

(OP)
Please Jason, show us how!
Thanks

RE: Open barcode software from Access

Not that is matters, but I have learned 90% of my programming from seeing other peoples code or databases and converting them to my need.  

Why do you thin all the kelp file have examples included.?

I will get the file by EOB.

Thanks
Jason

RE: Open barcode software from Access

Jason,

I have also learned much by converting code from others.  However, in the spirit of Tek-Tips, I've got two issues with people sending each other code like that.

1)  The person receiving it often learns nothing and simply implements the working code.

2)  A person who has the same problem 3 months from now and finds this thread cannot benefit from code sent offline.

Code posted online solves issue #2.  As for issue #1, I'm afraid there's nothing we can do except hope that most people who find the code will use it wisely.

I'm not trying to come down as being harsh on anybody.  Just trying to keep Tek-Tips as useful to everybody as possible.

RE: Open barcode software from Access

I agree with KornGeek...as I have similar problems right now and could also use the info.

RE: Open barcode software from Access

Romnew,
Go to the Grand Zebu site and download fonts and VB code to print barcodes.
http://grandzebu.net/index.php?page=/informatique/codbar-en/codbar.htm
Most of the barcodes are there, with fonts and VB code to encode the barcodes.
I just posted this info in a newer post by boxboxbox. And as I told Amanda, if you use his code don't forget to "Thank" him. He has done the Access/Excel world a great favor.
jim

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close