Search results

  1. C

    Weird error in form

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

    Weird error in form

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

    Connection string for DAO Azure Integrated set-up

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

    Connection string for DAO Azure Integrated set-up

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

    Connection string for DAO Azure Integrated set-up

    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?
  6. C

    Connection string for DAO Azure Integrated set-up

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

    Connection string for DAO Azure Integrated set-up

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

    VBA to create email that Outlook can later open...

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

    Referring to a subform from another subform in VBA

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

    Limit Datasheet to ONE entry

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

    Limit Datasheet to ONE entry

    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!
  12. C

    Limit Datasheet to ONE entry

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

    Limit Datasheet to ONE entry

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

    Limit Datasheet to ONE entry

    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?
  15. C

    Limit Datasheet to ONE entry

    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!
  16. C

    Count # of CERTAIN files in a folder but not one by one

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

    Count # of CERTAIN files in a folder but not one by one

    Thanks. I was TRYING to avoid going file by file since the # of folders is HUGE. Oh well.... thanks all!
  18. C

    Count # of CERTAIN files in a folder but not one by one

    How would I use GetExtensionName to include only TIFs? Thanks.
  19. C

    Count # of CERTAIN files in a folder but not one by one

    I tweaked it but I'm getting an error on the last line (on read file): Function fnCountFilesInFolderWithFilter(pPath As String, Optional pMask As String = "*") As Long Const csPathOutputFile = "D:\log.txt" With CreateObject("WScript.Shell") .Run "cmd.exe /c dir " & pPath &...
  20. C

    Count # of CERTAIN files in a folder but not one by one

    No - for now, pPath = the folder I'm counting files in. But perhaps if I pass in a wildcard, e.g., C:\Folder\*.TIF ??? EDIT: Sorry - that doesn't seem to work. You can't do *.TIF within a folder reference.
Back
Top Bottom