Search results

I started a thread in the sql forum but need more of you brilliant minds to look at it. My db is distributed to a number of users. It began years ago--I began by using mysql connector 5.1 to connect to MySql data. All installations are still running smoothly (with 5.1 installed) and I haven't...

My access program uses mysql files. Is there a way to detect a connection failure before the program hangs? I could then tell the user to turn off airplane mode for example.

I created an update query using two tables but it isn't updating--no error msg. I need to update the date field in one table (localupdate) with the date field in another table (setup). I set the field row to local date, the table to the localupdate table and the "update to" row to...

My program uses CDO code to send emails. It works well, but I need to know how the email server (smtp/outbound) is set. Is it just the ISP of the user just understood? I don't know anywhere in my program that specifically sets it based on the sender's email address.

I have a program to keep scores in a team gin game. There are only two entry fields: "A" or "B" (TEAM) in the first field and the second field (SCORE) allows the points for the hand. The F1 posts the score to a "scratch pad". This is repeated for each pair of players, until all have finished...

Is it possible to set a subform so if data exceeds its space it will shift up one line? I understand I can use a scroll bar, but want the user to see the last entry without having to pick up the mouse to move the scroll bar to move it.

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.

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!

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 =...

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...

My cdo routine written several years ago, allowed the user to specify a return email address that could be different from the sending address. Now, that is no longer working in my code--if the two addesses are different, it thinks it sent correctly but never show up in the recipient's inbox...

I am using a bit of code that allows user to browse for an address of a file to attach to an email. It works beautifully unless the user cancels the browse operation, after which an error message pops up: "The expression you entered has an invalid reference to the parent property." How to...

My cdo code for sending emails has been working error free for several years. Now, a strange problem has arisen. I have a group of 40 people in the membership list, each with a selection box for receiving the next email. I just sent out emails to the entire group via my email form. 38 were...

My client prints invoices on letterhead from tray 1 and office copy from tray 2. I connect remotely. I can't set up print properties on remote system.

When the order# is selected, it opens Orders form to the correct order, then goes to bound Order Sub form properly (which contains the order details). It always goes to the sub form's first record, not new record, even though the sub form's on Open event directs it to. Edit: After I execute a...

I'm not sure if this is the correct forum, but thought to start here with my bizarre problem. Access program for small manufacturer written by me 2000 or earlier. I finally talked them into upgrading to modern version. I converted to .accdb files for FE and BE and got through a few little...

Customer's order entry page has buttons for printing numerous reports, and each button has a smaller button beside it to do a printpreview of the report. They use these little buttons to see if there is no data for that particular report. Is there a way I can test for no data ahead of time and...

Client database written eons ago--finally convinced them to install 2016 version so I could convert front and backend to accdb. Total of 5 users. Suddenly they can't start a new batch of invoices--"Exclusive Access of the MS Access Database denied." At the time of error she was only one using...

I'm not sure this is the correct forum for this, but I desperately need help. I opened (on my laptop) a well established Access 365 db in the am. Later in the day I tried to open it again and received "odbc failed to connect" and the laptop had not been used in the interim. Tried another db...