Search results

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...

Your attempt does not do what I suggested. Expression is: InStr([Advice], "(") > 0

Parentheses are: ( ) Brackets are: [ ] Braces are: { } Maybe just look for opening parenthesis: InStr([Advice], "(") > 0

I think I have experienced this sometime in the distant past. Possible corruption of database or Access?

Under what circumstances does the original code not work?

Why is qryFedTax1 including join to FedTaxTable? qryStateTax2 does not repeat join to StateTaxTable. Should be consistent with naming. Why not names qryFedTax1 and qryFedTax2? I would advise not to use spaces in object naming.

Cartesian Product: the number of rows in the result-set is the product of the number of rows of the two tables. Joining on ContactID reduces the multiplication but doesn't eliminate. Joining restricts which records will associate and thereafter a Cartesian product is employed. In a table where...

CJ, a self-join on only ContactID will involve Cartesian product. If a contact has both a car and bike record, joining will return 4 records, not 2. If there are other categories, the multiplication gets worse. If there are 3 types, then 9 records result. Use of WHERE clause with AND operator...

CJ, Since CategoryType should not be a field in tblContact_Category, use CategoryTypeID in WHERE clause for the first SQL. This approach involves a Cartesian relationship which may be slower than nested query.

That's why one would make copy and remove sensitive data.

Again, please post code between CODE tags. Should be able to query source table(s) and not need local "temp" table.

Please post code between CODE tags to retain indentation and readability, especially longer snippets. I tested code with my query, except for funcDisplayEMail_nosend because its code is not provided. No file is saved. I had to specify full destination path. All data is presented as ASCII codes...