Search results

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.

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

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

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

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.

Hello... looking to count the numder of TIF files in a folder (thousands of folders really) without going by one file by one file within each folder. I saw some promising code but I get #VALUE in Excel or some kind of error each time. Suggestions? Here's code I have to count ALL files in a...

Thanks - best debugging approach you might suggest? Thanks!

Hello - editing data through a form, connected to SQL server table. I get the error below ... I'm not doing anything crazy re: on_current, etc. that I can see. What's weird is that I can click OK and then the edit actually "takes". Any suggestions? Thanks.

Hello - I often will open an Adobe object. All of a sudden, I'm getting a 429 error "Active component can't create object." Any suggestions. See code below. I do have Adobe PRO, I repaired the DB (to be safe), and this code was JUST working like 1 hour ago! Edit: the coding does seem to work...

Never mind - I got the sub to run me.requery -- to call the sub from one subform to another, I used this: Forms!MainForm.OtherSubForm.Form.subRefreshForm and subRefreshForm is a public sub that runs me.requery

It doesn't seem default. I tried setting up a public sub on the SF_WORDS that would would do a me.requery call, but can't seem to get syntax right to call a subroutine from one subform to another?

Hello all. I have a MAIN form, and a subform listing documents (SF_DOCS) and another subform listing words on that document (SF_WORDS). When I click on a different record on SF_DOCS, I want the SF_WORDS to not just load up using master/child fields, but to go to the top of the datasheet (if you...

Actually, method #2 here works much better, even if it is a little slower... https://www.experts-exchange.com/articles/34111/The-Effective-Way-to-Find-the-Last-Line-Content-of-a-Large-Text-File.html

I ended up doing much simpler coding, based on the END of the file (that may have %PDF in the header), but a corrupt PDF would much less likely have %PDF in the final line... Function fnPDFCorrupt(pFileNameFull As String) As Boolean Dim sFileFooter As String sFileFooter =...