Access Forum

Welcome to the Microsoft Access Forum. Access is by far our most popular topic here at Computer Learning Zone. This forum is for everyone to read but only students can post here. If you'd like to become a student, all you have to do is enroll in one of my courses, which you can do for as little as $1. After you create a logon, you will have full access to the Forums.

Subscribe to this forum and receive an email update whenever new posts are added. You will also be notified by email if any conversations you are involved in receieve new comments. Yes, even non-students can subscribe to update notifications.

NEW: Access Developer Students, make sure you subscribe to the Developer Student Forum.

Click Here to Post a comment and start a new discussion

Please read the FORUM RULES before posting.

Existing Record Upload Images Link
Arlette Kent
22 hours ago

Hello! where would i find the lesson which shows how to allow me to have a button to open a contact form for an existing record BUT if there isn't an existing record open a blank form. Of course you've already taught me how to open a form to an existing record, its the new blank form if there is no record that is giving me trouble. I can do one or the other, but i just don't know what i need to do to combine the two on one button. Read More...

Alex Hedley
22 hours ago

How are you determining there is an existing record?
You'd usually have a continuous form with a list that you choose from and open there.

Arlette Kent
22 hours ago

Hi Alex
I'm using a macro to
open form: contact
where condition =ID

Basically I have my main form with all the company info. then a button to open contacts for that company so the id on the company has to match the ID on the contact.

Show 3 More Replies...

Add digital signatures Upload Images Link
Brad Bogle
23 hours ago

For the developers. Is there a way to incorporate our office's Topaz SigLite T-LBK460-HSB-R electronic signature pad to insert a signature in our Chain of Custody forms that I am designing in MS Access? I contacted the manufacturer and they basically told me that I'm on my own If it's not for Excel or Word

Scott Axton
22 hours ago

Looking at their site it looks like they have add-ins for Office.
That being the case I imagine you could come up with a solution that will work in Access.

How are you using / capturing the data now?
Can you better describe what you would like to do in Access that is different from the way you are doing things now?

Brad Bogle
22 hours ago

Currently we're doing it in Excel. I created a Chain of Custody Form template there and we capture the signatures there but we're trying to move all of our work into Access. For a little background; we do drug testing and occupational first aid and safety. Record keeping is critical so we're trying to use Access exclusively and move our BE into SQL Server eventually. I designed the COC Form in Access but we have to be able to capture signatures from our Clients and Collectors. Yes I have inserted the code into Word and Excel for the signature pad to use as an Add-In but I'm not a developer (yet). I don't know if it will also work for Access. I know for there were two seperate files for Word and Excel

Show 1 More Reply...

VBA Error on start up Upload Images Link
Joseph Mazzeo
23 hours ago

I opened my database yesterday and the following error message appeared:

It is not possible to open the database because the VBA project contained in it can not be read. The database can only be opened if the VBA project is deleted first. Deleting the VBA project removes all the code from the modules, forms, and reports. You must back up the database before attempting to open the database and delete the VBA project. Read More...

Scott Axton
23 hours ago

Save a copy of your db. off of your computer. It's possible you got corrupted somehow.

Start out here: Troubleshooter

Show Older Comments...
View in Table Format