b612 Newbie

Joined: 17 Feb 2006 Posts: 1
|
Posted: Fri Feb 17, 2006 7:30 am Post subject: DoCmd substitute in OOo API |
|
|
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 |
|