Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

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

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Approach 98 Label Print from One Record

dalwell (IS/IT--Management)
19 Aug 07 15:52
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?
suesloan (TechnicalUser)
27 Aug 07 10:36
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
dalwell (IS/IT--Management)
3 Sep 07 12:07
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
suesloan (TechnicalUser)
7 Sep 07 9:01
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
dalwell (IS/IT--Management)
24 Nov 07 17:38
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.
suesloan (TechnicalUser)
29 Nov 07 12:50
I am not accepting new projects currently. Perhaps next year!

Sue Sloan
dalwell (IS/IT--Management)
9 Jan 08 10:38
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.

http://www.box.net/shared/static/s9bmbjzswg.APR
http://www.box.net/shared/static/qo2muwvwg8.ADX
http://www.box.net/shared/static/mnpks2s00w.dbf
suesloan (TechnicalUser)
13 Jan 08 15:41
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

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!

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