Centralizing Code for Form Buttons in a Module

[arnelgp]

mr.gasman:
I can't find my a2007 installer, this ver is a2010.

 

[Gasman]

Well, not quite true Tera as the link most often posted is from an Excel forum?
So perhaps MS then?

 

[Gasman]

mr.gasman:
I can't find my a2007 installer, this ver is a2010.

arnel,

Thank you for trying, but I still get 'unrecognised format' with that one.
Please do not go to any more trouble on this. It was merely to look at what you had coded.

Thanks again.

 

[June7]

I have no problem opening in 2010. What could be in it so 2007 would not open?

 

[Gasman]

I have no problem opening in 2010. What could be in it so 2007 would not open?

Not sure June7, sometimes I can open a DB without any issue, but most times I get that error, even when trying to open with shift key.

 

[GAK34nj]

I see there's something of a dust-up happening here. I apologize if I did anything wrong, out of ignorance. I'm not really sure what provoked this - not expeienced enough with these forums. I posted this on my "hello first message" page my mistake at first - saw the error - and then reposted it here. Hope that didn't cause this firestorm! If it did, please accept my sincere apologies!
Gary

 

[Gasman]

@GAK34nj

If you post multiple posts on the same issue, whether they be in different subforums here or on other sites, it is considered good practice/manners (at least by myself and a few other people) to indicate that.?
What we are trying to avoid is a/the solution being given on one thread/site and people still devoting their time to help (being unaware), when the problem has been solved.?

So as a matter of common courtesy, it is asked that you merely mention this fact.? That way all parties can be aware of what has been offered.
Sometimes a member will post a question, not like the answer and go elsewhere and post the same question, yet still be given the same answer.

On the whole though, that is quite rare.
As you can see, people are in different courts on this issue.
Do not take offence/criticism of it, it happens a lot with new members TBH, but if the person is not advised, they will still do it unknowingly.

Now that you have likely have a solution, advising of that on the other forum will prevent anyone there wasting their time trying to help?

 

[MajP]

This example takes Arnelgp's code a second step and makes it slightly easier to implement. Put all the controls on a subform. Now you simply drag the subform onto any forms footer. No need to copy and paste the controls and they will always look the same. Also you can format in one place if and all forms will update. The initialization becomes easier since you do not need to pass any parameters.
For those working with class modules, this will hilite that a form's module is a class. As you can see there is very little modification of the code and that only the instantiation is changed. I simply copied the class code on to the subform and changed the init slightly.

 

[Gasman]

@MajP
Any chance that you can supply a version that would open in 2007 please?

 

[The_Doc_Man]

MajP's idea is similar to what I did. I created a "template" form that had all my controls in it - but no table-specific content. I had CREATE, DELETE, SAVE, CANCEL, CLOSE, etc. as command buttons. I had all of the event code for each button already in the template. It had all of the safeguards about only allowing a CLOSE or navigation when the form wasn't "dirty." Then, when the template was set up, I could copy it and populate the table-specific or function-specific actions. Doing it that way probably saved me 40% of the time it would normally have taken if I had started from scratch for each form. Maybe more, but that's hard to be sure.

@GAK34nj, as a "newbie" you are not expected to know everything about the forum's ways. The "cross-posting" thing is a courtesy to prevent any accidental duplication of effort, which for an all-volunteer non-paid service is discouraging to our active responders. You have been warned about that policy now. Please continue to visit and seek help. Just understand that wasting the time of an unpaid volunteer is a way to make people unhappy. (As you noted.)

 

[Gasman]

advised Doc, advised, not warned. roflmao

 

[Isaac]

Geez, guys & gals, we have a saying in American English, "No harm no foul". It basically means, "Yes technically, but it's OK this time, because no harm was done".
I think that's all arnelgp was trying to say ..
I think if you take away the fact that everyone got upset at each other, there really wasn't any disagreement! That's what I see anyway.

 

[Deleted member 147267]

No one disputed that as far as I can see. The issue would seem to be that arnelgp thinks nothing of it, which is ok. What is not ok is for him to admonish others for expecting some common courtesy, and if it's not common amongst forums it certainly is among forum members in certain forums.

I marvel about how some forums are so anal about points or how questions are even asked and think it's ridiculous. But I don't call out others for what they obviously attach importance to. However I will continue to advise and request when it comes to cross posting. If you are a fellow responder and don't like that, too bad but keep it to yourself.

 

[Isaac]

I guess I was referring to his " there was no answer there so nobody's effort was wasted. " It seems to have unncessarily escalated thereafter.
I agree with you that it is OK for AWF to have their cross posting policy, and it is OK to notify posters about it.

 

[Isaac]

Can you save a record on a form and/or close the form from a module -outside- the form itself?

Yes

Save example:
Form_Formname.Dirty=False
Close example:
Docmd.Close acForm,"Formname"

You should not need to get into creating custom Classes solely to take actions on a form from a module. Just create public subs that take a frm as Form type parameter and then do things to the form.

 

[MajP]

@MajP
Any chance that you can supply a version that would open in 2007 please?

Unfortunately it will be a while. I am on travel now.

 

[Gasman]

I would say that 99.99% of the time, it is because the member does not know better.?
However that should not stop them being 'advised' of cross posting.?

Another member on that other forum is already trying to help?

 

[Gasman]

Unfortunately it will be a while. I am on travel now.

No rush Majp, merely for observation/education.

 

[Gasman]

Yes

Save example:
Form_Formname.Dirty=False
Close example:
Docmd.Close acForm,"Formname"

You should not need to get into creating custom Classes solely to take actions on a form from a module. Just create public subs that take a frm as Form type parameter and then do things to the form.

I'd agree, but if someone has given you a form class to to just that, I'd be more than happy to use it.?
I have started using @MajP 's FAYT classes. I do not need to know how they work, just that they do work, and work very well.
What I would call 'black box' routines.?

If arnelgp has created a Form class for the o/p that they can just use, then that is going to save them a lot ot time, as it will just work.?

I must admit, this is one of those times, that just handing out a fish works.

 

[Isaac]

I'd agree, but if someone has given you a form class to to just that, I'd be more than happy to use it.?
I have started using @MajP 's FAYT classes. I do not need to know how they work, just that they do work, and work very well.
What I would call 'black box' routines.?

If arnelgp has created a Form class for the o/p that they can just use, then that is going to save them a lot ot time, as it will just work.?

I must admit, this is one of those times, that just handing out a fish works.

I respect your positions and respectfully disagree. #1 I never deploy code that I don't personally understand, and could explain and troubleshoot if something goes wrong. #2 I know he likes classes and the more advanced stuff, and I greatly respect his skill, second to none--but that is HUUUUGE overkill in this instance, and I personally feel that deploying such a thing to someone less experienced is not doing them any favors. I guess we are different - I hate the idea of having any black box routine in my toolset, it seems dangerous to deploy something I cannot truly own. But mostly because it's an extreme form of overkill just for a few common and routine form commands...
I will stop now because I sense myself going into overdrive on this and truly, I respect your position. Carry on, I've said my piece. The OP will decide if they want something simple or more complex.