There should of course be no problems having 3 or more clauses in a union query (the limit is 50)
Although your union query SQL appears to be valid, the screenshot in post 5 does show it has double spaces which may be an issue e.g. after FROM.
Also, there have been numerous regressions at various times with the Monaco SQL editor.
Most have since been fixed but as you haven't stated your version / build / update channel,...
isladogs
Last Activity: Nov 24 '25, 09:45 AM
Joined: Jul 21 '07
Location: Somerset, UK
-
Last edited by isladogs; Nov 9 '25, 09:48 AM. -
I've only just noticed this thread.
Neither the OnFormat nor OnPrint events have ever worked in Report view
The full quote from the MS Learn article states:
Report view just gives a visual representation of the report contents. It neither previews nor prints so the Format event doesn't fire....Leave a comment:
-
You mentioned decompiling after opening with the shift bypass. Not sure exactly what you mean by that.
Decompiling should be done as a command line switch (or from a shortcut) - see Access Command Line Switches
e.g. "C:\Full\Pa th\T o\Your\Database .accdb" /decompileLast edited by isladogs; Nov 18 '25, 08:49 AM.Leave a comment:
-
ID is not an index in this table is Access error 3800 and indicates likely corruption, almost certainly in one of your system tables.
Did you try importing all objects (except system tables) into a new blank database?Leave a comment:
-
Access Europe Video from Wed 4 June Meeting
The video of Domenico Ruggiero's presentation to the Access Europe User Group on Wed 4 June is now available on YouTube:
https://youtu.be/ZXtxh63d-fgThe topic was Orchestrating Office. I hope you enjoy it.Next month, Wed 2 July, Pete Poppe (MajP) returns with what I know will be another excellent presentation: Faking ‘Non-Normal’ User Interfaces with Normal Data -
Access Europe Video from Wed 4 June Meeting
The video of Domenico Ruggiero's presentation to the Access Europe User Group on Wed 4 June is now available on YouTube:
https://youtu.be/ZXtxh63d-fgThe topic was Orchestrating Office. I hope you enjoy it.Next month, Wed 2 July, Pete Poppe (MajP) returns with what I know will be another excellent presentation: Faking ‘Non-Normal’ User Interfaces with Normal Data -
isladogs replied to Access Europe - Wed 7 May: Update, update, the company is in a state (Karl Donaubauer)in AccessNOW AVAILABLE ON YouTube
The video of Karl Donaubauer's presentation to the Access Europe User Group on Wed 7 May during which he explained how best to identify, report and manage the impact of any update bugs
Video URL: Update, update ... the company is in a state!Last edited by isladogs; May 12 '25, 08:32 AM.Leave a comment:
-
For info, MSysDb is a system object present in all Access databases. It is not a system table and cannot be directly accessed / queried.
MSysDb stores the database properties as shown in the Database Documenter. See my article: Long Value Binary fields
Its unusual for that object to get corrupted but if it does so, your only course of action is to see what you can recover either using built-in Access tools or recovery software.Last edited by isladogs; May 5 '25, 10:02 PM.Leave a comment:
-
isladogs started a topic Access Europe - Wed 7 May: Update, update, the company is in a state (Karl Donaubauer)in AccessAccess Europe - Wed 7 May: Update, update, the company is in a state (Karl Donaubauer)
The next Access Europe User Group meeting will be on Wednesday 7 May 2025 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are very pleased to welcome back Karl Donaubauer from Austria. Karl has been an Access MVP for over 27 years and has long been a champion for the Access community. He organises two annual Access conferences (DevCon and AEK), co-ordinates the Access Forever blog site and had... -
isladogs replied to Access Europe User Group - Wed 2 Apr: Class Modules: How, Why and When To Use Them in the Real World (Anders Ebro)in AccessThe video of Anders Ebro's excellent presentation on Class Modules to the Access Europe User Group on 2 April is now available on YouTube:
http://https://www.youtube.com/watch?v=9chkPUV dvcw
Enjoy!Leave a comment:
-
isladogs started a topic Access Europe User Group - Wed 2 Apr: Class Modules: How, Why and When To Use Them in the Real World (Anders Ebro)in AccessAccess Europe User Group - Wed 2 Apr: Class Modules: How, Why and When To Use Them in the Real World (Anders Ebro)
The next Access Europe User Group meeting will be on Wednesday 2 Apr 2025 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
I hope you will join us on Wed 2 Apr for this session. For local start times, please check https://www.worldtimebu ddy.com
Note that the UK, Europe and North America will all have changed to daylight savings times so relative start times will be unchanged.
This session is based on... -
isladogs replied to Access Europe User Group - Wed 8 Jan: Developing COM Add-Ins for Access (Philipp Stiefel)in AccessThe video of Philipp Stiefel's superb presentation on COM Add-Ins to the Access Europe User Group is now available on YouTube: https://youtu.be/kisZ7CbBSXk
A PDF of the presentation slides is now available to download from:https://isladogs.co.uk/aeu-35/
Enjoy!...Leave a comment:
-
isladogs started a topic Access Europe User Group - Wed 8 Jan: Developing COM Add-Ins for Access (Philipp Stiefel)in AccessAccess Europe User Group - Wed 8 Jan: Developing COM Add-Ins for Access (Philipp Stiefel)
The next Access Europe User Group meeting will be on Wednesday 8 Jan 2025 starting at 18:00 UK time (6PM UTC) and finishing by 19:30 (7.30PM).
Note that the date is one week later than normal to avoid clashing with New Year celebrations.
In this presentation, former MVP, Philipp Stiefel will demonstrate how to develop COM add-ins for Microsoft Access.
COM add-ins can be used to extend the development...Last edited by isladogs; Dec 29 '24, 06:26 PM. -
Which specific Access version / build / bitness / channel are you having problems with?Leave a comment:
-
isladogs replied to Access Europe User Group - Wed 4 Dec: Custom Ribbons Using Command Bars (Adrian Bell)in AccessThe video of Adrian Bell's excellent presentation to the Access Europe User Group is now available on YouTube:
AEU34: Custom Ribbons Usng CommandBars (Adrian Bell)Leave a comment:
-
isladogs started a topic Access Europe User Group - Wed 4 Dec: Custom Ribbons Using Command Bars (Adrian Bell)in AccessAccess Europe User Group - Wed 4 Dec: Custom Ribbons Using Command Bars (Adrian Bell)
The next Access Europe User Group meeting will be on Wednesday 4 Dec 2024 starting at 18:00 UK time (6PM UTC) and finishing by 19:30 (7.30PM).
In this presentation, fellow UK MVP, Adrian Bell (AKA Bytes.com moderator @NeoPa) will demonstrate how to create custom ribbons using command bars.
Adrian will first demonstrate a technique based on the original Office CommandBar (CB) objects that allows CommandBarButto ns (CBBs)... -
isladogs started a topic Access Europe User Group - Wed 6 Nov: An Image/Photo Cataloguer (Chris Arnold)in AccessAccess Europe User Group - Wed 6 Nov: An Image/Photo Cataloguer (Chris Arnold)
The next Access Europe User Group meeting will be on Wednesday 6 Nov 2024 starting at 18:00 UK time (6PM UTC) and finishing by 19:30 (7.30PM).
In this month's presentation, Chris Arnold, will demonstrate his very versatile image/photo cataloguer.
The cataloguer allows the user to catalogue the pictures – perhaps a place name, a project, a person, an event or maybe your trainspotting or floral collection.
It...Last edited by isladogs; Oct 27 '24, 07:23 PM. -
Access Lunchtime User Group - Tues 29 Oct
Maria Barnes (MVP) will be leading a presentation for the Access Lunchtime User Group on the new Monaco SQL Editor for Access which is likely to be released to Access 365 Current Channel users by the end of this month.
The meeting starts at 12 noon CST (US - Central Standard Time) which is UTC-5. See the above link for connection details.
NOTE: For those in the UK, for this month ONLY, the meeting will start one hour earlier than...Last edited by isladogs; Oct 27 '24, 05:08 PM. -
isladogs replied to Access Europe - Wed 7 Aug: Using Treeviews with Access Applications (Pete Poppe)in AccessThe video of the excellent presentation by Pete Poppe (Maj P) to Access Europe last week is now available on YouTube.
It was by far the best explanation of when & how to use treeviews successfully that I've ever seen.
Well worth watching if you missed it ...and to watch again for those were present!
https://youtu.be/XpEHuWcHang...Leave a comment:
-
isladogs started a topic Access Europe - Wed 7 Aug: Using Treeviews with Access Applications (Pete Poppe)in AccessAccess Europe - Wed 7 Aug: Using Treeviews with Access Applications (Pete Poppe)
The next Access Europe User Group meeting will be on Wednesday 7 Aug 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome Pete Poppe who is very well known on several Access forums as MajP
In this session, Pete will introduce the Treeview control and demonstrate when it can greatly benefit the display of certain types of data within Access applications....
No activity results to display
Leave a comment: