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

Printing id cards from Base forms

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


Joined: 09 Jul 2010
Posts: 8
Location: Mexico

PostPosted: Sat Jul 10, 2010 11:05 pm    Post subject: Printing id cards from Base forms Reply with quote

Hi all,

After fixing my DB I want to print an Id card I designed as a form. I want to print all records, like I would with a mail merged document... If I do export to PDF or print, it only prints the current record.

I wanted originally to do a mail merge or label job, but the images in the database (AFAIK) cannot be exported as a field in the writer document....

I'm all for using reports... IF I can find a way to display the image in the report....

Here's how it looks... (kinda goofy, I know, but it's just a test)




Uploaded with ImageShack.us

Can you suggest something? I don't want to manually go thorugh hundreds of entries, printing them individually...


Last edited by tukiel on Sat Jul 10, 2010 11:20 pm; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail
tukiel
General User
General User


Joined: 09 Jul 2010
Posts: 8
Location: Mexico

PostPosted: Sat Jul 10, 2010 11:14 pm    Post subject: Reply with quote

Seen this one: http://www.oooforum.org/forum/viewtopic.phtml?p=345030

Sub printForm1(Event As Object)
Dim Doc As Object
Dim Form As Object
Dim url as String
Dim Args(0) As New com.sun.star.beans.PropertyValue

Form=Event.Source.Model.Parent
Doc=Form.Parent.Parent
Args(0).Name="FilterName" : Args(0).Value="writer_pdf_Export"

Form.beforeFirst() 'move before first record (for top guarded while)
While Form.next()
'generate unique file name (concat pk)
url="C:\formprint_" & Form.getByName("fmtID").BoundField.getString() & ".pdf"
url=convertToURL(url)
Doc.storeToURL(url,Args())
Wend

End Sub


How can I run this macro? I am really a noob and I can add it to the macro organizer, but when I try to run it it complains of too few parameters.
Back to top
View user's profile Send private message Send e-mail
grrrrrr
Newbie
Newbie


Joined: 09 Dec 2010
Posts: 3

PostPosted: Thu Dec 09, 2010 2:36 pm    Post subject: Reply with quote

They will not even answer you how to run the macro. Ayway don't worry it doesn't work. I HATE now this OO BAse. RUN AWAY from this shit is my advice.

To run such a macro with "event" parameter, I found that it is possible by setting the form's event properties, such as "when loading". You can there assign the macro to the load event, then the macro will be run when you open the form.

But anyway I tried it and it will not work. And even with some corrections you get at the end either only ONE record (the last one) in the PDF, or one PDF per record. This is ridiculous.
Back to top
View user's profile Send private message
grrrrrr
Newbie
Newbie


Joined: 09 Dec 2010
Posts: 3

PostPosted: Thu Dec 09, 2010 2:41 pm    Post subject: Reply with quote

Looks like the forum is at the image of the ooo stuff: useless.

You ask a very sensible question. Many people would like to do this including me. But nobody helped...
Back to top
View user's profile Send private message
MSPhobe
Super User
Super User


Joined: 29 Sep 2005
Posts: 529
Location: England

PostPosted: Tue Dec 14, 2010 3:50 am    Post subject: Reply with quote

Unless I misunderstand what you want to do, you only need to set up a slightly fancy report to get what you want.

Or, why not just pretend you are printing "labels".... they have their little quirks, but I don't see why they wouldn't "do", once you're past the quirks.

===
Delighted to infer that "grrr" will be leaving the ooBase world. Wouldn't want him/ her unhappy. The thousands of us that are happy will just have to bumble along in our benighted bliss.
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