Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Approach 98 Label Print from One Record

Approach 98 Label Print from One Record

Approach 98 Label Print from One Record

I have a large database and some in-experienced typists.  I am trying to make it easier for them to print a sheet of labels from one record of the database.
Typists type the address information into my form.  Then before they print labels for only that one record they have to "DO a FIND" that record only to print a sheet of labels for just that one record.  

How can I print a sheet of labels for only the record just entered?  (Not the whole database).

By the way, will Approach 97 automatically print labels for each new record as it is entered?

RE: Approach 98 Label Print from One Record

Give them a macro (and a button) that automatically does the FIND for the user and switches to the label view. You could even set up the PRINT command to pop up with the number of labels pre-set.

Sue Sloan

RE: Approach 98 Label Print from One Record

Sue, is this something you can walk me thru or do I need to take a class on Macros?  I have never written a macro before but this sounds like it would work for me

RE: Approach 98 Label Print from One Record

A macro is simply a series of commands with a name. The macro name can be attached to a button using the properties dialog for the button. The macro would consist of only a few commands, but there is some preparation required for this one.

1) Go to Field Definition and create a new field named VarID of type "variable" and of the same data type as your database's unique record ID (assuming you have one!)

2) In design mode on a view of the database (worksheet or form) add the VarID field and then put a valid value for a record into it. Also make sure the ID field for your database is on that view.

3) Make sure the Action Bar is visible (the one with the big buttons for Browse, Design, New record, Find).

4) In browse mode, do a FIND using the button on the Action bar, In the ID field enter the following: =@VarID

5) Then click the OK button on the action bar. You will see <Current Find/Sort> in the field on that bar. Type over that text with this: "Find Unique ID" and press Enter.

6) Save your Approach file.

7) You can now open the macro editor using the Edit menu. Create a new macro and name it "Find ID for Label".

8) Enter the following commands:
SET VarID to the database's ID field
VIEW switch to the form you did the FIND on.
FIND using named find "Find Unique ID".
VIEW switch to your label view
PRINT set up the print options here

It sounds more complicated than it really is.

Sue Sloan

RE: Approach 98 Label Print from One Record

Can you help me more with this problem?  I tried to enter the Macro just as you said but it still is not working correclty.  Is there some way I can send you my database soyou can look at it for me?  Thanks for your help.

RE: Approach 98 Label Print from One Record

I am not accepting new projects currently. Perhaps next year!

Sue Sloan

RE: Approach 98 Label Print from One Record

I am still trying to solve this problem that I have been working on for several months.  I can't get it to print a sheet of labels for only one record.  Can you help by looking at my file?  I have attached my database so you can see how I set up the macro.  I think I set up the macro like you said but still can't get it to find only that one record and print it.  I had a print button on the screen but when I pressed it; it would print everything in the database and not only the one record of the find.  Please help.


RE: Approach 98 Label Print from One Record

You have it all set up correctly. When you run your macro, it prints the one label and then switches to a browse view of all records.

All you need to do is set the Number of Copies in your macro PRINT command to the number of labels you want to print for the one record. It will then print the page and again show you the browse view of all records.

Sue Sloan

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close