Printing id cards from Base forms

tukiel · General User Joined: 09 Jul 2010 Posts: 8 Location: Mexico

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...

tukiel · General User Joined: 09 Jul 2010 Posts: 8 Location: Mexico

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.

grrrrrr · Newbie Joined: 09 Dec 2010 Posts: 3

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.

grrrrrr · Newbie Joined: 09 Dec 2010 Posts: 3

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...

MSPhobe · Posted: Tue Dec 14, 2010 3:50 am Post subject:

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.