ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Job Labels
http://www.istechforum.com/YaBB.pl?num=1097865025

Message started by DELTA on 10/15/04 at 10:30:25

Title: Job Labels
Post by DELTA on 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, :-/was 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! :D

Title: Re: Job Labels
Post by Cyndee Pappas on 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.

Title: Re: Job Labels
Post by aricon on 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.

Title: Re: Job Labels
Post by Karen Mason on 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.

Title: Re: Job Labels
Post by Lynn Pantic on 10/16/04 at 09:56:38

In TAS 6 Evo, you can easily add lines to menus to call other applications.

Title: Re: Job Labels
Post by aricon on 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!

Title: Re: Job Labels
Post by sharon krewson on 10/18/04 at 08:34:49

Hmmmmm..... Could this scenario be used for setting up Access to print labels at receiving?

Title: Re: Job Labels
Post by aricon on 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.

Title: Re: Job Labels
Post by DELTA on 10/26/04 at 11:58:55

THANKS ALL, I'M GOING TO GET THE LITTLE PRINTER HOPE IT ALL WORKS. :-*