Date Range Problem

K

kevin0862

How do I use VBA or a macro to present either a pop up form or inpu
boxes to accept and validate the dates, then call the queries using th
dates entered as parameters? The dates are popping up for both the quer
and my event. How can I sync both to work together? I current have th
query criteria as:
=[Forms]![Form Date Range]![Beginning Entry Date] And <=[Forms]![For
Click to expand...
Date Range]![Ending Entry Date]

Here's my event code...

Private Sub Form_Open(Cancel As Integer)

DoCmd.OpenForm "Form Date Range", , , , , acDialog, "Duplicates i
Associates Productivity"

End Sub

Private Sub Form_Close()

DoCmd.Close acForm, "Form Date Range"

End Sub


Can anyone help... Please!

THANK YOU EVERYONE ONCE AGAIN FOR NO ASSISTANCE... I'VE FIGURED IT OU
BY MYSELF
 
S

SteveS

kevin0862 said:
How do I use VBA or a macro to present either a pop up form or input
boxes to accept and validate the dates, then call the queries using the
dates entered as parameters? The dates are popping up for both the query
and my event. How can I sync both to work together? I current have the
query criteria as:
=[Forms]![Form Date Range]![Beginning Entry Date] And <=[Forms]![Form
Click to expand...
Date Range]![Ending Entry Date]

Here's my event code...

Private Sub Form_Open(Cancel As Integer)

DoCmd.OpenForm "Form Date Range", , , , , acDialog, "Duplicates in
Associates Productivity"

End Sub

Private Sub Form_Close()

DoCmd.Close acForm, "Form Date Range"

End Sub


Can anyone help... Please!

THANK YOU EVERYONE ONCE AGAIN FOR NO ASSISTANCE... I'VE FIGURED IT OUT
BY MYSELF!
Click to expand...

Kevin,

Why are you shouting? Are you upset that you were able to think on your own
and solve your problem?

You shouted "THANK YOU EVERYONE ONCE AGAIN FOR NO ASSISTANCE.....", yet when
I searched the other NGs in Microsoft.Public.Access, I didn't find a posting
of this problem! Why do you expect an answer without posting a question?

Also, you have 5 postings in thsi NG - all were answered the same day! And
you say "... ONCE AGAIN FOR NO ASSISTANCE..."???

I think you posted the question in a different forum. Even so, just because
no one volunteered to help you immediately is no reason to be *rude*.
 
Top