Print a form

Hi,

How can I print a form with flexible data on a printer selected by the user?

Thens

What does flexible data mean?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kris" <Kris@discussions.microsoft.com> wrote in message
news:6E084654-FCA9-4475-B1E9-F539D74A5666@microsoft.com...
> Hi,
>
> How can I print a form with flexible data on a printer selected by the
user?
>
> Thens

Do u mean print certain data i.e. say u have dat in cells A1:B10, but u only want to print say cells A3: B4.. ?? Is that wot u mean by flexible data..??

Bob,

The form will be filled automatically with dropdownboxes en labels heving a
different value.
By changing a dropdownbox, the value of different labels will change.
I want a print out of one such version.



"Bob Phillips" wrote:

> What does flexible data mean?
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Kris" <Kris@discussions.microsoft.com> wrote in message
> news:6E084654-FCA9-4475-B1E9-F539D74A5666@microsoft.com...
> > Hi,
> >
> > How can I print a form with flexible data on a printer selected by the
> user?
> >
> > Thens
>
>
>

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Christophero" <Christophero@discussions.microsoft.com> wrote in message
news:F62C8452-4F44-48B0-B103-4D41AA08B4DD@microsoft.com...
> Bob,
>
> The form will be filled automatically with dropdownboxes en labels heving
a
> different value.
> By changing a dropdownbox, the value of different labels will change.
> I want a print out of one such version.
>
>
>
> "Bob Phillips" wrote:
>
> > What does flexible data mean?
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Kris" <Kris@discussions.microsoft.com> wrote in message
> > news:6E084654-FCA9-4475-B1E9-F539D74A5666@microsoft.com...
> > > Hi,
> > >
> > > How can I print a form with flexible data on a printer selected by the
> > user?
> > >
> > > Thens
> >
> >
> >

You could add a Print button, and add this code

Private Sub cmdPrint_Click()
Dim fOK As Boolean
Dim sPrinter As String


With Application
sPrinter = .ActivePrinter
fOK = .Dialogs(xlDialogPrint).Show
End With

If fOK Then
Me.PrintForm
Application.ActivePrinter = sPrinter
End If
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Christophero" <Christophero@discussions.microsoft.com> wrote in message
news:F62C8452-4F44-48B0-B103-4D41AA08B4DD@microsoft.com...
> Bob,
>
> The form will be filled automatically with dropdownboxes en labels heving
a
> different value.
> By changing a dropdownbox, the value of different labels will change.
> I want a print out of one such version.
>
>
>
> "Bob Phillips" wrote:
>
> > What does flexible data mean?
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Kris" <Kris@discussions.microsoft.com> wrote in message
> > news:6E084654-FCA9-4475-B1E9-F539D74A5666@microsoft.com...
> > > Hi,
> > >
> > > How can I print a form with flexible data on a printer selected by the
> > user?
> > >
> > > Thens
> >
> >
> >