[Solved] Macro- Form, copy one record field to another table

[master-plan]

Dear all,

From within a Form I'd like to copy a selected record to a separate table.

Say I've got a list of items, and I want to select an entire record and copy it to another table. Or if easier, then just copy a single field from a Form to another table. What's the Macro Basic code for this?

Any help sincerely appreciated.
Ahmed the rookie

[RPG]

Hello

Maybe this thread Base - Copy column and copy row functions can help you.

Romke
_________________
OOo 3.4.5 on openSUSE 12.1
Use this forum : http://user.services.openoffice.org/en/forum

[master-plan]

Dear Romke,

Uhmm... I've gone through your suggested thread. But it does not quite address the problem at hand.

In particular in the fact that I want to copy one selected field (or entire record if that's easier) in a Form to an altogether different table (and not to the same table). (That is a different table to the one referenced in the Form Properties/ Content box).

Thanks nonetheless.

[RPG]

Hello

It is not so clear to me what you want there I see not any start of a solution of your problem. When you want only copy one field then maybe this can help you.

http://www.oooforum.org/forum/viewtopic.phtml?t=132192&highlight=copy+field+sub

I don't know if it is a good idea to copy a value from one table to an other table. In stead of copy a value you can use maybe a listbox.

Romke
_________________
OOo 3.4.5 on openSUSE 12.1
Use this forum : http://user.services.openoffice.org/en/forum

[RPG]

Hello

I think it is a good idea before you follow your own idea read first a set of tutorials. The forum tutorials special for base is a good place to start. Then you get a good idea from who has a good understanding of OOo-base and databases. Do not read all tutorials complete but start with reading them partly(by skimming). Then you see what is the best methode for you and your skills. Try to avoid macros they are real difficult and how more time you spend on macros how less you can send to the real stuff as SQL. I think read special posts of Villeroy, Arineckaig and DACM for SQL read posts of Sliderule.

I think when you first try to understand what you can do with listboxes that can help you a lot and speed up your work.

Romke
_________________
OOo 3.4.5 on openSUSE 12.1
Use this forum : http://user.services.openoffice.org/en/forum

[master-plan]

Hi Romke,

Thanks for the links. I think I'm getting some ideas reading from the other threads. (I'm now considering the use of a sub form).

I'll continue working with this problem. If I manage to make it work I'll update the post as solved and outline solution.

[master-plan]

Dear all,

Ok. After weeks of hitting my head against the keyboard I finally got it to work. I'm sharing my code below in case this is of help to others struggling with similar problems.

*Note* If the code reads amateurishly, please refrain from laughing... this is my best