Consulting

Results 1 to 3 of 3

Thread: How hard is it to create a form that does the following?

  1. #1

    How hard is it to create a form that does the following?

    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.

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    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.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    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.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •