Search results

  1. isladogs

    Solved Raised command buttons

    Fair enough. That's your opinion but its also your database!
  2. isladogs

    Solved Raised command buttons

    Its in Access Options . . .Current Database Once that is ticked, you can set the Use Theme to Yes or No in the property sheet Format tab for command buttons and some other control types: It will be Yes by default for all new controls but not for existing controls created before setting the...
  3. isladogs

    Late Control binding to make Forms Field independant.

    Just to say that @Imb has now sent me the .MDB version of the General file. Thanks I will now need to go through each module converting all API declarations and related variables to be VBA7 64-bit compatible That may take a while as there are a lot of code modules! Hopefully I will then be able...
  4. isladogs

    Late Control binding to make Forms Field independant.

    @Imb I share the same frustration as everyone else regarding this (and previous) threads To remind you, I am unable to test your simple example as I use 64-bit Access. Back in post #40, you offered to send me by email an MDB version of the General.mde file so I could try it out. However, it now...
  5. isladogs

    20266 Operation not supported

    @sonic8 Agreed. I've just edited that sentence as in your post and added a link to Karl's article for AFo .
  6. isladogs

    20266 Operation not supported

    Here is a further update on issues related to the security fix released on 9 Dec: The fix changed the default setting which is now to block queries to external databases. This is the case whether the query was done using a script, from Excel or from Access itself Previously such queries were...
  7. isladogs

    20266 Operation not supported

    Further to my previous post: The Access team are aware of the issue which was introduced with a security fix on Tues 9 Dec. They are currently investigating for workarounds, and whether a change could be made to allow cases such as yours. In the meantime, they have referenced this older article...
  8. isladogs

    20266 Operation not supported

    I have already had a response from the Access team. They are aware of the issue which was triggered by a security fix released on Tues 9 Dec. I will give a more detailed response and hopefully a workaround once I have had further confirmation from the team
  9. isladogs

    20266 Operation not supported

    If it works for you then that's great. I'll let you know if and when I get a response from the A-team
  10. isladogs

    20266 Operation not supported

    One thing. When the query ran successfully in version 2509, the output in the LINQPad window just showed the number of records (1) but not the actual data. Is that normal? I agree that this is very unusual usage so it may not be a high priority to fix. If not you will indeed need to find a...
  11. isladogs

    20266 Operation not supported

    Thanks I downloaded the 64-bit version of LINQPad with the following results Using CC version 2511 19426.20186 64-bit, the script failed on the line var rs = .... with the error Operation is not supported for this type of object Using Beta version 2601 19611.20002 64-bit .... same error Rolling...
  12. isladogs

    MaxHeadroomdecided against

    Hi. For anyone too young (or old) to know where Max Headroom originated, see https://en.wikipedia.org/wiki/Max_Headroom_(TV_series)
  13. isladogs

    20266 Operation not supported

    Thanks for the sample files. All the queries run successfully from Access in Beta Channel v2601 build 19611.20002 64-bit. I need a bit of help to test your script in LINQPad v5. It downloaded the required NuGet Interop files but when I run your script I get this runtime error: COMException...
  14. isladogs

    20266 Operation not supported

    I assume you meant versions 2509 and 2510 respectively. It would help if you could supply two simple repro databases and (if necessary) a script as so far none of us can replicate this issue
  15. isladogs

    20266 Operation not supported

    OK thanks. So 20266 is the minor build info for MEC. In future, please report channel, version and build (both major and minor) as shown in the screenshot. Also bitness where that appears to be relevant. Thanks Out of interest, did you attempt a rollback to the previous working version?
  16. isladogs

    20266 Operation not supported

    I'm confused by your description of 20266 being the latest current channel release for 365. This is the latest CC version / build Can you show a similar screenshot on your system.
  17. isladogs

    The Application.Reset Event

    @riktek I've tried your example database and have studied the execution flow sequence. Although your explanation of the sequence of events was very clear, having all the Debug.Print statements was very useful for me to understand what was going on. You've obviously put a lot of work into this...
  18. isladogs

    20266 Operation not supported

    Following Tom's prompt, I tested this on Beta Channel v2601 build 19608.20000 64-bit. No errors occurred
  19. isladogs

    How to deal with locking system in MS access safely in point of sales environment

    @nectorch Are you and @nector the same person? If so, why are you using two separate accounts?
  20. isladogs

    Late Control binding to make Forms Field independant.

    OK thanks. My email address is below. All being well, I'll post the file back in the thread as a 64-bit ACCDE
Back
Top Bottom