Search results

MajP, thank you. I am running out of time on this project so I may have to settle for converting the -1 to "Yes". Just not as pretty! Not sure your solution would export to Excel, but if I get a chance I will give it a try. I was hoping for an easy solution!

How?

I have a query in which a field is -1 or 0. Is there a way to display a check mark for the -1? This query is constructed to export as an Excel file. The original field is defined as "number" and not yes/no. Thanks for your help.

Thank you! I will follow up using the MySql link.

I agree with you, and if I were starting over, I would certainly follow your advice. In this case, I did opt for the band-aid route. I set up an update query that runs automatically when the screen closes. Took care of the problem without digging into lots of other aspects of the program. I...

I cannot get rid of waiting and archived fields because other reports and actions are based on one or the other field's setting. The two are mutually exclusive. However, you have given me an idea how to accomplish this. I can set up another query that changes waiting to 0 if archive is -1...

I have a form displaying data from a person on a waiting list. Criteria in underlying query is -1 in "waiting" field. One of the buttons on the form is "Send to Archive". The Archive button macro accurately puts a -1 in archive field but cannot change the waiting field to 0. It can make the...

I need to backup mysql tables on local computer, and how to recover from this backup if necessary. Thanks!

I had tried the latest driver along with changing the reference to the new version in the module and it was a no-go. Finally, I did install the latest connector and installer but left the Access program referencing the older version #. That worked! Apparently, the new connector doesn't care...

I downloaded it several years ago when it was the current version, but since the Access program references it, all works correctly.

Yes, I did. I get error 1918 that says myodbc5S.dll is missing. Now I am trying to figure out how to run as Admin since it isn't my computer. Don't know if that is part of the problem or not.

My client just bought new Windows 11 laptop. I am trying to install an Access program that uses a mysql database via ODBC 5.1. My old MySQL connector odbc 5.1.13 win 32 won't install - error 1918 says myodbc5S.dll is missing. My connection string in the OpenProg module: MyConnectionString =...

Thank you The_Doc_Man! Such an easy solution--the organization already has a web presence and I can simply establish an email address for users to use--hadn't thought about the obvious solution to include a "please reply to" address within the body of the email. It is frustrating to have to fix...

CDO routine no longer works if the user's email is a gmail account. "To help keep your account secure, starting May 30, 2022, Google will no longer support the use of third-party apps or devices which ask you to sign in to your Google Account using only your username and password." One of my...

I think this isn't worth the worry! I shall just remove the option to specify the reply address. If they want to specify a different reply address they can put it into their message. Thank all of you for your help.

Thanks, theDBguy.

Tried that.

Gasman, I do know the code executes to the end and exits because the list of sent emails saved at the bottom of the code contains both the successful and the unsuccessful emails. me.ReplyToEmailAddr has a value picked up from the input screen along with the Subject, Attachment (if any) and the...

oleronesoftwares, The recipient is the address in the To field. The recipient never receives the email although the code never gets a fail indicator. If, however, the sending email credentials email address is the same as the Reply To address, all works correctly and the email is delivered...