Recent content by EVP

Thank you Pat! I feel we're close, but the criteria is still not quite right. With this criteria, none of the queries work. I adjusted it, so now I can query for each criteria just as before, however I still can't get "both" to appear. Thanks for your help!

Yes, that is what I am saying. However, the only criteria for this query is : [Ineligibility Determined by VidaCare or Medicaid?] as the parameter. I'm not using a control on the form. If I type IS NOT NULL in the parameter box it puts quotation marks around it and won't pull up the...

Sorry for not being clear. I have a parameter query box pop-up upon the opening of a form. Specifically, this query is used to differentiate Ineligible applications deemed so by either Vidacare or Medicaid (there are some applications deemed ineligible by neither, and so that field is blank)...

Parameter Query - Can't believe I can't figure this out This should be an easy one, I have a parameter query on a form with two criteria options; works great. I want the user to be able to type in the criteria so that it runs for all the criteria (or what would simply be a "xxxx" or "yyyy"...

Thank you for the prompt reply. Sorry for the newbie confusion, But which is the control? My field name is MemberID. Thanks again.

Hi, Can anyone help me with why this is not working? In the event code of a command button I have: Private Sub DocStatusCmd_Click() -THIS IS HIGHLIGHTED?? On Error GoTo Err_DocStatusCmd_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Documentation...

I think I've come up with a 'quick and dirty' solution. I can't believe I didn't see this before:rolleyes:... I'm simply creating a command button that will close the query (bringing the user back to the main menu) and when they reopen the query (by clicking on the command button that opens the...

I'm trying to filter between two dates (previous and todays date). Don't I need two values in the filter? Is there a way to code the filter button so that the 2nd date is always todays date? Also, I got rid of the first text box (SubmitAfterDate) but the parameter value box for...

The combo box is in the form, and yes it is visible. I tried this code in the AfterUpdate of the combo box. Still doesn't work. I'm trying this from a new angle, Do you know where can I put: DoCmd.Close In this command button: Private Sub HURtrntoMainCmd6_Click() On Error GoTo...

I have two text boxes in my form: SubmitAfterDate and, TxtMyDate A filter command button: Private Sub FilterButton_Click() Me.FilterOn = True Me.Filter = "([SubmitAfterDate]>=" & "#" & txtMyDate & "#)" End Sub And in my query the criteria is: Between...

Thank you, Thank you!! That works, I just have to get the kinks out (after applying filter of two dates it still prompts me to enter the first date??) I will spend more time with the access books :)

Correct. This was an evolution from a parameter query between a start date and present date that would pop-up when opening the form. However, I could never get the form to 'refresh' and allow me to change the criteria (without closing and re-opening the form). I've since realized all is better...

Well, this may be the problem :rolleyes: I tried using the command button, but that pulled up the query in data sheet view - Not what I wanted. Is it possible to type these values in a txt box in the form and simply refresh the form to run this query (in form view)??

Thanks for your help! However, it's still not working for me:( I now have two text boxes in my form exactly as you suggested, with this in my query criteria: Between [Forms]![HUSubmitDteFrm]![SubmitAfterDate] And [Forms]![HUSubmitDteFrm]![txtTodaysDate] Ideally I'd like to have the user...

Hi all, Any ideas on why my form is not working to run a parameter query? In my query criteria I have: Between [Forms]![HUSubmitDteFrm]![SubmitAfterDate] And Date() The unbound text box in the form is named SubmitAfterDate. However, when I type in a date in the form, nothing happens (even if...