Search results

Not seeing HTML tags. That's the string need to see - the concatenated string, not executed result showing in textbox. Use a variable to hold it then Debug.Print. Or Debug.Print Me.txtSQL might show it.

What's the </i> tag for - italic? Should there be <i> at the beginning? Regardless, I still get color. Would have to see your compiled string.

I think restriction on posting links has something to do with number of posts - a spamming countermeasure. When you hit a magic number, the restriction should lift.

What color do you expect - blue? Works for me.

The_Doc_Man scenario assumes that an existing record for a PersonID/ClassID/ClassDate combination would never be edited by the LMS. If that is the case (which seems reasonable for your situation) then the NOT IN restriction is appropriate. Otherwise, explore what is called an UPSERT action. It...

Okay, cumulative - could probably just set a link to the CSV and then work with that linked table. Give the CSV file a generic name (no date part) then every time you do cumulative export from LMS overwrite the file so name is unchanged and link is stable. Use the linked table as source for...

Is the CSV an export of cumulative data or only new data since previous export? Import to Access can limit which fields you want, likely no need for Excel intermediary. Or just set a link to CSV file that pulls all fields then build queries to use what you really want. Updating non-normalized...

Yeah, I know but it sure saved me the other day trying to figure out some code for Excel to manipulate Word. I was quite surprised.

I am able to build expression in ControlSource with more than 255 characters. Review posts 8 and 13 of the cross-post for more info. Copilot tells me character limit for ControlSource property is 2048. Seems I've seen that number elsewhere as well.

How can this be useful? I tested code. As soon as I type first letter, code sets focus to other control. I can never enter a full value. This is no better than Click event.

Arnel, when I press Enter in a combobox, cursor moves to next control, even after changing value. Combobox does not have an EnterKeyBehavior property which means this action cannot be altered like with textbox. AfterUpdate and Click events work just fine for me. If you want to provide db for...

In my testing, it worked with rectangle positioned in front or back. In either case, have to click on "blank" space. Video in zip folder.

I don't disagree with the difference. However, I was not addressing treating rectangle as a "container", I was addressing selecting multiple objects by click/sweep. I thought your assertion was that the rectangle could be selected along with other objects only if the sweep began outside the...

Don't know what else to tell you. Still works for me. Mouse left click inside or outside then sweep. Using Access 2020.

I am able to multi-select all controls, including the rectangle, by "sweeping" without shift/click.

I tested the code and it does output a string of node contents (I passed string to MsgBox). So what do you mean by "print". Nothing in the given code actually prints anything, just saves a string to a textbox. I also tested OutputTo method to create a PDF of the form. That works as well...

Not sure what you are trying to do when you say "print an expanded tree view screen". Print what how - content of nodes to printer paper or PDF? Not first time this has been asked https://www.access-programmers.co.uk/forums/threads/print-treeview-control.61400/ My Bing search returned AI...

Your DLookup as shown should fail anyway because it lacks a space in front of AND operator. Company.Add "taxblAmtA", Nz(Round(DSum("TaxableValue", "QryJsonPos001", "[ItemSoldID] =" & Me.txtJsonReceived & "And [TaxClassA] = 'A'"), 4), 0)

@DaveMD suggestion works for me. Private Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hWnd As LongPtr, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As LongPtr...

For one thing, I think need to define constants: ' Show command constants Private Const SW_HIDE As Long = 0 Private Const SW_SHOWNORMAL As Long = 1 Private Const SW_SHOWMINIMIZED As Long = 2 Private Const SW_SHOWMAXIMIZED As Long = 3 or just use the numeric value. And another thing, why are...