tab transfer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hugz - 29 May 2007 13:15 GMT

I have a very big problem.. I have a form that contains 6tabs.. salestab,
deliveriestab, suppliertab, creditor/receivablestab, disbursementstab and
inventory tab.. Now, my problem is, i want to merge the
creditor/receivablestab and suppliertab into one tab without destroying the
things included in every tab.. wat i did is i copied all the things found in
my creditor/receivablestab and paste it in my supplier tab.. when i try to
run my form.. the names of the things i pasted are now different...

wat happened?

how can i solve this issue?

i need a reply as soon as possible..

tnx..

Reply to this Message

Rick Brandt - 29 May 2007 13:38 GMT

> I have a very big problem.. I have a form that contains 6tabs..
> salestab, deliveriestab, suppliertab, creditor/receivablestab,
[quoted text clipped - 12 lines]
>
> tnx..

If you cut and paste the names will stay the same. If you copy and paste the
pasted objects will be given new names because the old objects are still using
those names.

You will also lose any [Event Procedure] property settings for the pasted
objects. The code will still be in the form module, but you will have to
restore the [Event Procedure] entry to have the code called when the event
fires.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

hugz - 29 May 2007 14:41 GMT

is there a faster way than to cut and paste each things i want to transfer in
a tab? i have a lot of things i want to transfer u know.. not to mention the
way you suggest would still require restoring the events in each object..

>> I have a very big problem.. I have a form that contains 6tabs..
>> salestab, deliveriestab, suppliertab, creditor/receivablestab,
[quoted text clipped - 10 lines]
>restore the [Event Procedure] entry to have the code called when the event
>fires.

Reply to this Message

Rick Brandt - 31 May 2007 14:27 GMT

> is there a faster way than to cut and paste each things i want to
> transfer in a tab? i have a lot of things i want to transfer u know..
> not to mention the way you suggest would still require restoring the
> events in each object..

You can select multiple objects at once either by "lassoing" them with the
mouse or by holding Control or Shift while selecting them. Then you can Cut
and Paste all of them at once.

A quick-fix for the lost [Event Procedure] settings is to go to the code
module and select ALL of it. Cut the code to the clipboard and then paste
it back. That should restore all of the [Event Procedure] settings.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message