Search results

@Ken Sheridan 's point regarding unexpected results with NOT IN when there may be NULLs is very important and something that has bit me in the past. As one other consideration along those same lines, I would suggest avoiding using NOT IN (SELECT .....) altogether because inevitably there will...

@Edgar_ I have been using the debugger and confirm that the Edge Browser Control is in ReadyState acComplete before calling RetrieveJavascriptValue. The Browser perfectly renders the html/css/javascript using the dynamic injection method with ExecuteJavascript, it is just that calling...

I can only conclude the above scenario in my previous post is due to a bug in the Edge Browser Control. I have used the older web browser control extensively with only dynamic html/css/javascript without issue, although at this point the old control does not support modern web standards. With...

Try checking the definition of vbDefaultButton2 in the context of your database. You can right-click on vbDefaultButton2 from your MsgBox call then click Definition. It should bring you to to the definition where it will indicate the value of 256. If vbDefaultButton2 is defined locally...

I think the difficulty in trying help on this is that there isn't enough information provided to understand the problem that you are trying to solve. For example: How quickly do you need the clients to be notified of changes (half a second, 5 seconds, 30 seconds, a minute). How many...

If you haven't already tried Compact & Repair after you decompiled, give that a try. If that still doesn't work, you could try the MZ-Tools (MS Access add-in). It is a 3rd party add-in (I have no affiliation, just a customer myself) and you can download a trial version. Once installed...

Good computer science concepts discussion. @The_Doc_Man explains it well -- addition works in this case only because the bit patterns don't overlap. But, if you mistakenly add the same constant value more than one time, addition would corrupt the bitwise representation but using bitwise OR...

I tested my above method and it works for me -- MS Access 365 64bit, Windows 11. If you haven't tried option 7 (SW_SHOWMINNOACTIVE), give it a try. SW_SHOWMINIMIZED doesn't work as it activates the application, which for Outlook results in the window not remaining minimized.

Try the below option. It should open outlook without activating it so it should remain minimized. Const SW_SHOWMINNOACTIVE = 7 result = ShellExecute(0, "open", "OUTLOOK.EXE", vbNullString, vbNullString, SW_SHOWMINNOACTIVE)

Hello everyone, I have been attempting to use the Edge Browser Control with dynamic HTML. This is ideal for my use case in using the Browser Control to generate modern UI and graphs through use of html/css/javascript. The issue I'm having is that while the Edge Browser Control works great to...

Hello everyone, I am a longtime MS Access application developer. First learned the basics many years ago in an accounting class where we had to build a simplistic relational database with a basic GUI. In the last several years, my work has focused on using MS Access with large SQL Server...