 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006Date value needed for Access report
I have an Access 2003 report that needs to request a date value from the user whenever it is opened. This date value does not have to be saved in the database, but it does need to display in the report. Any help would be greatly appreciated. Thanks. What do you plan on doing with the date value? You can add a text box to your report with a control source like: =[Enter a date value]  SignatureDuane Hookom MS Access MVP -- >I have an Access 2003 report that needs to request a date value from > the user whenever it is opened. This date value does not have to be > saved in the database, but it does need to display in the report. > > Any help would be greatly appreciated. Thanks. Thanks Duane - I tried this and I keep getting #Error on the report. There must be something simple I'm missing? The only thing I need to do with the date value is display it on the report (no calculations are done with this date value). Thanks for your help. Regards Phil Horwood > What do you plan on doing with the date value? You can add a text box to > your report with a control source like: [quoted text clipped - 10 lines] > > > > Any help would be greatly appreciated. Thanks. Does your report have a record source that returns any records? SignatureDuane Hookom MS Access MVP -- > Thanks Duane - I tried this and I keep getting #Error on the report. > There must be something simple I'm missing? [quoted text clipped - 20 lines] >> > >> > Any help would be greatly appreciated. Thanks. Yes, the report's Record Source is a query. > Does your report have a record source that returns any records? > [quoted text clipped - 27 lines] > >> > > >> > Any help would be greatly appreciated. Thanks. Did you make sure the Name of the text box is not also the name of a field or parameter? SignatureDuane Hookom MS Access MVP -- > Yes, the report's Record Source is a query. > [quoted text clipped - 30 lines] >> >> > >> >> > Any help would be greatly appreciated. Thanks. |
Reply to this Message |
 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.