Search results

You've made that point several times already. That is your opinion and that's fine. However there is no benefit in repeating yourself. Excel / Word etc already have the new style Office messages but they don't have Wizhook or Eval so, unlike Access, the built-in functionality can neither be...

For info, all of that is basically equivalent to my example app linked in post #9

For info, I've now completed the second article in my series: https://www.isladogs.co.uk/eval-new-style-msgbox/index.html This also includes a comparison of the different features of the various message types in Access 365. Thanks again to @AHeyne for the info provided in post #48 which I...

You can try my example app as a starting point: https://www.isladogs.co.uk/password-login/index.html In addition, parts of the following app may also be of use: https://www.isladogs.co.uk/logged-in-users/index.html

Yes MS lost a lawsuit about this and removed the ability to edit linked Excel worksheet in A2002. However, if you set IMEX=0 in the connection string instead of the default IMEX=2, then all linked Excel worksheets become editable again. See my article...

Can you upload a simple repro database that exhibits these problems?

@AHeyne Thanks for that very useful info. I had seen the original version of that in your response to Mike Wolfe's Wizhook article from 2022 https://nolongerset.com/wizmsg/ In fact, I used the same techniques to determine the maximum length of the message title (132 char) and prompt text (2999...

I've only rarely used them with my FormattedMsgBox which is why I hadn't previously spotted the difference in behaviour when these were used. Neil & I have been exchanging emails for several days about the various permutations of Eval, FormattedMsgBox & WizMsgBox and I hope to cover all of these...

Yes I agree but I can’t see them doing so after all this time. Nevertheless it’s something I’m planning to raise with other MVPs and the Access team once I’ve completed the second article.

Phew indeed! It was for that exact reason that my own wrapper function for the WizMsgBox (MsgBoxW) has all the arguments in the same order as the standard VBA MsgBox. As you want the ‘old style’ messages, have you also confirmed that none of your message boxes include the HelpFile and Context...

That is correct. It was mentioned in the Access Europe meeting led by Neil Sargent on Wed 7 Jan and is also covered in the articles linked in my last reply. The same applies to any built-in function - it can be 'overwritten' by your own custom function as Access will always use the custom...

Glad I could help. However, there are a couple of important things you need to be aware of: 1. The optional arguments for the FormattedMsgBox function are in the same order as the standard VBA MsgBox function: Public Function FormattedMsgBox(Prompt As String, Optional Buttons As VbMsgBoxStyle...

Unlikely that the Eval functionality will change as doing so would break backwards compatibility. Only rarely do MS make changes that causes old code to break and when that happens it is usually related to security issues they deem important e.g. remote query execution I would still recommend...

@tvanstiphout No slimy hack required! You can still link to queries in the BE The new security restrictions ONLY affect Access databases where the FE isn't trusted You can still do either of these approaches to link to a BE query as long as the FE is trusted SELECT * FROM [Full path to BE...

Several of the 2007 templates are still available in the latest version of Access. AFAIK without any changes made e.g. Contacts, Bug Tracking, Northwind (Legacy) It might help if you stated which templates you are interested in. For example, I have copies of all the old Northwind databases...

When distributing applications, a common request is for the appearance of Access forms to be automatically updated in line with the currently selected Office UI theme. The attached database demonstrates one way that this can be done. It includes all required code. From Office 2016 onwards...

Wizhook is an amazing object which has been available since Access 97 and is, at least in part, used by Access wizards. It has over 70 functions but remains completely undocumented. Most of its functionality has been deduced over the past 25 years but even now there are a few functions that...

@DickyP That's interesting and unexpected! I realise your comment was intended to be critical but you have discovered something that as far as I am concerned is helpful. The output of the Wizhook variant of the MsgBox used to have a bold first line but is now the new style message box You gain...

@mellamokb The fix was released to the Beta channel in version 2602 build 19711.20000 on 13 Jan. It will shortly roll out to CCP and then CC. Unfortunately, the fix is very limited in terms of which scenarios have been included and it will NOT help you with your script based process. After...

It’s usually easier to see mistakes in someone else’s work. In this case, I knew the likely cause having done it myself more times than I care to remember.