Recent content by Tophan

Good morning. I am trying to create another images database and was wondering if the type of form - Form1 in post #15 above - could be used as a sub-form? I tried by creating a main table where I would enter the project details and report date and then link it to tblFiles but when I tried to...

Thank you both! This is a great help.

Hi, I've attached the DB. It's not much, I was just trying to get the codes and modules to work so the data in there is test data. Nearly all the pictures in the current form were taken in portrait orientation and are showing as landscape in the form and report. I'm not sure if the...

Ok. I made the change. No error message this time but the image is not rotating either.

Hi. This is the full code I saved to my database. Private Sub Command55_Click() Dim strPic As String, strPath As String Dim blnRotate As Boolean strPath = "c:\Users\" strPic = Me.Image23.Picture blnRotate = WIA_RotateImage(strPath & strPic, 90, strPath & strPic) Me.Image23.Picture = strPic End...

Hi, I'm getting a compile error when I try to run this - "Expected variable or procedure, not module" and the below line of the code is highlighted. [blnRotate = WIA_RotateImage(strPath & strPic, 90, strPath & strPic)]

Hi, Just following up on the above request. Can someone help me with this?

Good morning. Sorry for not responding sooner - I was out of office for the majority of yesterday. I'm trying to understand how get this to work. I saved the module but how do I select the specific photo? Do I go back to the form and select it there? I have little experience with modules so...

Good morning. I reposted my question in the reports forum.

Good morning, Following up on a question previously posted (and solved) in the Tables forum on how to import a file path batch, I have encountered a problem. Using the VBA code provided by @Pat Hartman and @theDBguy, I was able to import all file paths for photos from a Windows Explorer...

Hi again. I've encountered 2 problems. Firstly, please accept my apologies if I have posted this in the wrong forum - I am just continuing from the original thread. Please let me know if to repost in the Forms or Reports forums. The first problem is every picture that was taken in portrait...

Thank you everyone! This works perfectly and will save me so much time each week. Now, I am going to print off the vba and try and figure it out bit by bit so I understand the steps for myself. This is really appreciated.

Thank you :D. Enjoy your game!

Oh yes. I understand that. I don't want to import the photos themselves, just the filepaths. I've done this with individual photo filepaths before but was wondering if I could import all filenames in a folder at one time instead of one at a time.

Hello. Is there a way to import several filepaths into an access table? I'll give you more context to this question. Every week I receive several progress photos from project managers on a construction site for inclusion as an appendix to a weekly report. Right now, I save the photos to a...