Recent content by cheekybuddha

Still unclear why you would use a nonsense query to demonstrate. That aside, I wonder if you were to have copied the contents of the Update To: field in the query designer and then pasted it, whether it would have maintained the formatting and indentation (ie the line breaks are there, but...

Did you ever expect this query to work, or were you using an invalid query to demonstrate that the editor attempts to display it in grid view and falls to alert that it is invalid?

I'm not sure VBA was mentioned, or did I miss something? (quite likely!)

I used to use an application that would read methods/properties of com dll's called TypeLibVwr.exe (made by iTripoli) I found a reference to it here: https://type-library-viewer.updatestar.com/en but I know nothing about that site, so use at your own risk! I don't think this will solve your...

Perhaps you misunderstood my point. Hearing of users on current channel experiencing these issues would usually make me think that they have made a mistake and got themselves on the wrong preview channel somehow. And I suspect this is probably the case in these instances The shocking part is...

I guess that MS are probably a victim of their megalithic size. Normally one might dismiss this as an anomaly, or a mistake on the users' part, and it wouldn't be particularly shocking. What's shocking is that MS' [not so] recent attitude towards testing and quality control makes this...

Wow! If this is the case, then what is the point of the preview channel? If bugs are discovered in preview and still make it in to stable ... 😖 Surely if you're too late to prevent the bug going into stable, then issue a hotfix to stable at the same time as updating preview channel. MS, why?

Actually, from previous posts from nector, I understood it that the server is just a box in their office and their ISP doesn't give them a static IP. (I may well be mistaken). The clients are probably using 'user'@'%' accounts. Not good for security, especially if the connections are not...

You may need to investigate a service like dyndns.org

So much hope ... ... so much disappointment 😖

Ouch!

I'm not saying "Don't do it in Access"! I just suggested to consider Access' limitations too. The OP said "I look forward to learning and relearning Access" If you're having to learn a technology it might be worth learning something with more forward-looking possibilities than a dying one.

Very true, but you could build a web app using free technologies and your only cost would be the webserver. Compare that cost vs all those licences 🤪

Hi and welcome! Do consider: With Access you will be Windows-bound, and (without using a server-based RDBMS) also bound to a wired local network. If you may need to use your program on other devices (eg non-Windows tablets, Macs, or phones) or remotely or over wifi, then Access might not be...

Is this in a server RDBMS (eg not in Access)? If so, please provide CREATE TABLE statements for your tables.