Search results

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...

Okay, I did find the AfterUpdate control, but this code did not work. I think the problem is I am not actually closing the form, but using a command button to open another form. This is how I want the front end to appear, not sure how much work this requires on the back end. Thank you for any...

Thank you, It is a combo box. I apologize for being a self-taught (but not very well) Access user that gets roped into being a programmer; But where would this event control be? Are you speaking of the form, or the query? I would most like to link this event to a command button. Thank you for...

Hello, I couldn't find help on the forms forum, so I thought I'd try here. I have a form for a query with a parameter value. I'm having problems 'refreshing' this query, meaning once a value is entered as a parameter, I can't get the parameter box to appear again (unless I close out the form...

Anyone?????

Hi all, Yet another newbie question... I have a form running off a query with a parameter value. I also have this same form 'linked' to a main form via a command button. Every time I click this command button I want the parameter value box to request a parameter (right now it's like the form...