If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
choose date in report
Hi! I am new with Access. I made a little database and I made report too.
Report use Date from the Table. I like that when I open a Report that I choose a date: for example between 4/22/2005 to 11/15/2005. I made a form where did I put a beginning date and ending date. And now I don't know how to connect this form to the Report. O.K. when I open a Report, first open a new form and it ask me about date but than I don't know how to save the date. Please help me. Thank you. |
#2
|
|||
|
|||
choose date in report
See:
Limiting a Report to a Date Range at: http://allenbrowne.com/casu-08.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "date" wrote in message news Hi! I am new with Access. I made a little database and I made report too. Report use Date from the Table. I like that when I open a Report that I choose a date: for example between 4/22/2005 to 11/15/2005. I made a form where did I put a beginning date and ending date. And now I don't know how to connect this form to the Report. O.K. when I open a Report, first open a new form and it ask me about date but than I don't know how to save the date. Please help me. Thank you. |
#3
|
|||
|
|||
choose date in report
Thank you for you answer but i have a problem still.
I open the report in Design View but i don't know where or how should i set the Control Source. I made report from table datas. Thanks a lot. "Allen Browne" wrote: See: Limiting a Report to a Date Range at: http://allenbrowne.com/casu-08.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "date" wrote in message news Hi! I am new with Access. I made a little database and I made report too. Report use Date from the Table. I like that when I open a Report that I choose a date: for example between 4/22/2005 to 11/15/2005. I made a form where did I put a beginning date and ending date. And now I don't know how to connect this form to the Report. O.K. when I open a Report, first open a new form and it ask me about date but than I don't know how to save the date. Please help me. Thank you. |
#4
|
|||
|
|||
choose date in report
With the report open in deign view, right-click the text box whose Control
Source you want to set. Choose Properties. In the Properites box, on the Data tab, set the Control Source. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "date" wrote in message ... Thank you for you answer but i have a problem still. I open the report in Design View but i don't know where or how should i set the Control Source. I made report from table datas. Thanks a lot. "Allen Browne" wrote: See: Limiting a Report to a Date Range at: http://allenbrowne.com/casu-08.html "date" wrote in message news Hi! I am new with Access. I made a little database and I made report too. Report use Date from the Table. I like that when I open a Report that I choose a date: for example between 4/22/2005 to 11/15/2005. I made a form where did I put a beginning date and ending date. And now I don't know how to connect this form to the Report. O.K. when I open a Report, first open a new form and it ask me about date but than I don't know how to save the date. Please help me. Thank you. |
#5
|
|||
|
|||
choose date in report
Thank you again
I did but when i run i get an run-time error 438: and this line is yellow in the debug window: strWhere = strField & " " & Format(Me.txtStartDate, conDateFormat) "Allen Browne" wrote: With the report open in deign view, right-click the text box whose Control Source you want to set. Choose Properties. In the Properites box, on the Data tab, set the Control Source. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "date" wrote in message ... Thank you for you answer but i have a problem still. I open the report in Design View but i don't know where or how should i set the Control Source. I made report from table datas. Thanks a lot. "Allen Browne" wrote: See: Limiting a Report to a Date Range at: http://allenbrowne.com/casu-08.html "date" wrote in message news Hi! I am new with Access. I made a little database and I made report too. Report use Date from the Table. I like that when I open a Report that I choose a date: for example between 4/22/2005 to 11/15/2005. I made a form where did I put a beginning date and ending date. And now I don't know how to connect this form to the Report. O.K. when I open a Report, first open a new form and it ask me about date but than I don't know how to save the date. Please help me. Thank you. |
#6
|
|||
|
|||
choose date in report
It would appear that your form does not have a text box named txtStartDate.
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "date" wrote in message ... Thank you again I did but when i run i get an run-time error 438: and this line is yellow in the debug window: strWhere = strField & " " & Format(Me.txtStartDate, conDateFormat) "Allen Browne" wrote: With the report open in deign view, right-click the text box whose Control Source you want to set. Choose Properties. In the Properites box, on the Data tab, set the Control Source. "date" wrote in message ... Thank you for you answer but i have a problem still. I open the report in Design View but i don't know where or how should i set the Control Source. I made report from table datas. Thanks a lot. "Allen Browne" wrote: See: Limiting a Report to a Date Range at: http://allenbrowne.com/casu-08.html "date" wrote in message news Hi! I am new with Access. I made a little database and I made report too. Report use Date from the Table. I like that when I open a Report that I choose a date: for example between 4/22/2005 to 11/15/2005. I made a form where did I put a beginning date and ending date. And now I don't know how to connect this form to the Report. O.K. when I open a Report, first open a new form and it ask me about date but than I don't know how to save the date. Please help me. Thank you. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy Cat Ain't Working | shep | Setting Up & Running Reports | 15 | September 12th, 2005 05:14 PM |
Reports with Date Range - Errors | jwr | Setting Up & Running Reports | 12 | August 8th, 2005 12:57 PM |
Has anyone seen this behaviour? What might it be? | tw | General Discussion | 4 | June 30th, 2005 03:23 PM |
Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |