Search results

Gasman, I have no idea. When I was working with the web server help, that was one thing they checked.

isladogs, I know for certain that her password is correct. Several years ago Google disallowed gmail.com email addresses going through third party email servers. In order to circumvent this for my gmail users, I assigned them new ncswga.com email addresses and passwords and set up forwarders...

With your help many years ago, I was able to solve the email program problem--my users have been successfully using the program all these years. Now, a user has a new computer and can no longer send emails (The transport failed to connect to the server). Troubleshooting with the web host found...

I am using Microsoft365 and assume it is 64 bit. both connectors are 64 bit. Now what is crazy, is that when I installed 8.0, I hadn't uninstalled 5.1, and they are both happily residing in my installed apps list. The Access program now happily opens when 8.0 is specified in vba but the Linked...

I uninstalled 8.3, installed 8.0, updated vba to 8.0, closed the app and reopened the app and it said connection to 5.1 failed.

The bit'ness was the first thing I checked. The first try was on a Win11 64 bit computer without Access, so I had her load the runtime. Got the failure there, so I had her use her husband's computer running 365. He installed the 5.1 connector and got the same result--could not connect...

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

Yes. It is what was available when I wrote this thing, and about ten users are still using the original. I have used it this this month to install on another person's computer without a hitch. I tried on my own computer deleting 5.1 and installing the 8.3 version of the odbc connector and...

To add to my question, I had the user send screen shots of the results when she went to relink tables. The Data Source Information: DRIVER={MySql ODBC 5.1 Driver}: SERVER=www.nc###a.com;DATABASE = nc###a_tables; result: ODBC--call failed. [Microsoft][ODBC Driver Manager] Data source not found...

I have an Access program distributed across the state to board members of an organization. It has been used without a problem for around 10 years. The data are in a mysql database accessed by the program via odbc connector. Now, a new user cannot connect. She is running under the access...

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.

There was no error message. Nothing updated.

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.

LarryE, I ended up using your vba code--works great, thank you. All of you are correct of course about the data type. As to whether this is a true relational database, it isn't but it was easiest way to write this program. It works, even for the total non-techie old ladies with whom I play...

I am trying to clear the invalid entry and eliminate the error message. I think I have figured out an easier way to accomplish what I want in the post macro, but still working on it. Thank you for your response--may go back to vba per your suggestion.

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

But won't that put those lines at the top of the form leaving the rest of the form empty? And, actually, I want this to occur during use, rather than putting focus at last or new on open.

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.

Got cha! Thanks so much for the input.