Report Free Form Text Box- need help by noon!

[awalker]

Hi,
Can anyone tell me how to add a text box to the report header/footer that
would prompt the person running the report to enter their name or the ending
date of the report, etc. I'm on a deadline for today at noon and am starting
to get worried.
I posted the below yesterday the only option of specifing the data is
numbers and I don't always need to use a date. I searched google and only
came up with defining types in queries. This is not from a query, it is for
a free form field in the report header or footer.
This question gets asked a lot. You need to specify the data types of the
parameters. If you can't figure this out, GOOGLE is your friend (or come back
here).

 

[Brendan Reynolds]

Hi,
Can anyone tell me how to add a text box to the report header/footer that
would prompt the person running the report to enter their name or the
ending
date of the report, etc. I'm on a deadline for today at noon and am
starting
to get worried.
I posted the below yesterday the only option of specifing the data is
numbers and I don't always need to use a date. I searched google and only
came up with defining types in queries. This is not from a query, it is
for
a free form field in the report header or footer.
This question gets asked a lot. You need to specify the data types of the
parameters. If you can't figure this out, GOOGLE is your friend (or come
back
here).
--
Duane Hookom
Microsoft Access MVP

Hi,
I have a report that pulls from a cross tab that comes from a make table
querey. In the report I need the ability to have a text box where the
agent
can enter certain data when promoted. For example =[Enter End Date] or
=[Enter Reporter Name] However, when I enter this into a text box I am
recieving a error that states that it is not reconginzed as a valid field
name or expression. How do I get around this?

This is a quick-and-dirty solution, and probably not how I'd do it in a
production app, but you did say you were in a hurry. You can set the
ControlSource property of the text box to an expression that uses the
InputBox function to prompt the user for the text. Something like ....

=InputBox("What do you want in the header?")

 

[Evi]

There's something that doesn't make sense here.
I can't find your previous posts so sorry if this doesn't help.

Put a text box into the place where you require it. Click on Text Box on the
Tool Box toolbar. *Don't just use an existing Control that might be linked
to a field*. Give your text box a name that ISN'T the name of one of the
fields in your report.

In the text box type your question after an = and between box brackets

=[What is your name]

When the user fills this in, his name will appear in the report.

If you don't want the report to open unless the user fills in his name, then
you will put code into the Report's OnOpen event

It will say

If IsNull([YourTextBoxName]) Then
'substitute the real name of your text box
DoCmd.Close
End If

Note that all this does is put a name into a box, it doesn't filter the
report, but you didn't ask for that.


Evi

Hi,
Can anyone tell me how to add a text box to the report header/footer that
would prompt the person running the report to enter their name or the ending
date of the report, etc. I'm on a deadline for today at noon and am starting
to get worried.
I posted the below yesterday the only option of specifing the data is
numbers and I don't always need to use a date. I searched google and only
came up with defining types in queries. This is not from a query, it is for
a free form field in the report header or footer.
This question gets asked a lot. You need to specify the data types of the
parameters. If you can't figure this out, GOOGLE is your friend (or come back
here).
--
Duane Hookom
Microsoft Access MVP

Hi,
I have a report that pulls from a cross tab that comes from a make table
querey. In the report I need the ability to have a text box where the agent
can enter certain data when promoted. For example =[Enter End Date] or
=[Enter Reporter Name] However, when I enter this into a text box I am
recieving a error that states that it is not reconginzed as a valid field
name or expression. How do I get around this?