Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Open barcode software from Access
- Thread starter romnew
- Start date
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.".
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.".
- Thread starter
- #3
- Thread starter
- #5
- Thread starter
- #6
- Thread starter
- #8
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.
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.
67peshawar294
Technical User
Romnew,
Go to the Grand Zebu site and download fonts and VB code to print barcodes.
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
Go to the Grand Zebu site and download fonts and VB code to print barcodes.
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
- Status
Similar threads