entry for report

G

Guest

I have a report that will be printed out monthly. I would like it so that
when the you open the report, it prompts the individual to enter his name and
the date that he/she would like printed on the report. How can I do this?
 
G

Guest

In the Report RecordSource you can create a filter that will prompt the user
to insert the parameters

Select * From TableName Where [NameField] = [Please select a name] And
[DateFieldName] = [Please select a date]

When the report will be open the user will be prompt with two messages:
1. [Please select a name]
2. [Please select a date]
 
F

fredg

I have a report that will be printed out monthly. I would like it so that
when the you open the report, it prompts the individual to enter his name and
the date that he/she would like printed on the report. How can I do this?

Just printed on the report, not filtering the report?
Add an unbound control to the report header/footer.
Set it's control source to:

=[What Name to show?] & " - " & [What Date?]
 
G

Guest

I did as you asked, but when I run the chart, it does not ask for any input
and then just gives the result "#Name?" on the chart. This chart is
actually running from a "QUERY". Doe this effect what I am trying to do or
am I missing something else? Please let me know.

fredg said:
I have a report that will be printed out monthly. I would like it so that
when the you open the report, it prompts the individual to enter his name and
the date that he/she would like printed on the report. How can I do this?

Just printed on the report, not filtering the report?
Add an unbound control to the report header/footer.
Set it's control source to:

=[What Name to show?] & " - " & [What Date?]
 
F

fredg

I did as you asked, but when I run the chart, it does not ask for any input
and then just gives the result "#Name?" on the chart. This chart is
actually running from a "QUERY". Doe this effect what I am trying to do or
am I missing something else? Please let me know.

fredg said:
I have a report that will be printed out monthly. I would like it so that
when the you open the report, it prompts the individual to enter his name and
the date that he/she would like printed on the report. How can I do this?

Just printed on the report, not filtering the report?
Add an unbound control to the report header/footer.
Set it's control source to:

=[What Name to show?] & " - " & [What Date?]
What chart?
May I ask where in your original question does it mention Chart?

You asked a specific question ... How to be asked for, and print, a
user entered name and date on the report.
You received a specific answer that works.
I even qualified my reply "Just printed on the report, not filtering
the report?"

Please ask, in a new thread, a new question, this time giving all the
necessary information. I don't like to guess.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top