Solved Dlookup in Query

[cheekybuddha]

Are you keeping track of the extra work you are having to do to avoid the best tool?

For the particular issue in this thread VBA is not the best tool for the job! Much better to use plain-jane SQL!

 

[cheekybuddha]

Sorry, what was that? Couldn't quite hear you!

 

[Sarah.M]

I hope you understand my situation. I can't change the cybersecurity policy
Please I need positive motivating words that lift our spirits. I'm sure there are people who have the same problem as me
Plz

 

[Sarah.M]

I like this Forum AWF very much.
If my questions bother you, I apologise to you all

 

[The_Doc_Man]

My original suggestion about talking to the boss was because you perceive yourself to be at the wrong end of the telescope for people to see what is going on. The key is to make this someone else's problem since you don't think you have any clout. And maybe you don't, but if someone else than you really wants this, get their help in slapping aside those restrictions. It is AMAZING what happens when that IT person suddenly finds him/herself under the glare of the spotlight for interfering with necessary company business. That approach even worked for me when I was working with the U.S. Navy, and you can just imagine how strictly THEIR security was set up. The IT staff gets the idea that they are doing you a favor by protecting you, but once someone else sees they are preventing progress, that WILL change. I've seen it too many times.