Search results

  1. O

    Using a Form to Populate a Query

    *bumpage**bump*
  2. O

    Using a Form to Populate a Query

    *Bump**Bump*
  3. O

    Using a Form to Populate a Query

    Private Sub cmdApplyFilter_Click() Dim strCity As String Dim strState As String Dim strFilter As String Dim strMedicaid As String 'Setup Option Boxes Select Case Me!fraMedicaid.Value Case 1 strMedicaid = "='Yes'" Case 2 strMedicaid = "='No'" Case 3 strMedicaid = "Like...
  4. O

    Using a Form to Populate a Query

    Private Sub cmdApplyFilter_Click() Dim strCity As String Dim strState As String Dim strFilter As String Dim IntMedicaid As Integer 'Setup Option Boxes Select Case Me!fraMedicaid.Value Case 1 IntMedicaid = -1 Case 2 IntMedicaid = 0 Case 3 IntMedicaid = 2 End Select...
  5. O

    Using a Form to Populate a Query

    Thats good stuff, I'm certainly going to use that. I have one more question however. The examples he uses allow the user to chose from combo and option boxes, but there isn't an example illustrating how to filter a report by a date range, as in filtering a report on the fly by hire or...
  6. O

    Using a Form to Populate a Query

    I want my users to be able to search the db through a popup form and then generate reports based on their input. Can someone post a bit of sample VBA that demonstrates a form field populating SQL statements? I'm not sure if this is even the correct procedure. Any help is appreciated.
  7. O

    RunSQL Action Query Error

    I need the Age field populated in the tblDemographics so that users can search by age. Are you saying that I might create these ages as a precursor to searching for them? Please amplify your suggestion, I am open to anything that makes the DB more robust and user friendly.
  8. O

    RunSQL Action Query Error

    Even if I took the close paren off as you suggested? I followed your advice but it still wouldn't run, then I combined your suggestion with the flip flop of quotations and it ran. Is there another issue with the statement?
  9. O

    RunSQL Action Query Error

    You're not going to believe this, but I swapped out the single quotes on the outside with double quotes and put the single quotes inside the statement and now it works:D Thanks for the help guys.
  10. O

    RunSQL Action Query Error

    Thanks for the prompt reply, I tried taking one of the close parens off, but to no avail. Private Sub DOB_AfterUpdate() DoCmd.RunSQL 'UPDATE tblDemographics SET tblDemographics.Age = DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))' End Sub Same error with the...
  11. O

    RunSQL Action Query Error

    I am attempting to have an action query populate the "Age" field of my demographics table. I want my input form to run the action query after the DOB field has been updated as to populate that field as the form is being completed. However, I continue to get "Compile Error: Argument Not Optional"...
  12. O

    Query Criterion Question

    Thanks again Fofa! My lack of knowledge about SQL syntax strikes again!
  13. O

    Query Criterion Question

    Thanks again Fofa! My lack of knowledge about SQL syntax strikes again!
  14. O

    Query Criterion Question

    Ok, I made a query that returns a Case Manager, their associated cases, and 3 dates that relate to each of these cases. So its: Case Manager-----Case Name----Date1-----Date2-----Date3 I only want records to appear that have a value in at least 1 of the 3 date fields. If they have no data in...
  15. O

    Having a list of record names displayed and opening the full record via click

    Ok, the entirety of the form you posted is actually a subform of another form that I have. So if say I was on record "Musicians" I could only select Ringo, etc. from the subform, that would bring up their record in the subsequent subform.
  16. O

    Having a list of record names displayed and opening the full record via click

    Ok, that was great got it to work thanks. But one more question. The form you included would be the subform on my main data entry page. When I drop ther combo box down, I see a list of ALL the names, not just the ones associated with the Master form I have open. While I cannot select names from...
  17. O

    Having a list of record names displayed and opening the full record via click

    Is there a sample database or public VBA script to which someone could point us? I've searched the repository above but to no avail.
  18. O

    Having a list of record names displayed and opening the full record via click

    Could you expound on this? I have 3 tables: Case, Parents, and Events. Case--->Parents--->Events (all 1 to many relationships) In my tblCase input form I would like a combo box for parent names that brings up their events in a subform. What is the proper vba code to achieve this?
  19. O

    Return Earliest Date

    Many thanks. I got it to work, buts as FoFa said I cannot add the client's names to the query without getting multiple dates for the same Case Manager, but thats ok, I'm just gonna base another query with the required calculations off of this one. Thanks a ton guys, you're the best. :D
  20. O

    Return Earliest Date

    Im getting a syntax error. Might I send you some screen shots?
Back
Top Bottom