Search results

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.

That is the best "soft" explanaiton of a Class Module I have seen to date...

Welcome aboard!

And in his case, it just might be the on-coming train...

What is tragic, is one of the most brilliant minds in the wide world of Access (IMHO), offered to take this one on - no strings. I for one, was anxious to see what came of it. But for some reason, he refused. Sad actually.

I cant do that. This like watching Howard Stern - I HAVE to stick around to see what he says next... I may need a 12-step program...? Nah...

I said as much in my post - a solution was offered but no action taken. @DakotaRidge - simply put, that is the deal of the century. If you do not take him up on this, then your ignorance will have attained a level that can not be measured with modern technology.

Almost 200 posts into this, he/we are no closer to a solution to the original question. When he was given an answer to it, there was no follow-thru on his part to actually try it. The developers here tried (in vain) to save him from himself but he seems to take delight in explaining how his...

(y) (y) :ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO:

...and yet...

I dont beleive you...

Glad I'm not the only one

Silver linings

Embrace it, Paul. Its the only way to keep your sanity... BTW, I hit the big 6-0 last month. Guess I am official a "geezer"

Does AWF even have a means to accept contributions anymore?

I opened up a query in SQL view and here is what I saw: SELECT tbl_Participants.RiderID, [FirstName] & " " & (" """ + [NickName] + """") AS Member, tbl_Participants.LastName, tbl_Participants.Email, tbl_Participants.ContactNumber, tbl_Participants.MotorcycleOwner FROM...