Search results

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.

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.