Label printing solution

[andyc209]

I need to try and create a simple form that a user enters data into and then hits a print button and the text they entered is printed in a particular way.

i.e. they type in someones name, job and company into 3 fields and then hit a print button and this then prints :

PERSONS NAME​

JOB TITLE​

COMPANY​

We also need the print to be formatted a particular way but that is another issue

This is for a small exhibition we are trying to run and we need something to print visitor badges with

Has anyone got any ideas that can really help as we have been let down by someone who was going to do this for us

 

[DCrake]

Simple Software Solutions

You need to state what type of label printer you are using, If you have one. Anyway if you are using one they usually come with software to print labels. If you are using a normal A4 printer and using address labels this changes things considerabley, especially if you want to print single labels on demand.

CodeMaster:

 

[fearoffours]

Has anyone got any ideas that can really help as we have been let down by someone who was going to do this for us

VERY Briefly this could be accomplished easily in Access by taking the following steps:

• Create a table with the required fields
• Using the wizard, create a form based on the table. You can use this form to enter the data
• Create a new report, select a 'label wizard' and base the report on the table. By going to design view, you will have an extensive amount of control over the format of the label
• Add the code from the microsoft knowledge base for handling labels

Then you would open the form to enter details, and open the report to print things off.
There are a whole variety of things you can do to make this seamless (adding extra forms/buttons to move swiftly from entering data to printing it), which should be quite accomplishable through using the wizards and help within Access.

 

[fearoffours]

Here ya go. I just did what i set out for you in the above post.
You'll learn more if you do it yourself of course, but I needed to check I hadn't mislead you as to how easy it was.
I picked Avery mailing labels J8163 which are 2" x 4". Doubtless you'll need a different size to that! And I added two test entries to show it would/could work.