PDA

View Full Version : How hard is it to create a form that does the following?



mattneedshel
04-09-2013, 08:11 AM
I need a form, where the user inputs a barcode number and a quantity.

They enter as many as they want, then press a button that creates a .txt file and places the barcode within the text.

So for example -

Printjob.txt
Label:/blahblahblah
SESSIONSTART
Articleprompt = (Barcode input by user)
SESSIONPRINT (Quantity input by user)
SESSIONEND

if the user was to input 2 barcodes, the .txt file would be created as

Printjob.txt
Label:/blahblahblah
SESSIONSTART
Articleprompt = (Barcode input by user)
SESSIONPRINT (Quantity input by user)
Artitleprompt = (Barcode input by user)
SESSIONPRINT (Quantity input by user)
SESSIONEND

The file that has been created from this data is then saved with a .job extension, and automatically opened.

I have very little VBA knowledge so just need to know if this is possible first :) Appreciate the help in advance.

SamT
04-19-2013, 08:22 AM
Matt,

It sounds doable.

You need to know/decide:

What Bar Code Font you're using, If the printer has that Font installed, or should the form send it.

How the user enters the chosen bar code. Options are: Scans an existing bar code; Selects from a list of items maintained on an Excel Sheet.

How to chose the .job file's name.

What program opens the . job file.

Also you should PM a moderator from the list at the bottom of the Project Assistance index page and ask them to move this thread to the best help section of the forum.

SamT
05-26-2013, 10:21 AM
I have very little VBA knowledge so just need to know if this is possible first :) Appreciate the help in advance.
Absolutely possible, even pretty easy.