Search results

Somewhat late i know but I've only just seen this thread as I normally have the watercooler blocked. For info, although it wasn't the main point of this article, the handle I use is indeed a play on the location Isle of Dogs in east London and is explained in an article Why Isladogs? Why Access...

You can create the same large spreadsheets in both 32-bit and 64-bit Excel. The number of allowed records was increased back in Excel 2010 IIRC, and is not bitness specific. You can SOMETIMES install both 32-bit and 64-bit Office (different versions) though officially it is not possible For...

Yes it works well. I suspect that’s why my request to integrate it into modern charts wasn’t taken up

64-bit has improved memory handling and will be better for very demanding tasks. Otherwise 32-bit will be fine

Unfortunately not. I did request that feature about a year ago but it wasn’t taken up. I use the same solution with a subform as you.

@Jason Lee Hayes Not sure what is in your file from post #11, but it is blocked on my machine with a virus detected message

@arnelgp's code leaves the taskbar accessible so users can 'escape' by switching to another app. When I created my version of this a few years ago I deliberately ensured the taskbar was also dimmed and inaccessible See https://isladogs.co.uk/highlight-entire-form/index.html Both approaches are...

So the two fields I mentioned are in the CSV file and therefore text? I can see issues with your table structure in terms of repeating fields etc but nothing that explains error 3828 Hopefully uploading a cut-down database will assist us to explain the problem.

I suspect there will be a table or query property responsible. It would be helpful if you can upload the relevant objects from the database If the fields Quantity and / or AccountCode are number fields, there should be no quotes in the query sql for those fields

AFAIAA, former MVP, Doug Steele isn't a member here but I agree its an excellent tutorial

The issue is simple - you are using popup forms. Popup forms cannot be directly identified as active using Screen.ActiveForm. This is because they are located 'on top ' of the screen rather than being part of it Similarly, the selected control in a popup form cannot be identified using...

I've spent almost 30 years learning Access and I'm still finding things to learn I expect to be obsolete before Access is.

@dalski If I’ve inadvertently reinforced any concerns you have then my post had the opposite effect to that intended. Twelve years ago when Access 2013 was released, it was notable for removing several features without providing viable alternatives. Most were little used but there was a lot of...

Yes - that was the point. The issue still exists over a year later @msch88 I reported this in June 2024 and got an acknowledgement from the Access team The fact that it hasn't been fixed yet is I think because it is a relatively trivial issue in the larger scheme of things. I will raise it...

As already observed in another thread started by @pekajo, whenever this OP posts questions he/she does not respond to any of the advice or suggestions given.

You are both suggesting that functionality is being removed from Access itself (as in the great feature cull of A2013). That is not the case. Changes to external apps will indeed impact Access together with Excel etc. That is absolutely true but its not due to any changes in Access itself...

To hammer home the point (deliberate reuse of the analogy), MS is discontinuing the VBA enabled Publisher app from the Office suite in 2026. Whilst a few users will be disappointed by that decision, that can't be described as reducing the effectiveness of Access. The problem with Outlook is...

The change to Outlook equally affects all other Office apps such as Excel, Word and PowerPoint. As @sonic8 made clear, the effectiveness of Access itself is not being diminished.

Desktop

You can have both Classic & New Outlook. I have that in Windows 11 on 2 machines though only use Classic