Search results

@theDBguy Its not a runtime error. Its simply faulty in my case and returns nothing. Thanks Also, @arnelgp Post #9 reflects your code converted to a function, rather than a sub. (It doesn't make much sense to not return a value if you're going to pass input args to the sub) But apparently, I...

Hi, I tried several folders on a mapped drive. But I don't suspect this to be the issue. I haven't had a problem with any FSO functions or built-in file system functions in VBA yet with my mapped drive. Will report back if I do more testing. Thanks.

Dim fpath As String fpath = "\\Drive\Home\Desktop\" Debug.Print Len(ListFiles(fpath)) 'returns zero every time, fpath is valid and has several files

Hi, Thanks for the replies. So far, I've attempted to use @arnelgp and @theDBguy solution. Both cases did not work. Providing the correct arguments (trailing slash in path name, proper asterisk notation for filespec). I find it highly coincidental that both of those functions would not...

Hi, Before I write my own nested nested nested loop, surely someone has something out there already.... I need to list all the files in a single 'base' folder, which includes subfolders of the base folder. and subfolders of the subfolder's subfolders. The nesting of the subfolders is assumed...

Hi all, Good discussion... it was the classical mistake of the form(s) not being open so Access couldn't find the object... Whoops. As for the "theological" aspect to this question.... The fact is: theres no reason we shouldn't be able to do it. Should a language not support this ability...

So far i've tried... Set frm = Forms(sfrmname) set frm = Form(sfrmname) set frm = Modules(sfrmname) None work. But specifying the keyword does?

I just tried, it requires a form 'object' as the argument, which doesn't make sense to me (why return a form, by passing a form - makes no sense). thanks

Hi, I am struggling to call a function by it's name. The function resides in a form object, but CallByName() is struggling to locate the object. Dim frm As Form Dim val As String Set frm = Form("frmOperations") val = CallByName(frm, "ClearFormHandler", VbMethod) The form...

All, A lot has been learned about EXIF / Image Orientation for me during the course of the discussion. I believe we have working solutions. I think this was a bit of a blank space in the forum that we've now filled with good resources. Thanks to all who contributed to the discussion. I am...

I understand that, but its not the distinction that should be made. We are asking the question of: When we take photo, what is the "normal' orientation (0-degrees)? And the answer to that is only one single answer, that is defined only by humans: Whatever way the user intended to view the...

You missed the point. The user intended to take the photo and view it as the same. Do you take a portrait photo with your cell phone and expect to view it with your head cocked at a 90 degrees? Or Is it just that Landscapes, are acceptable to view at a "normal" angle? Lets give both the photos...

Using the code provided by @Nixversteher, I was able to modify the EXIF. To reiterate some points: The source of confusion (for me, at least) is the comparison of real-life orientation, versus what the EXIF alleges is the orientation. Real-life orientation being what the user actually intended...

UPDATES: I've been playing around. I'm able to read the EXIF orientation. Cool. I am able to rotate the image in VBA with Carda Consultants code.... Cool.... Except it doesn't alter the EXIF data (as @isladogs points out) at the bottom of post #6. Its a hard rotate and doesn't actually modify...

I completely missed the URL in the post. Apologies. Yeah, the code in the provided link mentions nothing about Windows Image Acquisition (WIA). There is ExifTool command line tool, but I have no idea where you get WIA. Its not listed in the references on my installation. Thanks UPDATE...

Thanks for the resource. This attempts to solve half of my problem. It can read EXIF but not write it. Is there a class out there to quickly allow writing? So far, i've gotten two different values from a couple tests on various photos reading Orientation tag using the code. These values were...

Hi all, An app I have built and use frequently uses a lot of photos (of varying dimensions). The source of the photos is usually a cell camera. The problem is, the photos are displayed in the control with the incorrect orientation. If the photo was taken "side-ways" (landscape) with the cell...

Hi, Definitely covered before, but curious what the pros are doing... What is the best solution for accessing a custom VBA code base for multiple projects? A single library that is shared across multiple projects on a single local machine. Making changes to a few main projects that share the...

@MajP I guess that is what is required to truly "format" this textbox. Thanks

Hi, thanks for responding. So further investigation shows that any numerical input in the box doesn't get flagged as a violation of the set format, and consequently remains in the textbox, but becomes hidden upon exit. Hiding text is a great way to confuse people and create data entry errors...