Search results

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.

Wait... duh... I stupidly put my form_current coding on the subfom, and not the main form. Dcount should work nicely!

Form Load only works ONE time - but not if you point to a different master record. It's okay, I'll just do a recordset record count. Thanks!

I could of course run an recordset query but was trying to see if there was an easier way.

Yeah - put a break-line - it only goes to Form_Current when there's at least 1 row.

Thanks. Trying that, but I'm learning that if there are NO records in the subform, On_Current doesn't get called at all! Any tricks?

Upon opening a subform (datasheet), is there a quick way using on_current event to determine if no rows have been added? I want to turn allowadditions to be true or false to allow the addition of one row maximum. Thanks!

Yeah - it's not Access heavy - it's FSO heavy. So it depends on server speed, etc. It's alright - we're talking days, not weeks.