Search results

I would note that the code you gave me does provide a total count of the tAccNo records that have connected tAccSpc records. But that number does not refresh or update when I select items in the Multi-Select List Boxes. I wonder if it would if I added some kind of refresh or requery to the...

Wow that was quick and works perfect on your form. However, I guess I have built mine differently, because when I change your form to a Continuous form I get an error message So my form (fAccListMSLB) is based on a query that has two tables joined together. * The parent table is tAccLog and...

Thanks for the info, so would this function be coded on the actual child forms vba coding area? Would I then somehow assign the function to an unbound textboxl on the form to get the result to show?

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

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

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

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

I have still not gotten it to work.

tDateAcc from the parent table tAccLog

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.

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

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

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

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

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

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.

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

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?

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

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