Search results

Had I read this first, it would have made my day a lot shorter...

Not 100% clear on what this means, but since I could use a UDF to get values, I thought maybe TempVars would work - they don't. What is interesting is that DMs can and will fail silently and not write an error to the Application Log table like it will for others. However, all in all, using...

Well, as I said, I do not mind being wrong. The thing to remember is to place the Function in the FE and then in the DM, set the field to that Function. I guess I simply over-thunk it and ASSuMEd that a Function in the FE could not impact a Table/Data Macro on the BE. Quite easy actually...

I dont see how, but I do not mind being wrong. I will set it up and see what happens. Thanks

But how does the BE know who made the change in a split db/multi-user environment? No one is really logged on and even if it were to return a user, how would it know WhoDunIt?

Quite right. However I do have a question, and if the answer is on one of these threads, I will gladly "peel the onion"... Q: Is it possible to determine WHO made the change with a DM? I have used the attached to build my DM's and they work great. But what I cannot figure out is how to get...

Great analogy and irrefutable...

Not a clue George...but...I do know that the other apps in Office have a similar feature as Control Tip - ScreenTip I think. If they show the same behavior then you could chalk it up to an OS issue. Edit I posted your entire post in my Gov PC's version of ChatGPT - NIPRGPT (Gemini, I'm certain):

Impressive!

Welcome aboard!

Welcome aboard!

Welcome aboard!

Exactly, even though Excel is being used for the same thing and holds the same "sensative" data. I dont mind people being stupid, but be consistent with your stupidity

Who could be nicer than you...? Perish the thought!

So, by this answer, you agree that using collections, dictionaries or arrays would be a better course of action?

I tried to get it to write a Class Module for me and the code looked impressive enough until I looked at it. Even with my MEAGER knowledge of Class Modules I was able to see it wouldn't work and when I mentioned this, it said "Yeah, you're RIGHT! Try this instead..." I'm sorry, I thought...

Hi Dave, Yes. Basically, something to capture the form's and subform's field values BEFORE and changes are made and then restoring them if the cancel button is pressed.

Reading this thread: Solved - Undo Updates on a Subform | Access World Forums https://share.google/vcxiK5qDD0uyPyFVs The solution provided involving temp tables seemed a little unwieldy. I am wondering if a Class Module using Dictionaries, Collections or Arrays would be cleaner and/or more...

In addition to Gasman's solution, if your spreadsheet's columns are static (names and datatype will remain the same) then you could create a saves Import Spec. I offer this just as an alternative. Personally, I would perfer linking and appending. Cleaner and less moving parts.