How create a printable form or report that will print a membership id card

[TSD]

Hello all!
This is my first post here. I'm new to creating access database and having some issues.
I was given the task of taking the database table from an older commercial membership software package that crashed, and no longer has support, and create an access front end for that table. I can load the table into access but it had some issues in formatting so I exported it to an Excel sheet so I could cleanup the issues. I then used Access to import that cleaned up Excel sheet and from there started building the front end.


So far I have a working front end and various search functions that are working well.

The next step is to be able to take the MembershipID (twice, once showing the member number and the second one using free3to9 barcode font), MembersFirstName, MembersLastName, ExpirationDate, and MemberPhoto and create a printable ID card on an actual ID card printer.

This is where I am totally lost! I have tried to create a report, choosing the card printer as the destination printer in order to create the correct report page size (plastic cards are 85.6mm x 53.98mm) but I cannot get the data to display correctly.
I still have to create the ability to take a photo of the member using webcam, from within Access. The photos are stored in a folder using the members ID number as the filename.

The I have created a visual representation of the ID card on the form that has the Members record info on and it looks exactly how I want it to look if printed to a plastic ID card. Clueless where to start. Here is what the visual of the card looks like in my member record form: The red is just me scratching out the Business name at the top and the Members name in the middle.
I have created a text box for the name that combines the first and last name and centered in the box for consistency as there are a lot of short and long first and last names out there! Any help on how to go about this would be greatly appreciated!

[Welshgasman]

I would normally say to use a report, but if you already have the ID card as a form (or make it such) then print the form for relevant records? Not something I have done deliberately, I must admit.

See if this helps. https://www.google.com/search?q=prin...hrome&ie=UTF-8

Otherwise, replicate the ID card in a normal report and use that for relevant records. This method is probably a lot easier.
If you cannot find the correct layout dimensions, then create a custom layout to match your ID card paper.

[jojowhite]

for photo capturing, there is a free working database here:

cheap alternative to Access Imagine | Access World Forums

if you can upload your db with the ID card image, i can incorporate the code
to your db.

[June7]

I have tried to create a report, choosing the card printer as the destination printer in order to create the correct report page size (plastic cards are 85.6mm x 53.98mm) but I cannot get the data to display correctly.

And why not? What happens?

[mike60smart]

Can you upload a copy of the database?

[TSD]

Thanks @mike60smart for pointing me to that Microsoft document!
I figured out what I was doing wrong.. I was pulling data from the table when I should have been pulling the data from the current open form which has all the correct fields for the current record to be on the report AND the member form MUST be open for the report to pull the data otherwise it only shows the expressions in the fields
.

[Welshgasman]

No, I would pull from table but for ids required, which might be on the form,
I would likely have a print form that specifies the IDs.

[TSD]

I was trying to pull from the table but that seems where I was having issues displaying anything. Plus, the Name and Expire areas on the card are a text box pulling in 2 values (eg first and last name) in order to center justify the full name in the text box. Same for the Expire area... its a text box with the text "Expires" & a formatted pull of the expiring date field of that record. The main club member form that displays the members record has a button to print the ID card for that record. I have no other area that would need that form displayed.

[Welshgasman]

All of that can be done in the report, but if you have it working leave it as it is, one card at a time.

[jojowhite]

Thanks @mike60smart for pointing me to that Microsoft document!
I figured out what I was doing wrong.. I was pulling data from the table when I should have been pulling the data from the current open form which has all the correct fields for the current record to be on the report AND the member form MUST be open for the report to pull the data otherwise it only shows the expressions in the fields
.

you mean gasman?

[Welshgasman]

No Mike posted a link in #5

[mike60smart]

Hi Gasman I think your tip to use the Form showed the Op the way forward.
My linked doc was to do with Normalization.