A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Unbound form duties



 
 
Thread Tools Display Modes
  #1  
Old June 27th, 2004, 11:37 PM
René
external usenet poster
 
Posts: n/a
Default Unbound form duties

I have an unbound form that I have set up to give me date parameters for different reports ie I have text boxes with start and end date and command buttons for OK and cancel etc.

We create documentation for several reasons disciplinary, on-site visits etc. These reasons are stored in their own table. How is the best way to generate a report of all disciplinary documentation or supervisory etc from June 1, to July 1

Hopefully that made since. Please keep it simple as I go back to the books to research as necessary but don't always follow

Thanks in advance
  #2  
Old June 28th, 2004, 05:43 AM
Allen Browne
external usenet poster
 
Posts: n/a
Default Unbound form duties

Take a look at this article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

It explains how to set up such a form, and use the WhereCondition of the
OpenReport action to limit the report to a date range.

You can filter on other fields as well by adding to the string for the Where
Condition.

--
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.

"René" wrote in message
...
I have an unbound form that I have set up to give me date parameters for

different reports ie I have text boxes with start and end date and command
buttons for OK and cancel etc.

We create documentation for several reasons disciplinary, on-site visits

etc. These reasons are stored in their own table. How is the best way to
generate a report of all disciplinary documentation or supervisory etc from
June 1, to July 1

Hopefully that made since. Please keep it simple as I go back to the

books to research as necessary but don't always follow

Thanks in advance



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
form doesn't update!!!!! manish Using Forms 4 June 15th, 2004 11:24 AM
Recordset in subform based on field in parent form Lyn General Discussion 15 June 14th, 2004 03:10 PM
Unbound controls on a form Allen Browne General Discussion 1 June 7th, 2004 06:31 PM
adding fields in unbound form Barbe Using Forms 1 May 26th, 2004 07:03 PM
use data entered in unbound controls (on a form) when printing a report Karen New Users 1 May 25th, 2004 08:17 PM


All times are GMT +1. The time now is 11:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.