event procedures dosnt copy with command button

[rbg]

hi
i have a form with 8 command button that every button have a on click event procedure (vba).
i want to copy command buttons to another forms ( about 80 forms!!) but when paste my buttons in other forms , event procedures not pasted.
can anybody help me??

 

[John Big Booty]

You are going to need to paste the VBA into the On Click Event for each button. When you copy and paste a button to a new form you are only copying and pasting the button graphic and not the associated Event(s), those need to be done as a separate step.

 

[vbaInet]

i want to copy command buttons to another forms ( about 80 forms!!)

It sounds suspiciously duplicated. I reckon you've created more forms than is actually needed.

 

[rbg]

thanks to your reply
i am working in an official and my administrator want to me to design about 80 paper form in access!!
my 8 button are : next , back, delete ,first, last,..... that i first use default macros to design them. but my admin wants to me that every button have a customize error handling.
so i change one form's buttons by my error handling and i want to copy this buttons to other forms.
now .... can any body help me???


if you have a better idea to design forms , I'm ready....

 

[vbaInet]

thanks to your reply
i am working in an official and my administrator want to me to design about 80 paper form in access!!
my 8 button are : next , back, delete ,first, last,..... that i first use default macros to design them. but my admin wants to me that every button have a customize error handling.
so i change one form's buttons by my error handling and i want to copy this buttons to other forms.
now .... can any body help me???

You will need to put the buttons in a form and place them on your other forms within a subform control. But your code will have to accomodate this.

if you have a better idea to design forms , I'm ready....

Even professionals will struggle to develop and manage 80 forms. Are all these forms not the same but with different client or orders on them? I mean, is the structure of the form the same?

 

[simplemind]

probably i am too late to give you an idea,anyway maybe it can help you.
make one form with all the controls you need for all 80 forms.
copy that form 80 times- the full form- so all events are copied.
for each copy use a new name as you need.
than build all other controls of each form on this platform.
simplemind 2013-03-12