Search results

  1. kengooch

    Counting Parent Records and then Child Records on a Continuous Form after a filter is applied.

    I have a continuous form that is based on a child table so that all records are present. When I use the Count(*) function in an unbound text box on the form it gives me the total count of all records that are displayed on the form. However, I also need to know how many Parent records exist...
  2. kengooch

    Can't seem to call a Macro within Access

    Wow... that's a lot of coding, and if I am seeing what you're saying, I would have to include each of the 6 mutli-select list boxes into that code. So what I already did in creating a 2nd ClrFilters2 macro would be sort of the same thing. Here is a picture of the form and the code that...
  3. kengooch

    Can't seem to call a Macro within Access

    It is vba code. and the dual buttons is simply for aesthetics. You would think that this would be as simple as it is in Excel...
  4. kengooch

    Can't seem to call a Macro within Access

    I have two buttons on a form that are designed to clear my multi-select list boxes. I was trying to call the first macro from the 2nd button so that I wouldn't have to duplicate the code. I tried the CALL statement which works in Excel but then found a post that said in Access VBA to use...
  5. kengooch

    Filter a form with unbound text boxes that count values in a field based on the dates

    Well I put this equation in and adjusted it to use tDateAcc and the form opens and flashes the field on and off really fast and shows a #Error in the field. I just got back to my desk again, so I am going to look more closely at the equation and make sure I have it correct.
  6. kengooch

    Filter a form with unbound text boxes that count values in a field based on the dates

    I added the vDateStart and vDateEnd as unbound text boxes onto the form with all of the totals, (see picture in earlier post) in hopes of being able to use those two fields to isolate the records by the date range and then be able to count the totals bound by the date range. vDateStart shows...
  7. kengooch

    Filter a form with unbound text boxes that count values in a field based on the dates

    Here is the tAccLog structure. It holds the basic patient record. There is a Child Table that holds the specific details for each encounter called tAccSpc The two tables are linked by the tAccNoLink field. Each item in the tAccLog may or may not have records in the tAccSpc table. I have a...
  8. kengooch

    Filter a form with unbound text boxes that count values in a field based on the dates

    I have a From that shows a quick list of totals for various aspects of Patient data Table and it's child records. See image below. They are asking now to be able to filter these totals by month or by quarter, and by Pathologist. So my thought is to provide a start and end date and tally the...
  9. kengooch

    open an access report filtered from a form

    OOPS!!!! What a dummy! thanks!! where would I add the "All"?
  10. kengooch

    open an access report filtered from a form

    If you look at the uploaded picture, that is my 3rd line of code and for whatever reason it gives me an error
  11. kengooch

    open an access report filtered from a form

    So, when I add this code to the database I get a Compile error. I thought that by adding a Dim StrWhere as String would fix it, but it didn't.
  12. kengooch

    open an access report filtered from a form

    I wondered why some people would code like that. It honestly never dawned on me to do that!! This is a VERY GOOD idea!!
  13. kengooch

    open an access report filtered from a form

    Just dawned on me that sometimes I want the list of all Pathologist... is there a way to add a "*" in the drop down list that will read as any value or a way to adjust the equation to accomplish that?
  14. kengooch

    open an access report filtered from a form

    Works perfectly!!! I guess it's the single quotes that cause it to recognize the value correctly?... thanks so much for the solution.
  15. kengooch

    open an access report filtered from a form

    I have a form that has 2 unbound text boxes in which I enter vDateSt and the other one vDateEnd I also have a third combobox that looks up the last name of a Pathologist vGetPatho. I have a report that is designed to show all records between the two above dates and the select Pathologist. I...
  16. kengooch

    Solved Timed Message Box

    This is beyond amazing! thanks!!
  17. kengooch

    Solved Timed Message Box

    Yes I have observed this when using it with Excel, I attribute it to the server delay here at the VA Medical Center... We have a lot of security hoops and the servers are all remote
  18. kengooch

    Solved Timed Message Box

    WOWZA!!! That's amazing! But i didn't see anything about It opens the MsgBox and leaves it sitting on the screen until you click OK
Top Bottom