Results 1 to 9 of 9
  1. #1
    rmohebian is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    16

    capturing the input date


    Hello,
    I am trying to capture the date parameter of my query.
    you enter a start date and end date to display monthly cheques.
    what I want to do is take the dates entered and display them in a textbox labeled invoice period on my form

    can anyone help?

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    How are the dates being entered into the query?

  3. #3
    rmohebian is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    16
    SELECT [Student Cheque].Student, [Student Cheque].Amount, [Student Cheque].[Cheque No], [Student Cheque].Note, [Student Cheque].[Cheque Date]
    FROM [Student Cheque]
    WHERE ((([Student Cheque].[Cheque Date])>=[Forms]![Cheque Report Form]![Cheque Date From] And ([Student Cheque].[Cheque Date])<=[Forms]![Cheque Report Form]![Cheque Date To]));

  4. #4
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Is it also being displayed on Cheque Report Form?

  5. #5
    rmohebian is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    16
    Yes it does

  6. #6
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Ok. I dont see why you would want to display this as it's already shown on the form because the user entered it. That just seems redundant to me. Anyway, make the value of the textbox =Me.controlName

  7. #7
    rmohebian is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    16
    The user enters it through pop up windows. But i would like it displayed on the form. cause the form produces an invoice. I want does dates to show in a textbox as the invoice period.
    Thnx for you help

  8. #8
    rmohebian is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    16
    I used what you said but I get an #NAME? error
    I am not sure I am using it correctly>
    pretty new to Access
    Do I use that as the control source?

  9. #9
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Ignore my first suggestion, as it wont work with the entry method you have. Why not have textboxes on the form where the user enters the date, instead of a popup? Then you simply refer the query to the form. This also removes your need to display the dates as they are already there.

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

Similar Threads

  1. Capturing Still Image From A Camera
    By kstarkes in forum Access
    Replies: 1
    Last Post: 01-28-2011, 04:16 PM
  2. Replies: 9
    Last Post: 10-01-2010, 05:50 PM
  3. capturing the address repeatedly
    By simba in forum Forms
    Replies: 12
    Last Post: 03-24-2010, 11:05 AM
  4. date entry on input form
    By dzawicki in forum Forms
    Replies: 3
    Last Post: 12-25-2009, 08:13 AM
  5. Replies: 1
    Last Post: 09-20-2007, 02:56 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