Recent content by isladogs

  1. isladogs

    Solved Unable to access sql view of queries

    The build info on that page is often incorrect. You should use the info next to About Access and add the bitness. No need this time but please do so when you next have a problem
  2. isladogs

    Solved Unable to access sql view of queries

    How / why have you managed to stay on v2304? If/when they do fix this you won't get any benefit unless you do update! I don't like the title bar height either but not enough to turn off all updates Please can you state the version number, build and update channel when you do report problems...
  3. isladogs

    Solved Unable to access sql view of queries

    That was added to Access 365 plus 2016/2019/2021 in version 2311. Assuming that applies to you, it may be blocked by a custom command bar setting. The fix is to delete the command bar keys as mentioned in post #3 See my article: https://www.isladogs.co.uk/query-sql-view/index.html
  4. isladogs

    Solved Unable to access sql view of queries

    I very much doubt it will work as it didn't for me. However, its worth a try. I now know this has been an issue since A2010. It was OK in both A2003 & A2007 I will report it to the Access team
  5. isladogs

    Solved Unable to access sql view of queries

    EDITED: Just checked this as it didn't seem right to me. Its still visible in the query context menu from the navigation pane after disabling full menus However, (after rechecking), I agree SQLView in missing from the context menu when a query is open in design view or datasheet view. Suggest...
  6. isladogs

    Access Europe - Using VBA to create a class based on a table - Wed 1 May

    The video of Adolph's presentation to Access Europe on Wed 1 May is now available on YouTube. Hope others find it useful A significant part of the session explained how and why class modules can be very useful and showed how class module code can be generated automatically using VBA i.e. code...
  7. isladogs

    Access Europe - Using VBA to create a class based on a table - Wed 1 May

    REMINDER Access Europe meeting is today at 18:00 (6 PM) UK time. Hope you can join us. For full details and connection info, see post #1
  8. isladogs

    Access DevCon videos

    Two videos from this year's Access DevCon online conference have now been made publicly available on YouTube by the conference organiser Karl Donaubauer. These are the Add-In Creation with twinBasic by Mike Wolfe and my own session You Can REALLY Do All That With Forms? NOTE: Conference...
  9. isladogs

    How to open the "Access Option" from a button

    Agree with previous answers. However if there is a need to show the nav pane, re-enable shortcut menus etc, that can be done easily using code. I’m on my phone so can’t supply that Do a search eg on my website for access security OR search in similar threads below
  10. isladogs

    Solved Adjust Luminosity via VBA of any color value to it's lightest shade

    @GeoWorld / @GeoWorld2 Although you were upfront about doing so, you shouldn't have 2 separate accounts here. I'm not sure what the relevance of logging in from work is but you need to resolve the duplication I'm sorry but I also don't understand your response in post #45. My suggestion would...
  11. isladogs

    Google Maps

    Thinking of moving?
  12. isladogs

    Google Maps

    Precisely! I was providing an alternative solution. Having said that I don't find the map shifts when I zoom a google map directly in a browser
  13. isladogs

    Google Maps

    That doesn't happen in my example apps using Google maps. When the map is zoomed, the centre point is unchanged For example, see: https://www.isladogs.co.uk/get-current-geolocation/index.html https://www.isladogs.co.uk/get-geolocation-from-photos/index.html
  14. isladogs

    Office / VBE Language Issues (BUGS?)

    Thank you
  15. isladogs

    Office / VBE Language Issues (BUGS?)

    Hi Mike Yes I know but does it still wrongly say Alternative or has that been changed to Alternate (see post #1 screenshots)
Top Bottom