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

DoCmd substitute in OOo API

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


Joined: 17 Feb 2006
Posts: 1

PostPosted: Fri Feb 17, 2006 7:30 am    Post subject: DoCmd substitute in OOo API Reply with quote

I like to port my existing MS Access database to OOo Base. I have setup tables, relations between them, report and queries. No problems.
Now I like to make a form with buttons what would open a particular form or report.
In MS Access I do (for report):

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = " Form_name"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Or I like to open form or report with ID of active record in active form (where in select).
In MS Access I do (for report):

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Form_name"
stLinkCriteria = "RelCol = " & Me!ID_smpol.Value
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

I tried to google information and the most relevant result is:
http://www.mail-archive.com/dev@dba.openoffice.org/msg00154.html
I am not a programmer. So I do not now the meaning of oParms() or oCom and where to get these.
More over I like to open form(report) with details about specific ID (about the record what is active in form where the button is = setup a filter or “where” section in select command)
Is there any tree of objects and their properties and methods + description of parameters?
Can someone help me? Otherwise I will have to stay with MS Access.
Thank you for any clue in advance.


DoCmd object in MS Access
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acobjDoCmd.asp
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