Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2006
    Posts
    7

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

    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

  2. #2
    Join Date
    Mar 2006
    Posts
    7
    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

  3. #3
    Suzan is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2006
    Posts
    13
    Quote Originally Posted by 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
    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

  4. #4
    Join Date
    Mar 2006
    Posts
    7
    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

  5. #5
    Suzan is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2006
    Posts
    13
    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

  6. #6
    Suzan is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2006
    Posts
    13
    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!@

  7. #7
    Join Date
    Mar 2006
    Posts
    7
    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

  8. #8
    elmousa68 is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2006
    Location
    Amman, Jordan
    Posts
    6

    Binding control to a global variable

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

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Create a recordset for a report
    By vjboaz in forum Programming
    Replies: 0
    Last Post: 11-18-2008, 03:28 PM
  2. Hide zero value in report and date syntax
    By Alex Motilal in forum Access
    Replies: 0
    Last Post: 11-16-2008, 09:11 AM
  3. Create a calendar report?
    By valkyry in forum Reports
    Replies: 0
    Last Post: 09-14-2006, 11:34 PM
  4. Create the link
    By accessman2 in forum Access
    Replies: 0
    Last Post: 03-13-2006, 01:16 AM
  5. Replies: 1
    Last Post: 12-09-2005, 10:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums