Search results

Yes, sorry, the error is that it isn't understanding the ModifyQuery is a function. Even though I have it declared Public as Public Sub ModifyQuery(p_qName As String, p_sql As String) Either way, I just need that one number from that one field of that one query. There has to be a better...

Ohh, lol, ok. I was just trying to view the outcome for testing so I could move on to the next step. I guess the only way to view that would be to DoCmd.RunSQL With those changes it still tells me "Expected Function or variable"

Ok, I know I had to do something wrong. I used your function, and have been studying it, and I think I can see the logic used there. My error is that when my code Debug.Print ModifyQuery("countOfSpecialistLookupQuery", strSQL) to call your above function keeps giving me the error "Expected...

I see, ModifyQuery is just a way to call the function, or sub. Ok, let me give it a shot and I will get back to you. Either way, I appreciate your help and time!

yes, I actually set my varFacility on another form and carried it over to this form, globally, using the [TempsVar] function. Your solution seems reasonable, let me try it out. Before I do, though, I want to make sure I understand this correctly, the...

Ok, not sure I follow, here are my two queries. specialistLookupQuery: SELECT QA_NTIDLookup.LastName, QA_NTIDLookup.FirstName, QA_NTIDLookup.Facility FROM ([User Information List] INNER JOIN QA_Supervisors ON [User Information List].ID = QA_Supervisors.[Created By]) INNER JOIN QA_NTIDLookup...

Hello again everyone. I have a series of queries that are used in various forms and reports. Two of my queries are specialistLookupQuery and countOfSpecialistLookupQuery. While I know I can generally get away with one query for this, they are used for many different reasons throughout the...

Thanks guys I'm pretty sure I did those but will try it again. Unfortunately it will be Wednesday before I get that opportunity. I am going to have the guy working on the database see this and can try and update on Monday. Thank you for your replies! Have a great weekend

I have a form that populates all of the specialist for the supervisor that is logged in. I created a macro, then deleted and created vba, for an on click event on the specialist name to pull up a report. If you pull the report up on its own you must type in the specialist name. What I want the...

Thank you! I will give it a shot, but not sure exactly when I will be able to get a crack at it. As soon as I am able to, I will update here with how it went. Thanks for the reply! I am looking forward to trying it out! The reason, since you asked, that the first database had no relations and...

I have an old database that I had to redesign. Unfortunately, it had multiple, unlinked tables with duplicate fields in each of those old tables. They basically made it a database with diffeent reports and forms to enter and manipulate their data with. I have created another database...

Ok, so after paying around a bit, and trying my hardest to get everything to work properly, I decided to create a whole new database just for experimentation purposes. The results: Everything works fine. Count queries and subqueries; two seperate queries, DCOUNT function, it wall works great...

Hi, thank you for your response! Here are my two queries: The First Query, since you can't do distinct, lists every record with a column that counts that row (displaying a 1) For example: OS2 1 OS2 1 OS3 1 SELECT QA_Supervisors.OS_Name, Comments.recordCompleted...

I have a Form set to continuous. The first textbox on the left properly displays a list of all supervisors. there are 16 text boxes to the right of that. Each one of those will relate to a query for counting purposes and will display a number, based on the number of results, for the particular...

Hello everyone. I am sure I just haven't used the right keywords for my search, but I can't seem to figure out how to dynamically fill out my form. I attached a zip with pictures form the previous database (which I did not create) for the goal. One is the Design View and the other is the Form...

Thank you. I wasn't really sure, as I am still new to VBA. I have other languages under my belt, btu alot to learn for VBA for all of the syntax changes.

I think, instead, I am going to use the expression builder part of discussion select form for each part and have multiple forms and queries. The code is alot simpler this way. Bascially I am creating an invisible box that will update with the various selections made for personnel, then create...

DoCmd.OpenQuery VO might work, but I am not sure you can use the DT as that is a part of the command. You might want to instead use the variables for a case argument and select the case based on the command you want to select. Select Case DT Case 1 DoCmd.OpenQuery =...

I should reiterate, fidning out where the information is is still my priority. Simply asking for the answer to where that is, I would never presume to ask for the answer to be handed to me. If, in fact, you have and I am just not getting it, then I might need some help with explanations on the...

LOL My wife is terrified of flying, she has taken a total of three flights in her life and I was on two of them with her. I hate to ask for more help, but the truth is, I simply can't seem to find my answers after reading two books on the subject. I know I have to be missing something simple...