Copy control using macro

  • Thread starter Thread starter van
  • Start date Start date
V

van

Hi

Using a macro, how can I copy and paste a command button from one form to
another ? There is a copy object action, but it does not seem to allow the
object type of control ?

Thanks
 
Why in the world would you want to do that?
The CopyObject Method doesn't apply to buttons,
because there is never a need to copy a button programatically.
Al Camp
 
Al

I have created an MS access application, with an admin area which is
controlled by one user. There is a number of different departments on it,
and the user may wish to add to this list. However, there is another form
which has a command button for each dept. So, a new button must be created
each time a new dept is added to the admin screen. Since, the user is not
familiar with screen design in Access, I thought a macro would be handy to
automate this process.

Have you any ideas for an alternatuive solution?
 
Van,
Sorry, I can't think of any way to do that. And... when they add a
department to the company, aren't you the person who develops the new forms
and reports that the "new" department will need?

I would certainly think that in the amount of time you'd spend trying to
automate a process like that for the customer you could add a hundred new
buttons to a form.

There can't be that many "New" departments to be added... 2 or 3
maybe... at the most?

And heck... as the developer, those little tasks are job security!

hth
Al Camp
 
Back
Top