Re: Copying a button and precedure in Access 97

Larry, I understand. I too have posted in this forum before, and all replies,
including mine have been civil. I asked a reasonable question about copying a
button with code, and I got what very much sounded like a put down.

Please understand that I have been writing computer code since 1975. I've
written hundreds of applications, including a relational database from
scratch (without a database engine). And I have been commended by many,
including internationally, on my applications. One appeared in a scientific
paper (including screen shots) written by a physician at the Royal Brompton
Hospital in London. I am not a newbie. Access has a wealth of functionality
built in to it, and no one can know it all.

Rick's reply did not address the question at all. Had he done so along with
his criticism, I would have ignored the criticism. As it was presented, it
was simply a very public put down. I sincerely apologize to any and all,
including Rick, who may have been offended by my response to what appeared to
me to be an insult.

Thank you for bringing this to my attention, and thank you for your response.
Norm

--

Norm Shimmel
Butler, PA


"Larry Linson" wrote:

"NES" wrote

> Rick, I appreciate the unwarranted criticizm.
> I didn't say they were similar forms, and
> they are not. This reply was not helpful.
> Please refrain from helping me further.

That kind of response is a really good way to ensure that quite a lot of
people will "refrain from helping you further" -- none of us want to be
chewed out for trying to assist, and, from observing Rick B's previous
posts, I am certain that was his intent. However, unless he is much more
patient than most of us, I would wager that he will, indeed, "refrain from
helping you further."

I am not sure of all the modifications you describe. Generally, the only
things I can think of that would differ between Forms would be the name of
the Form and the WhereCondition in the DoCmd.OpenForm statement -- and
those, by necessity, would have to be manually changed.

The free MZTOOLS V3 for VB6 and VBA, from http://www.mztools.com, has a
feature to allow Copy and Paste Controls with Code, and to Rename Controls
with Code. You'll still have to change the name of the Form and the
WhereCondition argument in the DoCmd.OpenForm. I use other of MZTOOLs
features, too, and find it very useful.

Larry Linson
Microsoft Access MVP



.

Loading