Welcome, Guest. Please Login.
05/20/25 at 04:18:41
News:
Home Help Search Login


Pages: 1
Send Topic Print
Job Labels (Read 955 times)
DELTA
Browser
*


I love YaBB 1G -
SP1!

Posts: 27
Job Labels
10/15/04 at 10:30:25
 
I would like to make job labels for prints to go directly into the shop floor. On these labels I need to print so, cust, po,pn,qty,due date. Not sure what types of labels yet (tried avery thinking of getting a small separate printer dynmo) small and the most economic way to go. I spent alot of time on this already. Not familiar with access and how it works,  undecidedwas experiencing with it today. I just don't know how to get info and move it around from one program to the other. Can anyone please help me. Thank you and God bless you! Cheesy
Back to top
 
 
  IP Logged
Cyndee Pappas
Senior Member
****


EVO~ERP 2006.1
02/28/06 update

Posts: 258
Gender: female
Re: Job Labels
Reply #1 - 10/15/04 at 11:10:42
 
All this info prints on the traveler, so you should be able to make a custom RTM and print labels directly from DBA. I would make a copy of the existing RTM with a new name. Then you can go in to the new one and delete everything you don't want to print. Move the rest around to your liking.  
 
BTW, we have a Dymo printer and we love it.
Back to top
 
 

Cyndee Pappas
Industrial Data Systems
EVO~ERP 2006.1 with 02/28/06 update
Client/Server Win2000 Server
Pervasive SQL 2000i

WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Job Labels
Reply #2 - 10/15/04 at 13:24:46
 
See, and I would use Access as it has the labels (if you're going to try to use Avery stock) already defined. In order to use Access you would need to create ODBC links on the server, and on the workstation. Then you create an Access DB (NOT an Access Project in case you are using Access 2003), and you link to the files containing the information you want. Then you create a query with parameters so that it will prompt for a range of WO's to be printed for, then go to the forms section choose labels and choose the one you want, put your fields from the query on the form  and away you go.  
 
And then you always have the option to add more fields later on if you want from whatever files you need. You can even link to other software (ie. UPS Worldship-which uses an Access DB, by the way) and draw in information from there if you need.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: Job Labels
Reply #3 - 10/16/04 at 09:34:35
 
Lorne,
I would use the Traveler simply because I am totally deficient in Access.  I bought the program and a nice thick manual.  It holds all my papers down really well!
 
I have a couple of questions:  
I seem to remember a post that indicated a line could be added to DBA drop down menus for reports in other programs.  Would that work in the case of Access or is there a better way to manage reports?
 
I had a difficult time when trying to do ODBC with excel.  I finally made a connection although I don't think it was the right way.  The long & short of it is, I had to reselect stuff in DBA each time.  How does the setup differ in excel & access?
 
Thanks for any light you shed.
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Job Labels
Reply #4 - 10/16/04 at 09:56:38
 
In TAS 6 Evo, you can easily add lines to menus to call other applications.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Job Labels
Reply #5 - 10/16/04 at 20:45:23
 
Karen,
 
ODBC does not differ regardless of WHAT program you are using with it.
 
And if it is returning data from the DBA files then you must have it set up correctly.....ODBC is one of those things that is either right and it works....or wrong and it doesn't....LOL!
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
sharon krewson
Ex Member



Re: Job Labels
Reply #6 - 10/18/04 at 08:34:49
 
Hmmmmm.....  Could this scenario be used for setting up Access to print labels at receiving?
Back to top
 
 
  IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Job Labels
Reply #7 - 10/18/04 at 09:52:44
 
Absolutely. Although to do it for receiving, therfe is an additional consideration that MAY be involved, depending on just what you want to use the labels FOR and what info you want on them. There might be a requirement to have some of the data being local to the Access app rather than simply being a pass-through.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
DELTA
Browser
*


I love YaBB 1G -
SP1!

Posts: 27
Re: Job Labels
Reply #8 - 10/26/04 at 11:58:55
 
THANKS ALL, I'M GOING TO GET THE LITTLE PRINTER HOPE IT ALL WORKS. kiss
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print