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

Connect to data source macro

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
karlgren
Newbie
Newbie


Joined: 20 Jan 2005
Posts: 1

PostPosted: Thu Jan 20, 2005 1:28 am    Post subject: Connect to data source macro Reply with quote

Hi all

I'm new to macro programming in OOo. I've understood that one can program a macro to
configure the data source connection.

We have about 400 working stations and not all of the users know a lot about data.
So I need the -sxw to connect the data source connection when they open the -sxw
document. If the data source is not configured, I need the macro to do it.

I have a text document placed on f:/documents/ called template_letter.sxw
The data source is placed on f:/datasource/template_letter.dbf

The user then write direct in the data source window over the document and then
print the letter. If it's possible, the best way would be to have a form popup with
the data source fields and write in this, like in MS word. And in MS Word the data
source connection is saved with the .doc document.

Is there any way to clean the data source with the info with out deleting others
data in the data source. Some one else would likely use it at the same time.

Thx
//Micke
Question
Back to top
View user's profile Send private message
Zarius
OOo Enthusiast
OOo Enthusiast


Joined: 21 Jan 2005
Posts: 142
Location: Brisbane, Australia

PostPosted: Thu Jan 27, 2005 4:33 am    Post subject: Reply with quote

This thread (on setting up a datasource via macros) may help.
Back to top
View user's profile Send private message Visit poster's website
Tojan
General User
General User


Joined: 18 Jan 2005
Posts: 5

PostPosted: Thu Jan 27, 2005 6:14 am    Post subject: Reply with quote

I had simimlar problem.
i wanted OO to feed from some spreadsheets, but the problems was that you had to open those manually. I wanted it to open specified files.

Was it changed in newer versions?
_________________
Web hosting deal | Praca | | job | Ebay
Back to top
View user's profile Send private message Visit poster's website
Liliana_mcm
General User
General User


Joined: 19 May 2004
Posts: 32
Location: Marinha Grande - Portugal

PostPosted: Mon Feb 07, 2005 2:31 am    Post subject: Reply with quote

Hi,

Maybe this link will help :

http://api.openoffice.org/docs/DevelopersGuide/Database/Database.htm

Liliana Matos
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 Macros and API 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