Recent content by dackedyman

Can you help me to further understand what a TempVar is and how I can use it for my purposes? Is there any code of mine that you would need to see?

I know this topic has been discussed before, but I guess I am just not understanding the solutions well enough. For my company, I must develop a login form to access the database, which I have done. I want to be able to use the UserName variable during the login to show on another form when a...

Thank you for your help June7 and isladogs. I implemented the changes June7 suggested to the best of my ability, but the list box goes blank when I choose an option from the drop down list. Below is the code I have used. Private Sub SpecialtyCombo_AfterUpdate() List6.RowSource = "SELECT *...

Thank you for your quick response. I appreciate it. Here is the UNION query I have: SELECT tblStaff.StaffID, tblStaff.FirstName, tblStaff.LastName, tblSpecialities.Type FROM (tblStaff INNER JOIN StaffSpecialitiesJunctionTbl ON tblStaff.StaffID = StaffSpecialitiesJunctionTbl.StaffID) INNER...

I have seen a few threads on this issue online, but they are confusing to me. I work for a medical company with Therapist, and I have been able to display who specializes in a certain area based of a combo box selection. However, I want to further filter/narrow the search results based off the...

Thank you Mark. I really appreciate your help. There is so much to learn!

It is a medical facility, which has Therapist and Providers (Medical doctors). The therapist have Specialties and Models sub forms, which should appear on the form when selecting Therapist from the drop-down menu. For the Providers I want those sub forms to be invisible since that information...

I am new to VBA. I used code from this site to make subforms visible or invisible based off the selection from a combo box. The issue I am having is that if I select "Therapist" from the Combo12 combo box, the SpecialitiesSubFrm and ModelSubFrm are visible (which is what I want), but they are...

Hello, I have been working with Access for the last year, but I am new to VBA programming. I am hoping to accelerate my learning by networking with knowledgeable people.