Re: Copying a button and precedure in Access 97

"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


.