By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Printing Name Card From Access Report

P: 6
Hi guys, I need help on printing name cards from member database.
I've design a working member database form and I want to add a button to print current member's particular (MemberID, Name, Address,Phone, etc) in the form of NAME CARD.

When I click the button, it will then pop up an input box asking for how many cards to be printed for the current member.

And those name cards should be arranged in 4 or 5 rows ; 2 columns side by side on a piece or more A4 paper size.

TQ in advance.
.
Nov 13 '06 #1
Share this Question
Share on Google+
8 Replies


NeoPa
Expert Mod 15k+
P: 31,494
You need to design a report that will fit on a card, then set up columns in your report (using the PageSetup option of the File menu) to allow the card to be printed in columns across the page as well as in rows down.
Only you can design what you want where, but that's the concept you need to do it.
Nov 13 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
You need to design a report that will fit on a card, then set up columns in your report (using the PageSetup option of the File menu) to allow the card to be printed in columns across the page as well as in rows down.
Only you can design what you want where, but that's the concept you need to do it.
This tutorial on the Microsoft Office Online should help you get started.

http://office.microsoft.com/en-gb/ac...874161033.aspx
Nov 13 '06 #3

P: 6
Hi, maybe I've posted a wrong question about how to design and print Name Card from Access Report. With my appology, I woud like to redefine my question is:

How to print a series of member cards within a single page for only one member's record.
TQ
Dec 2 '06 #4

NeoPa
Expert Mod 15k+
P: 31,494
Hi, maybe I've posted a wrong question about how to design and print Name Card from Access Report. With my appology, I woud like to redefine my question is:

How to print a series of member cards within a single page for only one member's record.
TQ
The answer's the same I think.
The tutorial introduces the concepts you need, setting margins or throwing pages.
The Force New Page property of the detail setting can help specifically if you want one card per page though.
Dec 2 '06 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi, maybe I've posted a wrong question about how to design and print Name Card from Access Report. With my appology, I woud like to redefine my question is:

How to print a series of member cards within a single page for only one member's record.
TQ
Your problem here is not one of design but of data. You need a record source that has duplicate records of the member details to the record count of the number of cards you want to print.

The solution I would suggest is a printing table that can be populated with the required number of records corresponding to the member details.

Mary
Dec 3 '06 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
Your problem here is not one of design but of data. You need a record source that has duplicate records of the member details to the record count of the number of cards you want to print.

The solution I would suggest is a printing table that can be populated with the required number of records corresponding to the member details.

Mary
Another option you could explore is setting up the cards in Word and using the database as a data source the way you would with any mail merge.

Mary
Dec 3 '06 #7

P: 6
I've goto the link as suggested by MMcCharty ( Microsoft KB Article ID : 95806) and after a little copy and paste the code to my program, was able to print the same cards (same record) in one column, four Rows, but
what I desire is to be able to print the same record side by side (in 2 columns) and 4 rows within a page.

My purpose writing this program is that I want to print name cards (10 pages or more) for my members. Usually I use corel to design it but got to change the member's particular each time I want to print for a new member.

So far I've design a report and set its record source property to a query as shown below But the it can only print one record per page (such a waste for the rest of the paper) :

SELECT [Members].MemberID, [Members].[Join Date], [Members].SponsorID, [Members].MemberID, [Members].[Name],[Members].[Address], [Members].City, [Members].[Postal Code] FROM [Members]
WHERE ((([Members].MemberID)=[Forms]![Members]![MID]));

I'm able to filter out the record I want to print by using this code:

Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdPreviewCard_Click()
  2. On Error GoTo Err_cmdPreviewCard_Click
  3.  
  4.     Dim stDocName As String
  5.     Dim StrSql
  6.  
  7.     stDocName = "Name Card"
  8.     DoCmd.OpenReport stDocName, acViewPreview, , , acDialog
  9. Exit_cmdPreviewCard_Click:
  10.     Exit Sub
  11.  
  12. Err_cmdPreviewCard_Click:
  13.     MsgBox Err.Description
  14.     Resume Exit_cmdPreviewCard_Click
  15.  
  16. End Sub
Dec 3 '06 #8

P: 6
Voila..., Problem Solved!!!
I just managed to work out my problem by simply copying those controls on my report and paste on the left side (arrange them side by side) and use the code from Microsoft KB Article ID:95806 as MMcCarthy reffered me.

Thanks to MMcCharthy and NeoPa as well for helping me solving the problem.

You're GREAT!!!!.....
Dec 3 '06 #9

Post your reply

Sign in to post your reply or Sign up for a free account.