Search results

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

Good morning. This is exactly what I need. Thank you so much for your assistance; it is greatly appreciated. I added an "Add New Record" button to create a new clear form as well as some combo boxes to select the floor level and room type. Thanks again!

Oh wow! Thank you. I will have a look at it. I was just reading about nested continuous forms to see if that's what I want but I will definitely try your form to see if that works for me. Thank you so much.

Ok...just re-read his thread. I think I have an idea of how to do it so I will try again and reupload the DB for you to check. Thanks!

Hi. I would like to see all items so as to ensure nothing is missed. The current format is what I want to see, however, I tried entering some test data but the subform is not picking up the ChecklistID field from the main form. Please also note that the order of the checklist is following...

Good morning. Please accept my apologies for not responding sooner but was I down with a cold for the past few days. As suggested, I double-checked the relationships and I think I managed to get the form to work. I'm still going to attach the database for all to see. Note, this is at the...