Search results

  1. isladogs

    New glasses needed for similar threads feature

    Not sure when this happened but the column headings in the similar threads feature are for some reason blurred and unreadable.
  2. isladogs

    Challenge to disable the shift bypass

    A member at Utter Access posed a challenge in this thread There were many critical responses to the idea of self destructing an app that may well have been purchased legally. I agreed with those comments and wrote the following in reply: - no Access file can ever be made 100% secure, If your...
  3. isladogs

    Palindrome day

    Today is 2 February 2020 or 02/02/2020. That's a palindrome whether the date format is dd/mm/yyyy or mm/dd/yyyy Next equivalent palindrome day not until 12/12/2121
  4. isladogs

    New points feature. Does it serve any real purpose?

    Apologies to Jon if I'm encroaching on his territory.... Two new 'merit' systems have been introduced in place of the old Thanks and reputation points. 1. Likes in place of Thanks. Jon is looking into merging the old Thanks with the new Likes. 2. A Points system based on the number of posts and...
  5. isladogs

    Another Access 365 bug

    Just when you thought it was safe to go back in the water ... After the debacle of the query is corrupt bug, there is another serious bug caused by the 1912 update to Access 365. This affects databases with SQL Server backends and has now been acknowledged by MS...
  6. isladogs

    Access Memory Leak patched after only 17 years!

    The latest Office Watch email that I receive contained a link to this article:Another Access memory leak finally patched According to the article the issue has existed in all versions of Access since 2002. It could potentially be used by hackers to obtain private information though that seems...
  7. isladogs

    Suggested changes to reputation points

    A recent thread by Tera, Thanks or Like in site suggestions led on to a discussion about reputation points. I think the system is useful though like any such system it isn't perfect. I would like to propose the following changes to the use of RPs.which I believe will make them better...
  8. isladogs

    20:20

    Happy New Year to all AWF members May 2020 be the year where we all have 'perfect vision' about the future
  9. isladogs

    Chip Pearson's website

    As many of you will know Chip died in April 2018. He ran an excellent website for Excel and VBA at http://www.cpearson.com/ Unfortunately, the site has recently gone down though archived pages can still be found at the Wayback Machine Internet archive website. Hopefully someone will take on...
  10. isladogs

    UK Postcode Address & House Price Lookup

    Attached is a simple app I created to get a list of addresses & house price info for selected UK postcodes together with the geo-coordinates and a static Google map for that postcode. It is a cut down version of my commercial application UK Postal Address Finder The geocoordinates for the...
  11. isladogs

    Free Access Repair Tool

    Has anyone here used the Access Repair tool from DataNumen? https://www.datanumen.com/access-repair/ Its free for personal use and at first sight seems legitimate...but I'm suspicious. As far as I can see its just imports tables and queries into a new database…. including converting deep...
  12. isladogs

    Application.UserControl property

    This thread is designed to show how the UserControl property can be used to restrict how an application can be opened. Just one line of code is required in the Form_Load event of the startup form or in an autoexec macro. It has been done partly in response to a recent thread by calvinie...
  13. isladogs

    Access error -query is corrupt

    For info. New article from MS released today https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec Here's an example Only a month to wait for the fix - 10 Dec 2019. Sigh! But of course sooner for those running 365! 24 Nov. Reminds me of...
  14. isladogs

    View & Edit IMEX Data Task Specifications

    Prior to Access 2007, import/import specifications were saved in 2 system tables : MSysIMEXSpecs / MSysIMEXColumns In Access 2007, this system was largely replaced (but see note below) with a wizard driven & arguably more powerful XML based system of Import/Export Data Tasks. However, ease of...
  15. isladogs

    Import/Export Data Tasks

    A current thread by smig https://www.access-programmers.co.uk/forums/showthread.php?t=307860 reminded me of the differences in the old and new methods of importing/exporting files. In the past, import/export specifications were stored to two system files MSysIMEXSpecs and MSysIMEXColumns...
  16. isladogs

    Useful links

    I have a large number of Useful Links on my website which I've just updated today and would like to expand further. Please let me know of any suggestions for additional Access related links that I may have forgotten or be unaware of. Site name & URL together with a brief description please TIA
  17. isladogs

    TIP: Convert table links to UNC paths

    By default the linked table manager (LTM) uses mapped drive letters e.g. G:\ However, a common issue in split databases is that various users may have different drive letters for the same location. Using UNC paths solves that issue A recent thread reminded me of a tip for updating Access linked...
  18. isladogs

    1001 * dbg

    As many of you will have noticed the DBGuy not only posts good advice he also posts a lot of it... In the past 28 days he has amassed a mind boggling 1001 posts. That's an average of over 35 posts every day and recently more like 60-80 daily. How does he find the time? Must be something in...
  19. isladogs

    Lines of code that changed the world

    I found this article by chance and thought it would interest others here https://slate.com/technology/2019/10/consequential-computer-code-software-history.html?utm_source=Iterable&utm_medium=email&utm_campaign=the-overflow-newsletter&utm_content=10-29-19
  20. isladogs

    Get Geolocation Data from Photos

    If you’re anything like me, you will have built up a large collection of digital photos from your phone or camera but may have forgotten where many of those photos were taken This app is designed to manage that situation and was prompted by a request from AWF member MickJav in this thread...
Top Bottom