Search results

@John Sh You haven't stated which Access version you are using or whether you are using the Monaco SQL editor Also you haven't said whether an error message appears when the update fails. These may all be relevant to your issue The code you copied in post #14 should work. However, there have...

Or more precisely: https://www.access-programmers.co.uk/forums/account/ignored?key=thread Click the small 'bin' icon on the right to restore an ignored thread - I tested on this thread!.

Another link that may be helpful. In this article, I tested the various optimisation techniques suggested by Allen Browne. Example database included https://www.isladogs.co.uk/speed-comparison-tests-8/index.html There is also a related video:

Hi Alessandro. Good to see you here. What kept you? 😀

Yes I understand the difference. My previous comments were referring to the awesome-VBA page on GitHub I also like the idea that’s being suggested in #7/#8 but also share doubts about its viability.

Sorry but I don't understand your comment. If you want to open a specific file in safe mode from Access then change it to: Sub OpenExcelWorkkbookSafeMode() Dim excelPath As String 'specify Excel and file paths (modify as necessary), /s is Safe mode, excelPath = "C:\Program...

As previously mentioned, I think this is of use as a curated list but I don't see it as being any different to / better than web pages such as Useful Links on my website.

Sub OpenExcelSafeMode() Dim excelPath As String 'specify Excel path (modify as necessary), /s is Safe mode excelPath = "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE /s" 'Now use Shell to open Excel in Safe Mode Shell excelPath, vbNormalFocus End Sub

@Josef P. Thanks for the GitHub link which I've not seen before. No idea who any of the contributors are. Whilst much of the material appears to be to web pages I'm already aware of, its useful as a curated list

You're welcome. Are you all sorted now?

Oops. Now fixed

Perhaps you (and I) have unintentionally set the default command button Picture Caption Arrangement property as No Picture Caption Try resetting it as e.g. General https://isladogs.co.uk/default-control-properties/index.html

I tested in A365 version 2506 Beta and 5 buttons have no caption. None show an image @Gasman is using an older version of Access (2019?) which may behave differently. However the problem is your settings. Its not a bug The button with a caption has no image so the caption shows up OK The...

The video of Domenico Ruggiero's presentation to the Access Europe User Group on Wed 4 June is now available on YouTube: Hope you enjoy it. Next month, Wed 2 July, Pete Poppe (MajP) returns with what I know will be another excellent presentation: https://www.isladogs.co.uk/aeu-41/index.html

Yes but you can’t add decompile to the toolbar/ribbon

Its an Explorer extension that can used to run any Access command line switch and could be adapted to provide similar functionality in any other Office app. Its based on an excellent utility by Daniel Pineault and I can't recommend it enough as an excellent time saver...

FWIW, I used to decompile using a shortcut. Nowadays I decompile using a right click context menu which also allows me to compact / open exclusively / simulate runtime / code sign a project etc

Just for the record, the code posted by @Pat Hartman in post #11 is by Allen Browne. It is part of a collection of ADOX functions which can be found at http://allenbrowne.com/func-ADOX.html

It’s not intended to show the interrelationships between objects. To do that, use the built-in Access dependency checker which shows the dependencies between tables, queries, forms and reports. The built-in version doesn’t include macros and modules but there are several tools that do so, both...

For info, are you aware that a subform opens before the main form opens and closes after the main form closes