Search results

Yes you can add subdatasheets to queries as well as tables. In fact you can have more than 1 level of subdatasheet using tables or queries as the data source However, I would advise against doing so for several reasons: 1. Both the main table/query and all subdatasheets need to be loaded - this...

I don't believe you should do so but Access does allow it. If you convert an indexed short text field to long text, Access will tell you that long text fields cannot be indexed and then remove it. However it will let you reinstate the index afterwards. It will also let you add an index to a...

I agree with the previous comments. Spend your time doing other types of optimisation. The only time I ever did this was for a huge table with data for 2.6 million UK Postcodes and with well over 50 fields. The table size was over 1.6 GB and I wanted to reduce it as much as possible due to the...

I have just written this up as a web article with additional detail. https://www.isladogs.co.uk/teams-office-problems/index.html However, after getting feedback from a couple of other MVPs that those Teams settings were not causing problems for them, I have, at least temporarily, reversed the...

I expect there is more than one cause for the hanging instances that various people in this thread are afflicted by. So whilst Teams was the problem in my case, it may not solve the problem for others. For those who are getting hanging instances, first check if Teams is running. Go to the...

That's definitely true but, as you realise, it doesn't answer the question. I had previously only opened the reports directly but now see your command bar on the cmdPrint button. I've also now looked at the ShowShapeMenu & CreateShapeMenu code and don't see how the commandbar object triggers...

@arnelgp I like your solution and the various shapes using the report. It works well Q: Can you explain the strange artefact on the form just behind your Print button - it doesn't appear to be a form object - what is it caused by?

You could use the undocumented JET ShowPlan feature to compare the efficiency of different versions of the query. https://isladogs.co.uk/show-plan-go-faster/index.html Unfortunately it doesn't work with subqueries

I finally discovered the reason for all these hanging instances this afternoon. I turns out that the cause was something else completely - Microsoft Teams!!!! In case it helps anyone else, here is a summary: In post #79 last Friday, I confirmed getting hanging instances with Access each time it...

Runtime versions have several limitations Not being able to do automation is I think a perfectly reasonable limitation. In fact I'd go further and say its a good thing

Thanks @Isaac but could you report back on your Windows & Office version and builds - as I did in post #1 The issue only seems to be on Win 11 machines that have the latest updates.

Not sure if its relevant but out of interest, what is your default browser and what is your default app for opening PDFs?

Thanks @arnelgp. How up to date is your Windows 11 machine? Full version build would really help. The issue apparently began after the January updates and also may not affect 2024 LTSC

Not sure what you mean as it only has one form. Again it would have been surprising if it had worked in runtime. To get all the version info, the code runs various WMI functions, checks multiple registry locations, runs various SysCmd checks and even does a web scrape of the Office 365 release...

No dialog to open or save?

Yes. I'd expect it to fail using / simulating Runtime. In fact, no need to try and do the automation as you will get that error if you just click the View / Edit Code button when using Runtime In case you or anyone else would find it useful, I do have a free Windows / Office / Access version...

Thanks

Recently there have been several reports that PDF files (whether local or online) no longer open in the old IE browser control. This is on machines that have the latest Windows Jan 2026 updates. Some people report just seeing an empty grey box where the browser control is located. In my...

Thanks Ron. That's good news! Please could you provide the version / build for each. I tested in both: Windows 11 Pro 25H2 26200.7705 and Access 365 v2603 19727.20000 Beta Channel Windows 10 Pro 22H2 19045.6809 and Access 365 v2603 19728.20004 Beta Channel

Just to add to my previous response, for the past two days I've been doing a lot of tests automating Access using A365 2603 Beta in both Win 10 and Win 11 machines. On both machines, I am now seeing hidden instances left over after closing automated Access apps and those opened directly...