Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / March 2008

Tip: Looking for answers? Try searching our database.

Report Free Form Text Box- need help by noon!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
awalker - 07 Mar 2008 14:09 GMT
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).
Signature

Duane Hookom
Microsoft Access MVP

"awalker" wrote:

> 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?
Brendan Reynolds - 07 Mar 2008 15:29 GMT
> Hi,
> Can anyone tell me how to add a text box to the report header/footer that
[quoted text clipped - 20 lines]
>> 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?")

Signature

Brendan Reynolds

Evi - 07 Mar 2008 15:37 GMT
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
[quoted text clipped - 21 lines]
> > recieving a error that states that it is not reconginzed as a valid field
> > name or expression.  How do I get around this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.