Search results

Thankfully Jon 'only' had 48000 posts of Pat's to delete. Even so, this was by far the biggest single contribution of any AWF member over the years and does leave a big hole in many threads she contributed to, as well as the removal of entire threads that Pat started. However, to repeat my...

For a quick blast of nostalgia of Access from v1.0 to the current day, see https://www.isladogs.co.uk/memory-lane/index.html

REMINDER - Access Europe User Group meeting with Ynte Jan Kuindersma is TODAY (Wed 5 Nov) at 18:00 UK time (UTC) See post #1 for details / connection info The meeting will also include a brief summary of the latest news from the Access team announced at both the German AEK and UKAUG conferences...

To get the formatting you want, you must have the default text specified in the bound column. So either 1. Change the column widths to e.g. 2cm;2cm and modify the format spec Or 2. change the bound column to 2 However doing the latter will generate a new issue for you to deal with....

I’ve not experienced or heard of this issue. Can you upload an example database showing this effect. If I can reproduce the problem I will report it to the Access team

Love the typo in post #1. An 'online curse'. 😁

LAA is for 32-bit Access and has been built-in for the past 2 years or so. 64-bit was always large address aware. https://isladogs.co.uk/large-address-awareness/index.html In any case LAA has absolutely nothing to do with the situation described by the OP. Try compacting the app externally. I...

Its always very sad when somebody goes from being regarded as one of the most respected experts to becoming a significantly negative influence on the forum. In this case, I agree completely with my namesake @ColinEssex (it doesn't happen often!) that Pat brought the situation entirely upon...

I use a slight variation on the same theme which is fast and may be less code. Hide the ribbon in an autoexec macro then open the startup form. The ribbon remains hidden so no additional code is needed here. For reports there are several choices designed to allow printing 1. If using Report...

If it keeps happening then it’s probably bad practice! 🙂 If this has fixed it for the foreseeable future then you’ve cleared the corruption issue however it occurred. In which case, blame Access (fairly or not)! I find certain apps get repeated minor corruption during development usually due to...

1. Check for missing references 2. Try DEcompiling your project

You can normally delete a non-empty folder without special commands, but not if any files are in use and therefore locked. Whilst I agree about how cover art gets added, the presence of those files shouldn't prevent the folder being deleted directly from File Explorer unless the .mp3 files are...

Thanks. I’ll look at your code to see what you have done. 14 character limit for passwords prior to A2007. Since then 20 characters. I totally agree that no file based app such as Access can ever be 100% secure. Indeed I made that exact point in a presentation I did for both UKAUG and the...

@Jason I haven't looked at this since #1 but wondered why you used LongLong (64-bit only) rather than LongPtr (valid in both 32 and 64-bit) @mcppsi Your screenshot does indeed look very attractive. Perhaps you would be willing to share your version? You may already be aware of this but, if...

If you have the excellent Office add-in VBE_Extras, you can use 'special binding' to get all the benefits of early binding whilst using late binding i.e. you get the best of both worlds! For more details, see https://www.thevbahelp.com/post/special-binding

The next Access Europe User Group meeting will be on Wednesday 5 Nov 2025 starting at 18:00 UK time (6PM UTC) and finishing by 19:30 (7.30PM). Please note that the UK has now reverted to winter time. For local times, please check World Time Buddy In this session, we are very pleased to welcome...

With the Folder Image Viewer what happens when you select one of the images in the list box?

Hi Jason For info: I tested this whilst my version of Office was temporarily set to Spanish language The code then caused 6 repeated errors (1 for each image) on the line: If Left(ctrl.Name, 5) = "Image" Then ctrl.Visible = False Disabling the line solved the issue. Of course, it runs fine in...

Good to see you posting here Albert and hadn't realised you had in fact been a member since 2009. I've just spent half an hour reading all your old posts to this forum, full of wisdom and, of course, written in your own unique and entertaining style. So although you certainly aren't new here...

Also, up to around 2022 or thereabouts, you could also embed Excel, Word and PowerPoint objects into Access with almost zero effort. This functionality depended on the old viewers for those document types which MS has now deprecated. However I think all of the recent posts (including mine) are...