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

open row in a report leaked from a specific listbox

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


Joined: 08 Jan 2009
Posts: 5

PostPosted: Thu May 14, 2009 2:41 am    Post subject: open row in a report leaked from a specific listbox Reply with quote

I have a form with a listbox where I choose a table row and then I want a button I want to open a report with all fields of that row in question. I have the macro but I do not tell me that this will be in question. As is done in VBA but Access does not like OpenOffice is going to base. Access is as follows:

DoCmd.OpenReport "Orders", acViewPreview, "OrderID IN (" & NumerosPedidos & ")"

NumerosPedidos where is the code of the row I want to see.

Thank you.
Back to top
View user's profile Send private message
QuazzieEvil
Super User
Super User


Joined: 17 Jan 2007
Posts: 599
Location: Houston, TX

PostPosted: Thu May 14, 2009 4:41 am    Post subject: Reply with quote

That is not easily done in Base. There is no Built-in DoCmd feature in OpenOffice.org Basic. You can use the BaseTools extension (experimental). However, the RunCmd.OpenReport function does not to filtering, just opens the report. A suggestion is to base the report on a query. before you open the report modify the query's SQL (COMMAND);
_________________
Free Docs @ http://www.baseprogramming.com/resources.html
Book @ lulu.com http://www.lulu.com/content/2455551
Back to top
View user's profile Send private message Visit poster's website
peya02
General User
General User


Joined: 08 Jan 2009
Posts: 5

PostPosted: Thu May 14, 2009 6:05 am    Post subject: Reply with quote

Thank you,

I've been trying to do as what I said but I can not modify the sql query and get to open the report on this consultation.
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