Search results

Hi-- any suggestions here please? BTW, I'm able to connect from Excel to an Access DB that has the sql server tables linked using DAO. But I'm trying to skip the middle-man of Access. THANKS!

Hello - I have a working model to grab data into Access using DAO.recordset from a database hosted on SQL server. Connection string works great. I even have a generic function to grab the recordset as long as I pass the sql statement to the function (see below please). How do I do the same thing...

Yes they are a web host / mysql host.

Okay thanks will look into…

Thank you. Yes that would be worst case but a connection string would be ideal.

Hello - we have an Access database and want to begin to migrate the data to MySQL for others to access the data (read-only for now) using a web portal. Looking for a connection string to use in VBA to link the tables in MySQL to Access. The MySQL database is hosted on siteground if that helps...

I lessened the # of fields (removed superfluous ones and it works now). Thanks.

Edit: it seems it has to do with records that have an & in the field value. How to fix please? Thanks!

Hello. Using a DB that has been repaired / compacted. And I'm running a series of SQL statements that update one table based on another table. The VBA runs fine for almost every field but as I near the end of the process (field #47 of #49), I get error 3047 record is too large. Any suggestions...

Hello - I have two forms that are open while the user is in the DB. I want to move the one form to the right so that the right edge of the form is within say 10 pixels of the right edge of the Access window. And I want the 2nd form's left edge to line up within say 10 pixels of the left edge of...

Strange but me.parent works! The other syntax did not. But I'll take it. Thanks!

Thanks - yes, I know this is not typical. But I don't want zFileID on the mainform to always be equal to FileID on the subform for specific project reasons. I define iFileID as a long type and set it equal to FileID on the subform. I will try your syntax just above Edgar and report back. Thanks...

Hello - I have a subform that has a field called FileID. When a certain event is triggered, I want to set a text box on the main form = FileID. I'm using the simple code below. The text box has no events, etc. so I can't imagine there's a recursive thing going on. But I keep getting a "too...

Thanks guys. For some reason, when I had tried ODBC at the beginning it kept bombing but now I tried it and it worked!

And/or can I use VBA to insert a DSN in the ODBC utility?

By the way, putting in just the server name + database name in the ODBC app, I can easily connect to the tables. So the string does not need a username or anything like that. But how to convert that DSN string into a non DSN string?

This is the version I'm trying based on your input and others.... still no luck... DRIVER={ODBC Driver 17 for SQL};Authentication=ActiveDirectoryIntegrated;SERVER=ServerName;DATABASE=DatabaseName;ApplicationIntent=READONLY;TrustServerCertificate=No;Encrypt=Yes

Hello - my company has migrated some DBs to Azure and I want to update the DAO connection string in VBA. Suggestions for string formats that work well please? Thanks. I was trying the string(s) below for example but I get error 3170 installable ISAM error? gsConnectionDB =...

Hello. Looking to write out an email in VBA into a MSG or EML file without using Outlook. The Server I'm using has Access/Excel, etc. but not Outlook. Can I just write out for example an HTML file that meets the Outlook header requirements, etc. and then, from another computer, open it within...

Thanks. BTW if your routine to refer to another form is on Form_Current, sometimes that runs before the other subform loads, so you have to error trap that.