Search results

Well with more manipulation, I managed to get what I wanted. Not sure it's the 'right' way but, it works. The result of the query is for the record source of a combobox. I wanted the Location ascending, but grouped by the Service Unit and Tribal. Also note, I didn't want 'Division of Facility...

It appears this works. Is there a better way?

I'm not sure why I can't figure this out. I have a query that I want to show Location (ascending) textbox , but grouped by ServiceUnit (true) checkbox, then grouped by Tribal (true) checkbox. How do I do that?

I went back to another database I've done and it works there...?? Go figure. Must be a glitch.

I guess I don't really need to view the query so I guess it doesn't matter. The form and report shows red which is what I really needed. It took a bit to make it work for some reason. The form text box would did not allow me to change it to Rich Text until I first took the off the Total Query...

It appears to be because it's a Totals Query. If I deselect the Totals query button, it works. Does that seem right?

I can. And the <div> disappears. But, I do want the rich text option. I change the T_Update table to Rich Text and the Form field where this gets inputted from the user to Rich Text. I then get this when turning font to red. (first row only turned to red font) Why doesn't the query show the...

I have a query the results shown below. I get <div> comment </div> in one of the fields. The Text Format for that field is set to Rich Text in T_Update. How do I fix?

Thank Doc Man. This is what I wanted.

It appears is I use Modal for forms #2, #3, & #4 it seems to work. Does seem to fall in line with definition of Modal, as it's suppose to always keep focus. I guess when you open another form from a command button on the a modal form, it allows it. Is this a good way to do this?

I have a database that opens with a main form (#1). From the main form, the user can click to open form #2. From #2 you can open form #3 or form #4. From #3 you can open form #4 likewise from #4 you can open #3. All of these stack on top of one another. How do I keep the most recently opened...

Thanks Doc Man. You are correct, I really wanted IF X = 0 AND Y = 0 AND Z = 0 ... THEN ... ELSE ... END IF. I'll try to be more clear next time. Sure appreciate the help!

I have a form with some combo boxes and I want to verify they are filled prior to a command button executing some code. One of the combo boxes has 43 options to select from and the combo box stores the ID as a number. The issues is, when I select an option that has an ID 10 or greater, it will...

Found it. stLinkCriteria = "[Location_Description] =" & "'" & Me![Location_Descriptions] & "'" I always get messed up on those.

Yep, that was it! Thanks. Problem #2 It is not bring up the report with the matching Location Description. These are both text fields. Do I not have the quotes in the right places? stLinkCriteria = [Location_Description] = "'" & Me![Location_Descriptions] & "'"

I'm puzzled on this one. I have continuous form, that has a command button that executes on click the follow code. Private Sub buttonOpenReport_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "Location_Funded_Letter2020_R" stLinkCriteria =...

Of course not.... Wow. I tried so many other things but did know I could pick the labels too and format. Thanks DB!

I'm having trouble with a simple pie chart that I want to have in a report. I'm not using modern charts. The chart is fed by a table, FundingTypeCHART_T shown below. The pie chart displays as numbers only. I want this in currency. The row source for the chart, shows the currency, see below...

I finally got most things to work. Still plugging away. I will definitely work through your example. So much great stuff to learn here. I spent a little time looking into Debug.Print. I never know how that worked with the Immediate window. Very helpful! I also didn't know you need to hit...

MajP, Can you walk me through how this Sub works? Public Sub InsertAdditive(ProjID) Dim SQLAdditive As String SQLAdditive = "INSERT INTO Project_Additives_T (AdditiveID_FK, ProjectID_FK) " This line above defines SQLAdditive and is going to insert something in the two fields, in the...