Recent content by johnny_swindle

Thank you plog.... I took you example and added date range and other parameters that were needed and it displayed what was needed. Again, thank you. You don't know how much you helped. Johnny

Thank you for your reply. There is one to many relationship between client and service table. If the current structure of the two tables prevents creating a query/series of queries to do the job, the a little manual count may be necessary. Restructuring the database and relationships is no...

I am attempting to help a non-profit organization with their access database. The question is: how to count the number of clients who have receive services in more than one category during a specific time frame. client table: holds demographic data; cID if primary key, autonumber service table...

I was able to solve the problem with the users who responded and with a little help from ChatGPT. Private Sub eName_AfterUpdate() If Me.eName = "Tour De Lis LA" Then ' Replace "SomeValue" with the value that should trigger hiding Form2 Me.tourDetails_subform.Visible = True...

I tried my hand at crafting the correct code. I am getting an error message on line one: Private Sub eName_Change() If Me!eName.Value = "Tour De Lis LA" Then Forms!tourDetails_subform.Visible = ture Else Forms!events_subform1.Form!tourDetails_subform.Form!.Visible = False End If End Sub

@GaP42 I am glad you asked if they were side by side. Inf fact, subform 2 is a subform of subform1. I am sure that this makes a difference.

I have two subforms on a tab. On subform 1, I have a combo box (eName) and if the value is Tour De Lis, the make subform 2 visible. I am not sure how to approach this situation. Johnny

Hello everyone.... I have lurked on this site for a long time learning from the posts of others and decided to join. I thank each and everyone in advance for you assistance as I become more proficient in using Access.