Search results

  1. isladogs

    Pat Hartman has left the building

    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...
  2. isladogs

    Hello from Devon AB Canada

    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
  3. isladogs

    Access Europe User Group - Wed 5 Nov: Using Power Automate with Office Apps (Ynte Jan Kuindersma)

    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...
  4. isladogs

    Solved Problem with the format property of a combo box.

    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....
  5. isladogs

    Random "unhide this form" prompt

    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
  6. isladogs

    SQL Query Help Please

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

    Access File Recovery

    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...
  8. isladogs

    Pat Hartman has left the building

    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...
  9. isladogs

    Solved Looking to hide ribbon for forms but not reports

    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...
  10. isladogs

    Solved Tips To Ascertain 'User-Defined Type Not Defined' Error

    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...
  11. isladogs

    Solved Tips To Ascertain 'User-Defined Type Not Defined' Error

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

    windows 11, cant see hidden files in folder

    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...
  13. isladogs

    Simple Password Strength Checker with PWned Online Check

    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...
  14. isladogs

    Simple Password Strength Checker with PWned Online Check

    @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...
  15. isladogs

    How to register library/reference from vba code?

    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
  16. isladogs

    Access Europe User Group - Wed 5 Nov: Using Power Automate with Office Apps (Ynte Jan Kuindersma)

    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...
  17. isladogs

    Updating Image Controls In Real-Time

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

    Simple Password Strength Checker with PWned Online Check

    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...
  19. isladogs

    How to register library/reference from vba code?

    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...
  20. isladogs

    Microsoft Access: Edge Browser Control is finally 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...
Back
Top Bottom