OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Macro attached to the database

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
Sergej
General User
General User


Joined: 07 Dec 2006
Posts: 7

PostPosted: Tue Jan 23, 2007 7:26 am    Post subject: Macro attached to the database Reply with quote

Hello everybody!

When I copy my database from one computer to another, the macros don't copy.
I mean, they are not attached to the database file itself.

Can you please help me how to make the database(all forms, queries and the data itself) ONE with the macros, so that I can distribute everything in one file to my partners.

Thank you!
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Thu Jan 25, 2007 5:44 pm    Post subject: Reply with quote

IIRC, a database cannot have a macro library, so your macros are probably in macro libraries, listed under "My Macros" in the macros organiser.

I think you will have to copy the files containing your macros as well as the database itself. You will find them in the "Basic" folder of your user settings folder. Copying the whole Basic folder would make all macros in "My Macros" standard.

There is a post on distributing macros in the Help sticky in Macros & API. If you want your thread transferred there, send a pm to me or one of the other moderators.
_________________
search forum by month
Back to top
View user's profile Send private message
audionuma
OOo Enthusiast
OOo Enthusiast


Joined: 23 Feb 2006
Posts: 126
Location: France

PostPosted: Fri Jan 26, 2007 2:41 am    Post subject: Reply with quote

hello,
you cannot save macros in the .odb document, but you can save them in an embedded form, which will follow with the .odb file.
Manuel
_________________
OOo 2.3 / Mac OS PPC X.4.11
Back to top
View user's profile Send private message
trenkler
Power User
Power User


Joined: 21 May 2005
Posts: 55

PostPosted: Sat Jan 27, 2007 11:16 am    Post subject: Re: Macro attached to the database Reply with quote

Sergej wrote:
Hello everybody!

When I copy my database from one computer to another, the macros don't copy.
I mean, they are not attached to the database file itself.



You can create library in MyMacros for your database where you write and use all your macros. It is easy to export the whole library as one .oxt file. Then you can append it to your libraries on another computer. I use library "lefa" for my lefa.odb database. And for each database I have it s own library.

juraj
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group