Search results

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

Thanks - I'll check again. I'm at the beginning stages of the DB so it's not too late to make any corrections.

Good afternoon and Happy New Year! I am working on a hotel project and created a continuous form listing all the tasks that need to be completed for the guestrooms with a Yes/No field. Each room will have the same tasks. I would like this form to be a subform where the main form will have...

Hello, So the [txtTTLInsurable] is in the Month group footer. I also used the same formula in the Report footer. What I don't have is any sub-totals in the Quarter group footer. As I run the report for one quarter at a time, I didn't use the Quarter group footer, only the Month group footer...

Thank you

So I found a work around which is giving me the correct total, I'm just wondering if it's the best solution. In the report footer I calculated the grand total for the total insurable and named the text box GTInsurable. Then to calculate the total insurance payable per quarter I created a text...

When I try to run the report with the expression to sum the insurance, a box pops up asking to Enter the Parameter Values for the text box txtTTLInsurable. That is the text box in the Month group footer.

Good Afternoon, I am trying to sum a calculated control in a report footer but not having any luck. This is a quarterly report that calculates the insurance payable per month within the quarter based on a set percentage per invoice. Note, the insurance payable is not calculated per invoice but...

@CJ_London Thank you for your help even after as @Gasman rightfully said I left in a huff. Please accept my apologies but I can't help but feel slightly embarrassed when I don't fully understand. I am self-taught and although I have been using Access for years I still consider myself a...

I'm sorry for not acknowledging the individual post; I did however, thank everyone for their assistance in post #22. I really do appreciate everyone's help but I guess my beginner status is an irritant as this is the second time I have been admonished on this website for not understanding. My...