Search results

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.

What's the SQL for queries q_count_globals and qryEmpRscores_by_taID ? As @Minty points out, you will probably want to recreate the queries as views on the server.

Note, OP is using Postgres, but your point still stands, George!

Remember, you are the developer - it's your job to convert the logical structure into the interface your client was to see and use. How it works behind the scenes is of no concern to the client.

Add a reference to the: Microsoft Office XX.0 Object Library (the XX.0 will vary according to the version of Office installed on your machine) This will allow you to get the intellisense in the VBA editor and browse all the properties/methods in the Object Browser (F2). However, eventually...

I doubt it's your fault! 😝 Probably the forum software. 😖

@theDBguy Your code has been munged with & for &

Hmmm.... I always understood it as 'meat market', casting aspersions on the types of ladies that might frequent such a place. :oops:

TFTFY! ;) 😝

See this almost 20 year old post on UA

Please show how you are doing the checks

OK, but if all values in Notes (Match/Spelling/Original) are dependent on other fields in the record then the field is not required. It can be produced 'on the fly'. When/where do you determine 'Match' and 'Original'?