 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2007how can ms access ask me for a date range when i run a report
I want access to display some prompt when the report begins asking for the date range, then have that date range be formated to read on the report heading someting like 'Report Range: 1/1/2007 Thruough 1/31/2007" thanks Create a form. Add "Start Date" and "End Date" controls. Modify your query(ies) and report(s) to point to the form's controls for the values.  SignatureRegards Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ > I want access to display some prompt when the report begins asking for the > date range, then have that date range be formated to read on the report > heading someting like 'Report Range: 1/1/2007 Thruough 1/31/2007" > thanks Hate to be a dolt.. But I don't know how to create a form that is not connected already to a table or query; create enter start date and enter end date controls and then have my query or report "point to" such a form. SignatureThanks > Create a form. Add "Start Date" and "End Date" controls. > [quoted text clipped - 5 lines] > > heading someting like 'Report Range: 1/1/2007 Thruough 1/31/2007" > > thanks > Hate to be a dolt.. > > But I don't know how to create a form that is not connected already > to a table or query; create enter start date and enter end date > controls and then have my query or report "point to" such a form. On the forms tab of the db window press the "New" button. In the dialog that comes up choose "Design View" and leave the table/query option empty. You now have an unbound form. Drag a couple of TextBoxes onto it from the Toolbox bar and name one "StartDate" and the other "EndDate" Save the form and give it whatever name you like. Your queries can now refer to those controls whenever the form is opened with syntax like... Forms!NameOfForm!StartDate Forms!NameOfForm!EndDate SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Look up parameter queries in Access help. I've used these successfully for a long time. > I want access to display some prompt when the report begins asking for the > date range, then have that date range be formated to read on the report > heading someting like 'Report Range: 1/1/2007 Thruough 1/31/2007" > 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.