Recent content by tvanstiphout

In a Continuous form, if we want to change the RowSource of a combobox for each row, we can overlay that combobox with a textbox. An example is implemented in NW2-Dev, Order form, Order Line Items subform, the Product section. The textbox shows the value for the non-current rows, and the...

> what am I looking for in the decompiled code? Nothing. Decompiling throws away previous compiled state of each form and module (the P-Code that is run by the VBA runtime). Next time the code is run, Access will automatically compile it again, rather than re-using the possibly bad previous...

I am 99% sure the issue is NOT with the code change you showed. Did you try decompiling the application? When you copy an ACCDB from Uni to Home or vice versa, the versions may be different enough that fresh compiled code is needed. Search online for "Access decompile" to learn how to do it.

One thing you can try is Edit > Replace and replace strSQl with strSQL throughout.

Isn't that what they are doing? Set objFSO = CreateObject("Scripting.FileSystemObject")

My experience was that the Private Enum LongPtr definition appeared in Red. I did not even try to compile it, but I just did and to my surprise it did work. I don't have #VBA6 available here (it's now 20 years later; such dinosaurs will likely not be using your code :-)) so I cannot test in that...

I don't think so Colin. You are free to ignore a stack frame in YOUR code, but the Example is not wrong. It loops from 0 to Ubound, which comprises of all array elements / stack frames. Maybe you were thinking of: For i = 0 To FrameCount() - 1

I misspoke. Once at the breakpoint, I *did* use the Immediate window to call my testDumpStack procedure . Sorry for the confusion.

I did not use the Immediate window.

Impressive. I set a breakpoint in NW2-Dev.modInventory.ProductAvailable and then added a product to an order. The call stack showed: and your code showed: (testDumpStack is my code that calls your code). There was no crash. A365-32 MEC. I will leave it to others to comment on the legalities...

Never mind, I figured it out: the Field object is a reference to a field in the form's RecordsetClone. Filtering the form changes the RecordsetClone and thus the field is no longer valid. I changed the code to use the field name (as a string) instead, and that works.

Access splitforms have their issues, so I wanted to write my own lookalike. Open mySplitForm, and observe you can navigate using the mainform, or the unbound listbox. To make this a generic module I am using form subclassing. So far so good. Now filter the mainform. You will get an error because...

Rich Text is fine for Comment-like fields where people can type away and use some formatting tools. It is NOT fine for creating a textbox where additional text must be inserted at the caret. In my case it was a physician's patient narrative, with ability to insert standard phrases. RTF is NOT...

Interesting how several developers are working on this same issue at the same time. https://www.experts-exchange.com/articles/40696/Custom-toggle-button-for-Microsoft-Access.html

If your current interface has no sprocs or views, and SQL Server is only used to store the tables, and everything else is in Access with linked tables, then yes, this is not a successful configuration with the BE on Azure. Access is very chatty, and pulling all that data back and forth is...