Search results

:) I just said apart from the code your provided, this is also not working. Can you please tweak it if you can? thanks

Yes, I tried your above code and tried this also. Getting same result. Not sure why. Thanks for trying. Dim myInt As Integer myInt = DateDiff("n", StartTime, EndTime) / 60 txtTotal = myInt

I tried this: Start time: 10.30 A.M. End time 12.00 P.M. I get the output 2. Not 1.5. This is my code: txtTotal = DateDiff("n", [StartTime], [EndTime]) / 60 Thank you.

Thanks so much.

Please let me know what is syntax to get the total time used in hours and minutes: 1. Start time: 9.30 am End time: 5.00 pm I need to get used time as 7.50 ( that is 71/2 hours) 2. Start time: 9.30 am End time: 5.30 pm I need to get used time as 8.00 Thanks for your help.

Company won't let me. Please find the screenshot attached. This is the third page. Thanks for your help

I tried. I made page footer height to 0.5. But still not working.

Hi I am designing a report and I have content only 2 1/2 pages. Now I am not able to move the page footer further down so that I can add more fields in the details section. Please help. I am struck. Thank you.

Thanks.

Thank you all. Format([DateField], "mmmm, dd, yyyy") is fine with me. It works. Thanks.

Please let me know how to convert a date format from 6/11/2020 to June, 11, 2020 in a text box field in a form and also it get saved in the table in the same format. Thanks for your help.

Thank you for both for helping me. Image control works fine for me. Thanks again.

No codes. Just place the control over the appropriate place and set the recordsouce. Thanks

Yes, as a background picture. Thanks

I have a pdf form with the size of U.S. paper (8.5x11 inches I think). I will convert this pdf into Jpeg and I wish to paste this picture on an access report in the same size. I will be placing controls like text boxes on this picture. Please let me know how to paste this picture withe the...

Hi pbaldy, Thank you, this is what I have been looking for. Thanks for your help. Have a good weekend.

Thank you. If you know the link for the template, please let me know. Thank you.

Ok, thanks. Then I will try mail merge, not sure if it will work, never done. Thank you.

Thank you, not form, but report.