Labels

P

Pete

Hi,

I'm having problems with labels.

I want to be able to print a single label but be able to choose what
column and row on the labels sheet to print that label to.

For example if i have used the top two labels i would next like to use
the label in column 1 Row 2.

This is a feature in MS Word but have not yet found away to do this in
access.

Could anyone help or point me in the direction of an example that can
help.

Regards

Pete
 
S

Sacred

Hi,

I also couldnt find out how to do this. I decided to buy some label software
that allows me to "pull" data and information from my databases and print it
in a label. It might be worth looking for some label software if no one can
tell you how to do it.
 
D

Damien McBain

Sacred said:
Hi,

I also couldnt find out how to do this. I decided to buy some label
software that allows me to "pull" data and information from my
databases and print it in a label. It might be worth looking for some
label software if no one can tell you how to do it.
Click to expand...

You can do it with Word AND Access together by using Access as the
datasource and Word as the label maker.

In Word, Tools > Mail Merge, Create (button) Mailing Labels (selection).
Then follow the logical flow and choose your database as the source data. If
you need to filter the data, create a query and use it as the source rather
than a table. You are sure to be able to automate this with VBA in both Word
and Access (I don't know how but it's certain to be possible).

The handy thing about MS Office is not only that each application has its
purpose but that they interface so sweetly together.

Damo
 
F

fredg

Hi,

I'm having problems with labels.

I want to be able to print a single label but be able to choose what
column and row on the labels sheet to print that label to.

For example if i have used the top two labels i would next like to use
the label in column 1 Row 2.

This is a feature in MS Word but have not yet found away to do this in
access.

Could anyone help or point me in the direction of an example that can
help.

Regards

Pete
Click to expand...

First make sure your label report is properly printing a full sheet of
labels.

Then add a Report Header to your label report.
Add 2 text boxes to the Header.
1) Name one SkipControl
Leave it's control source unbound

2) Name the other SkipCounter
Set it control Source to =[Skip How Many?]

Now code the Report Header Format event as below:

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As
Integer)
[SkipControl] = "Skip"
Cancel = True
End Sub
==========

Next code the Detail OnPrint event:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
If PrintCount <= [SkipCounter] And [SkipControl] = "Skip" Then
Me.NextRecord = False
Me.PrintSection = False
Else
[SkipControl] = "No"
Me.PrintSection = True
Me.NextRecord = True
End If

End Sub
=====

When you are ready to run the label report, it will ask how many to
skip.
Then it will run the report.
 
Top