Positioning membershipcard printout

[MacDknife]

Hi Everyone!
I'm a newbie at this ,so please be patient.

I need to print out membershipcards to a pre-perforated A4 sheet, left to right in 2 columns and 5 rows, but want to be able to set the starting position as well at times.

Scenario:
I can print out 3 Family cards and 5 singles cards, each type based on their own form, so they have to be printed separately.
I print out the Family cards and to save paper (expensive) I use the same sheet again to print the rest. The first card of the Singles cards, must now be positioned to start printing in row 2, column 2 in the perforated areas.
To do this I have to first print 3 "blanks", or position the "card" exactly on the sheet. To blank out these with a little code in the forms works fine, but all this is completely ignored by the report.

The report is printed based on a preview of the form:

DoCmd.OpenForm stDocName, acPreview
DoCmd.SelectObject acForm, stDocName, True
DoCmd.PrintOut acPrintAll, , , Q, A, S
DoCmd.Close acForm, stDocName

I'm stumped! I don't know if I should continue this line of thought and find a solution (maybe there is one already!), or do a 180. Could some kind soul out there please give me a kick in the right direction?

 

[shadow9449]

Hi, Mac

If you dig around, you can find sample databases/code to help with the label offset issue.

There are some on this site:

http://www.rogersaccesslibrary.com/TableOfContents3.asp

See if they help, otherwise, keep digging.

SHADOW

 

[ThreeCrow]

Attached I have method from microsoft that may help
It's in PDF format
If you can not open I'll learn to put the link in this Forum, I'm a new guy

 

[MacDknife]

Thank you Shadow and ThreeCrow

Shadow, I have corresponded with Roger directly, as he only had label examples on his site. It's easier with labels because one is only handling text- I'm trying to printout both graphics and subforms. I had already thought of those solutions he had myself.

He has advised me to try it with rapports instead, which I had earlier without success. I'll try again, especially now that I have the Microsoft article that ThreeCrow pointed me to. It seems to have more detailed information on how to manipulate a rapport, but as it's still about labels i'm not sure.

Thank you both again, I'll let you know how it turned out...

 

[MacDknife]

Dang - Now I remember why!!

A rapport's bottom margin REFUSES to be less than 13,97mm!! That means if the porferated cards are 5 x 54mm high, with a top margin of 13,8mm, the bottom margin has to be less than 13.97mm (13,8mm to be exact) to fit onto a A4 page. Anyone know why and got a solution?

 

[shadow9449]

Ok, good luck!

SHADOW

 

[MacDknife]

Bottom margin problem solved

I checked with Epson and thought I would just update you. It had to do with the printer driver. The problem was known and catered for. Apparently there is a standard printout area and a maximum printout area which one can set in the printer’s configuration. The drawback is that the printing in this extended are can be compromised/distorted due to the printer not being able to hold the paper in place properly, as it does in the standard mode. I can imagine that most inkjet printers could have this “problem” (and solution). Now I can get to work with the offset part again....

 

[DanG]

I have the VBA for dummies book and they use as an example "FancySkipLabels" that sounds like what you want. You can get a sample database at http://coolnerds.com/vba/.
Basicaly what it does is it has a form that you choose a report and number of labels to skip and click print. It then makes a temp copy of your report and a temp copy of the report record source so it doesn't effect your originals and adds blank records (the number of labels to skip you entered on the form) to the temp record source. Then it prints the labels no matter what size they are.
It pretty much slaps into any database but I think you have to tweak it a bit first because it only looks for reports that have "Labels" in the report name.

I have not tried it myself but I am working through the tutorial and have read on it only. I will be trying it at home soon because it sounds cool.

If you are not too up on VBA take the code and run it through the VBA board here and I am sure somebody can help out.


Dan