I have a userform with multiple controls on it. It has 4 Command buttons
designed
to 1)save entered information, 2)retreive records, 3)print it, 4)delete
records.
All designed for the entry clerk.

I was the department director to use the same userform, except of course they
should have a different set of command buttons; 1)To approve 2) to transfer
record to Approved Folder, etc...

Question.. Do I use the same userform1 for both parties, hiding command
buttons of the other party or should I create another userform2 for them? Am
I making sense; hopefully so?

If you make two userforms, you will have some common code which is
duplicated which would make maintenance repetative. It is possible to put
some of it in a general module and have it called by each form.

If you have only one form, then you have to write code to figure out who the
user is and adjust the form.

If the functionality of each form is quite different although the appearance
may be similar, then it might be better to go with two forms.

Those a two or three things I can think of and without deep thought, I don't
see any as being disqualifying. So the choice is really what you want to do
as I see it.

--
Regards,
Tom Ogilvy





"Jim May" wrote in message
...
I have a userform with multiple controls on it. It has 4 Command buttons
designed
to 1)save entered information, 2)retreive records, 3)print it, 4)delete
records.
All designed for the entry clerk.

I was the department director to use the same userform, except of course
they
should have a different set of command buttons; 1)To approve 2) to
transfer
record to Approved Folder, etc...

Question.. Do I use the same userform1 for both parties, hiding command
buttons of the other party or should I create another userform2 for them?
Am
I making sense; hopefully so?

Thanks Tom;
Can I copy Userform1 and Paste as Userform1(Copy) and then modify the copy?
I don't see the option to do so. Can it be done, or done so by some other
equivalent?
Tks again.
Jim

"Tom Ogilvy" wrote:

If you make two userforms, you will have some common code which is
duplicated which would make maintenance repetative. It is possible to put
some of it in a general module and have it called by each form.

If you have only one form, then you have to write code to figure out who the
user is and adjust the form.

If the functionality of each form is quite different although the appearance
may be similar, then it might be better to go with two forms.

Those a two or three things I can think of and without deep thought, I don't
see any as being disqualifying. So the choice is really what you want to do
as I see it.

--
Regards,
Tom Ogilvy





"Jim May" wrote in message
...
I have a userform with multiple controls on it. It has 4 Command buttons
designed
to 1)save entered information, 2)retreive records, 3)print it, 4)delete
records.
All designed for the entry clerk.

I was the department director to use the same userform, except of course
they
should have a different set of command buttons; 1)To approve 2) to
transfer
record to Approved Folder, etc...

Question.. Do I use the same userform1 for both parties, hiding command
buttons of the other party or should I create another userform2 for them?
Am
I making sense; hopefully so?

I believe you export it and then import it again.

Once you export it, use Notepad to edit the .frm file Change references
from Userform1 (for example) to Userform2, or something similar. Save the
file.
Then import the form.

--
Regards,
Tom Ogilvy

"Jim May" wrote in message
...
Thanks Tom;
Can I copy Userform1 and Paste as Userform1(Copy) and then modify the
copy?
I don't see the option to do so. Can it be done, or done so by some other
equivalent?
Tks again.
Jim

"Tom Ogilvy" wrote:

If you make two userforms, you will have some common code which is
duplicated which would make maintenance repetative. It is possible to
put
some of it in a general module and have it called by each form.

If you have only one form, then you have to write code to figure out who
the
user is and adjust the form.

If the functionality of each form is quite different although the
appearance
may be similar, then it might be better to go with two forms.

Those a two or three things I can think of and without deep thought, I
don't
see any as being disqualifying. So the choice is really what you want
to do
as I see it.

--
Regards,
Tom Ogilvy





"Jim May" wrote in message
...
I have a userform with multiple controls on it. It has 4 Command
buttons
designed
to 1)save entered information, 2)retreive records, 3)print it,
4)delete
records.
All designed for the entry clerk.

I was the department director to use the same userform, except of
course
they
should have a different set of command buttons; 1)To approve 2) to
transfer
record to Approved Folder, etc...

Question.. Do I use the same userform1 for both parties, hiding
command
buttons of the other party or should I create another userform2 for
them?
Am
I making sense; hopefully so?

Thanks Tom,
I'll give it a go.
Jim


"Tom Ogilvy" wrote in message
...
I believe you export it and then import it again.

Once you export it, use Notepad to edit the .frm file Change references
from Userform1 (for example) to Userform2, or something similar. Save the
file.
Then import the form.

--
Regards,
Tom Ogilvy

"Jim May" wrote in message
...
Thanks Tom;
Can I copy Userform1 and Paste as Userform1(Copy) and then modify the
copy?
I don't see the option to do so. Can it be done, or done so by some other
equivalent?
Tks again.
Jim

"Tom Ogilvy" wrote:

If you make two userforms, you will have some common code which is
duplicated which would make maintenance repetative. It is possible to
put
some of it in a general module and have it called by each form.

If you have only one form, then you have to write code to figure out
who
the
user is and adjust the form.

If the functionality of each form is quite different although the
appearance
may be similar, then it might be better to go with two forms.

Those a two or three things I can think of and without deep thought, I
don't
see any as being disqualifying. So the choice is really what you want
to do
as I see it.

--
Regards,
Tom Ogilvy





"Jim May" wrote in message
...
I have a userform with multiple controls on it. It has 4 Command
buttons
designed
to 1)save entered information, 2)retreive records, 3)print it,
4)delete
records.
All designed for the entry clerk.

I was the department director to use the same userform, except of
course
they
should have a different set of command buttons; 1)To approve 2) to
transfer
record to Approved Folder, etc...

Question.. Do I use the same userform1 for both parties, hiding
command
buttons of the other party or should I create another userform2 for
them?
Am
I making sense; hopefully so?

You could start a new workbook.

Then drag the userform from the original project to the new workbook project.

Rename the user form in the new workbook project--then drag it back.




Jim May wrote:

Thanks Tom;
Can I copy Userform1 and Paste as Userform1(Copy) and then modify the copy?
I don't see the option to do so. Can it be done, or done so by some other
equivalent?
Tks again.
Jim

"Tom Ogilvy" wrote:

If you make two userforms, you will have some common code which is
duplicated which would make maintenance repetative. It is possible to put
some of it in a general module and have it called by each form.

If you have only one form, then you have to write code to figure out who the
user is and adjust the form.

If the functionality of each form is quite different although the appearance
may be similar, then it might be better to go with two forms.

Those a two or three things I can think of and without deep thought, I don't
see any as being disqualifying. So the choice is really what you want to do
as I see it.

--
Regards,
Tom Ogilvy





"Jim May" wrote in message
...
I have a userform with multiple controls on it. It has 4 Command buttons
designed
to 1)save entered information, 2)retreive records, 3)print it, 4)delete
records.
All designed for the entry clerk.

I was the department director to use the same userform, except of course
they
should have a different set of command buttons; 1)To approve 2) to
transfer
record to Approved Folder, etc...

Question.. Do I use the same userform1 for both parties, hiding command
buttons of the other party or should I create another userform2 for them?
Am
I making sense; hopefully so?





--

Dave Peterson