Search results

Many on this thread have provided very good input. To help illustrate what we mean by junction tables and provide one way a portion of this can be done, you could follow a design pattern like the below diagram. This overall would provide the following benefits: tblEmployeePositionHistory...

I had a similar interpretation as @Edgar_. Many beginners who are learning Access (or even experienced users with strong database skills) may not be programmers by trade and thus may not be aware of the basics around debugging. Covering that could potentially be useful if not already addressed...

Currently based on the OP's code posted above, I see nothing from the recordset being used in the UPDATE query. For example, currently, you are looping over each record in the recordset, but you have nothing in the WHERE of your UPDATE query or in the SET that is being used from the recordset...

One thing to check on this, if you are on a recent version of Access (such as version 16), DAO is now defined as part of the reference to "Microsoft Office 16.0 Access database engine Object Library" where you should be able to remove your separate reference to DAO 3.6 to avoid any conflicts.

@arnelgp I was speaking as more of a rule of thumb to avoid "NOT IN (SELECT*..." in the context of the broader discussion about unmatched query approaches. I understand in the OP's specific instance that it wouldn't happen because the field is part of a PK and can't be NULL. From much...

I would add one more approach to this that isn't always thought of and that can perform very well when using a backend RDBMS, assuming the OP's dashboard does not need to be editable (I'm assuming it may not need to be editable based on the OP's screenshot and noting it is a dashboard that is...

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