Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Templates > Credit Card Template
Credit Card Template

Process Credit Cards Using Paypal Payflow Gateway Pro 

 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now

Introducing the Access Credit Card Template. This powerful new template streamlines credit card processing by integrating directly with PayPal's Gateway Pro service. Designed with ease of use in mind, it simplifies the complex documentation provided by PayPal into a ready-to-use database solution. As a developer, all you need to do is enter your merchant information from PayPal, and you're set to go. The template includes features like customer forms to manage credit card information and order screens with a process credit card button, making transaction processing straightforward and efficient.

This template is equipped with a comprehensive Explainer Video that guides you through the setup process and provides an overview of the source code. While primarily supporting PayPal, the template can also be adapted for use with other processors like Square with minimal adjustments.


Important Information

  • Requires Paypal Gateway Pro. (as of June 2024, the cost is $30/mo - 2.89% plus $0.49 / trans). Amex may be higher. Subject to change at any time.
  • May Work With Square and Other Processors. One of my colleagues said he got it working by changing the settings. I only support Paypal because that's what I use.
  • Single Transactions Only. The template as it comes only supports single charges, not recurring billing. Paypal has a recurring billing service which is $10/mo add-on. I have included the VBA source code to use it, but it's not officially supported.
  • You Should Not Store Credit Cards in an Access Database. It is not secure, and is not PCI compliant. You should use an SQL Server back-end with full encryption enabled if you're storing credit card numbers. If not, you should not keep the numbers in your database. I've included some basic encryption for demonstration purposes, and as an extra layer of defense, but once again, I emphasize that you should not store numbers in your Access database. I will talk about this in more detail in the Explainer video.
  • Security Seminar Highly Recommended. Even if you are using SQL Server as your back-end I still strongly recommend my Security Seminar so that you properly lock down your front-end Access database otherwise your merchant information could be at risk.
  • My Personal Business Solution for Over 20 Years. I've been using pretty much this exact VBA code for over 20 years now, ever since Paypal started offering it's Payflow Gateway service. The code is tested, tried, and true.

Full Developer Database

Once you have purchased the full developer database template, you may come back to this page and download the full template. This will give you access to the ZIP file containing the Template ACCDB file. The full version will run on 32-bit or 64-bit Access 2007 or higher. Be sure to watch the Explainer Video (above).


TechHelp Videos

Recommended Seminars

Purchase Template

Please be sure to read the Before You Purchase section below before buying this template.

Order Now


The Access Credit Card Template ensures that credit card numbers are partially visible on the customer form, displaying only enough digits to confirm that a card is on file. This feature provides a balance between accessibility and security, allowing you to quickly verify the presence of stored card information without exposing sensitive details.


The card details form allows you to easily enter or view card details. This intuitive form ensures that you can efficiently manage card information, providing a seamless process for updating or reviewing card data. With user-friendly fields and clear instructions, the form simplifies the task of handling credit card entries, enhancing your overall experience and workflow.

The processor screen efficiently handles sending transaction data to PayPal, including a non-stored CVV code, ensuring enhanced security. This screen processes the return information and displays the transaction status as approved or denied. If approved, it marks the order as paid and saves the reason codes in the customer's contact history for future reference. This comprehensive functionality streamlines transaction management, providing clear feedback and maintaining accurate records of each transaction.


Order Now

Before You Purchase

A few important notes before you purchase this template:

  • I strongly recommend watching the free intro video before purchasing this template so you understand exactly what this template does.
  • Please note that this is designed to be a standalone template. If you purchase the database you will get the unlocked source code and you can modify it yourself however the coding in the database is quite complex and I will not support you if you're trying to make changes to it yourself.
  • Backup. Backup. Backup again! Always make a backup copy of your information before relying on this database. If you're not sure how to do that, please see my Backup video.
  • Remember, we do our best to help you here in the Forums on the website, but technical support is not guaranteed.
  • This application is indeed a 1.0 version. Bugs are always possible. If you find one, let me know. I'll do my best to fix it, but only if it occurs in the stock version of the database - not a copy you've modified.

PCI DSS Compliance

Once more... I Take No Responsibility For PCI DSS Compliance! I am providing the source code and this template for demonstration purposes only! This is essentially the same code that's available in Paypal's documentation. This template just puts it all together for you. It is your responsibility to make sure your data is kept in compliance with PCI DSS rules and regulations. This is just to give you the front-end code that you need to get Access to process credit card transactions. What you do with that data after that point is your responsibility. And again... I emphasize... Do not store it in an Access back-end file. It's not secure. 

Possible Future Upgrade Ideas

If you have ideas on things you'd like to see added to this database, please post a comment below. If a particular feature garners enough interest or if I consider it to be a particularly good idea, then I will definitely consider adding it. Some ideas already suggested:

  • Recurring "Billing Arrangement" Transactions
  • SQL Server Encryption Walkthru Video


For internal use only. This template does NOT come with a royalty-free license. You may only customize the template for your business needs and for use within your organization at one location ONLY. You may not resell or distribute any form of this template to others without express written permission. Contact me for additional information on obtaining a license to distribute if you plan on including this template in a product you are reselling. Additional licenses are required if you plan on using this template with more than ten (10) employees or in multiple locations within your organization.

Not a Finished Product

Please keep in mind that most of my template databases are not designed to be finished products that are ready to go in a working environment. My templates are meant as starting points for you to customize for yourself so you don't have to reinvent the wheel. This requires that you have a basic understanding of Microsoft Access development. To work on most of my databases you should have completed my Access Beginner series and the first couple levels of my Expert series at a minimum. Most of my databases require knowledge of SQL and VBA as well. 

Customize For Your Needs

If you would like to discuss customizing this template for your needs, and integrating it into your current setup, please see my consulting page for details. While I no longer accept custom jobs that are specific to a single user, I may include your features in a future version of this template if they have mass appeal. If you are looking for custom enhancements made to this template just for you, visit my Developer Network.

Technical Support

Please note that technical support is NOT guaranteed for any of my courses, seminars, or templates. If you require help with modifying this template, you may post a question in the Forums, however an answer to your question is not guaranteed. If this template comes with an accompanying Seminar, then you should purchase that Seminar to see how the database was constructed. If not, then you should have taken the suggested courses. Most of my templates are designed on a Developer level and you should have a thorough understanding of SQL and VBA before attempting to modify them. If you have a problem with one of my databases, I will only support the unmodified database exactly as it's downloaded from my site. If you have modified it in any way, it may not be something I can help you with. You can post in the Forums, and I may be able to help you, but if the issue doesn't exist in my unmodified database, it's not something I can support.


Got sales or customer service questions about this template? Feel free to contact me. If you have technical "how do I" questions about this template, you discover a bug, or want to suggest a new feature, then please post your comments below.


microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #template, Access Credit Card Template, PayPal Gateway Pro service integration, credit card processing, SQL server encryption, customer form management, order screen functionality, source code walkthrough, SQL server backend, PCI compliance, MySecuritySeminar, VBA code for PayPal, credit card storage security


Start a NEW Conversation
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
Subscribe to Credit Card Template
Get notifications when this page is updated

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/15/2024 2:01:55 AM. PLT: 1s
Keywords: templates access Credit Card Template, PayPal Gateway Pro service integration, credit card processing, SQL server encryption, customer form management, order screen functionality, source code walkthrough, SQL server backend, PCI compliance, MySecuritySemi  Page Tag: whatsnew  PermaLink  Microsoft Access Credit Card Template