Search results

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

It seems I can download and run .net framework on a server that IT gave us (and has Access/VBA installed)... now what? Thanks!

Thanks - I'll ask IT guys...

I am first converting regular scanned pdfs to searchable PDFs (using 3rd party software) and then searching for certain words. During the conversion process every once in a while, it will create a corrupted PDF. Out of my control, but I do want to be able to test for it before searching for the...

Any other suggestions very welcome please! Thanks!

Thanks. Any non-native things (like I’m guessing Python might be) would be hard to get approval for @ my company.

Hello - I have a process that manipulates PDFs in Access VBA using the Adobe reference, etc. The problem is that when a PDF file is corrupt, it doesn't "crash" normally... rather Adobe will prompt me regarding the bad file and then only when I manually close the file / Adobe, Access will THEN...

I change item sizes and visible settings mostly I think.

Hi - rather than have 2 versions of a form depending on the type of project we're running, in my accdb file, I modify the design of the form in VBA ( I open the form in design view) and then open the form in normal view. But accde doesn't allow form design in VBA (I think). Is there any way...

EDIT: I think maybe Acrobat DC (the pro version) is not recognizing the code I'm using. Here's a link to similar code that's also not now working: https://myengineeringworld.net/2013/03/vba-macro-to-convert-pdf-files-into.html Here's some code that used to work for me but now I get an error...

Actually, for now, I'll even take just saving out a PDF page to a jpeg

Anyone have code to convert just a part of a PDF page to a jpg file? I know the PDF coordinates within the page I want to save. Thanks!!!