Create a date 'from' - 'to' on Report

[Jule]

Can anyone tell me how to create a prompt for dates 'from' and 'to' when I open my report that will only bring up data from the date(s) I enter?

In a Query I have, the following works and brings up the correct data:


Between [Enter beginnning date] And [Enter ending date]
But it doesn't work when I put this in the Control Source for an unbound text box on my Report.

What am doing wrong?

Thanks!

Jules

[Jule]

Woohoo! I figured it out!

All I had to do was change the record source in my Report to the Query that I had created (and where the date parameter worked!), and there we go!!

Jules

[Suzan]

Woohoo! I figured it out!

All I had to do was change the record source in my Report to the Query that I had created (and where the date parameter worked!), and there we go!!

Jules

hello Jule, im glad you did that.. i faced a similar problem and tried everything and worked out.
What kind of database are you creating?
Good luck,

suzan

[Jule]

Hi Suzann,

It is for when I calculate employer portion of 401(k) for around a hundred employees.

Excel just isn't cutting it any more - although I have had to use it until I can figure out why my totals are off by a few cents; except when I add them by hand using the amounts from the report! Patrick is helping me with this...hopefully!

Thanks!
Jule

[Suzan]

Hi Jule,

Im glad everything is working out with you. When u need anything you can give it a shot and i wil try to see if i can help you. Since i am an MIS graduate, my boss asks me only about doing databases to optimize our activities. Im giving my best, and even you learn back in university, you only understand the meaning of Access by trying it yourself.

Good luck and its nice meeting you

Suzan

[Suzan]

by the way I forgo to ask you Jule... I posted a question in the Programmin section, but please could you give me a hand in this if you know?
here it goes!

Im almost done with my event database, but there is only an issue..
I set up some filters at starup of the database so that the user can be able to save time when searching for specific criteria.

Fox example: provided a list box with client's name and when i click on the button i can get to open the form with with only the selected client's name.. and the same is for others..

inside the client form, i did an event subform.. I wanted as well to create a filter for criterias within the event subform

For example, i would like to look up for ReferenceNo (each event has a reference number) and get the client form opened. this is the code that i used in the OnClick Event having a list box with the name of Combo0:

The OnClick event was set up in the button beside the list box:

Private Sub Command2_Click()
If IsNull(Combo0) = True Then
MsgBox "You must select a keyword."
Else
DoCmd.OpenForm "Client", , , "RefNo like '*" & Combo0 & "*'"
End If

End Sub

_________________________

Everything works great but the only issue is that I get a pop-up field to enter the RefNo again! So when i enter it correctly i can view the correct ClientForm, but if either i cancel it or enter another one, i dont get to see any form!
How can this be done in a correct way just to avoid the entering of parameter?

Please people, any help will be more than appreciated!

Thanks in advance!@

[Jule]

Sorry for the delay in getting back to you, Suzann,

I'm afraid I'm not much help with your questions...I'm still learning this kind of as I go.

Hopefully someone in the programming section has helped you!

Sorry to be no help,
Jule

[elmousa68]

If the control is to be bound to a global variable, not to a query, what should one do then?