User Prompt

[FJquestioner]

If I want a report to be limited to a user specified subset of the underlying
query dynaset, how do I prompt the user to input the specific value for a
given field?

Also, every time I try to Publish a report to Word it works fine except all
lines are missing. They show up fine in the acces report preview but never in
Word. Any way to get around that?

Thanks very much.

FJ

 

[Duane Hookom]

You can filter the records in a report in many ways. One of the simplest and
least user-friendly is to simply place a parameter prompt in the criteria
under the "given field" like:
[Enter Department Code]

Lines and many other elements of reports do not make it to the Word
document.

 

[FJquestioner]

Thanks. That worked fine but as you noted, its not particularly user
friendly. Is there a more professional looking way. For example if I wanted
to see a report of invoices fro Jan 1 to March 31, how could I have the user
enter those date parameters?
Thank again.

FJ

You can filter the records in a report in many ways. One of the simplest and
least user-friendly is to simply place a parameter prompt in the criteria
under the "given field" like:
[Enter Department Code]

Lines and many other elements of reports do not make it to the Word
document.


--
Duane Hookom
MS Access MVP

If I want a report to be limited to a user specified subset of the
underlying
query dynaset, how do I prompt the user to input the specific value for a
given field?

Also, every time I try to Publish a report to Word it works fine except
all
lines are missing. They show up fine in the acces report preview but never
in
Word. Any way to get around that?

Thanks very much.

FJ

 

[Duane Hookom]

You add a couple text boxes to a form and name them txtStart and txtEnd.
Then you add code to open your report like:

Dim strWhere as String
strWhere = "1=1 "
If Not Isnull(Me.txtStart) Then
strWhere = strWhere & " And [InvoiceDate]>=#" & _
Me.txtStart & "# "
End If
If Not Isnull(Me.txtEnd) Then
strWhere = strWhere & " And [InvoiceDate]<=#" & _
Me.txtEnd & "# "
End If
DoCmd.OpenReport "rptInvoices", acPreview, , strWhere


--
Duane Hookom
MS Access MVP

Thanks. That worked fine but as you noted, its not particularly user
friendly. Is there a more professional looking way. For example if I
wanted
to see a report of invoices fro Jan 1 to March 31, how could I have the
user
enter those date parameters?
Thank again.

FJ

You can filter the records in a report in many ways. One of the simplest
and
least user-friendly is to simply place a parameter prompt in the criteria
under the "given field" like:
[Enter Department Code]

Lines and many other elements of reports do not make it to the Word
document.


--
Duane Hookom
MS Access MVP

If I want a report to be limited to a user specified subset of the
underlying
query dynaset, how do I prompt the user to input the specific value for
a
given field?

Also, every time I try to Publish a report to Word it works fine except
all
lines are missing. They show up fine in the acces report preview but
never
in
Word. Any way to get around that?

Thanks very much.

FJ