Search results

Thank you again for this. Like I said, I can work with it and it does exactly what I want, except... Is there any way I can get the detail in the report footer to appear directly after the details, no matter how many items are added? I've tried everything I can think of with my very limited...

Thank you, I appreciate you spending the time to reply. However, this has been taken from an old database system the estimators have been using for years. I set up the Access one when their permissions stopped working, to work the same way , look the same etc and to their exact requirements, it...

Oh my god, that's brilliant!! I can work with that, thank you so much.

Thank you for the reassurance, I was concerned I'd done something else wrong!

Thank you!! but I may not be using it correctly? When I try the print preview or report it's asking for parameters against each description? I also need to be able to change the cost for each individual item and list them separately as per the word doc example. Sorry, I maybe missing something...

Good morning - I have been tasked to add an estimate system to our current Access database using autonumbering for each new estimate. I have very limited knowledge of Access and have basically taught myself (not that well!) to set up various forms/reports etc and this is my latest task. I have...

Thing is, if I try and rerun it everyone up to the issue gets the same thing again! Is there anyway of putting them in my drafts so I can then send???

Omg! I thought I'd checked and double checked! Now getting an issue where it stop when no email address entered (we have some names on the DB which do not receive Pay slips) but not an issue, I can just put mine in there!! Thanks again

Hiya, I thought I was sorted, even did a trial run at the weekend but now coming to run them for real and getting the attached errors.. This is the code on the form (not sure I uploaded it properly)... Any ideas please? Option Compare Database Option Explicit Dim OutlookApp As...

Don't worry about previous response, I think I've sussed it due to Gasman's comment. If I actually knew anything about code I would've realised that. I'd just like to say you're my hero!! 🦸‍♂️

OMG!! That worked! Thank you so much! 😊😊😊😊😊😊😊

Thank you - Do you ever sleep! I've added that but still getting errors. If you're determined to help, which is appreciated, I have reattached your version with the code and reference added...

Thank you so much again for holding my hand through this but I tried this and got the attached, I've tried going onto the other posts/the internet to investigate and changed bits around/add/deleted bits but I always seem to come up against other errors. Honestly, I really appreciated everything...

You're all brilliant - Thank you!

You're all brilliant - Thank you!

That is exactly what I need, thank you so much for coming to my rescue yet again!! Not wanting to push my luck, but I have this found this command on the internet - DoCmd.SendObject acsendNoObject,,,"jillnoble@tubesscaffolding.co.uk",,,"Wage Slip Breakdown","Please find attached your wage slip...

Arh, I see what u mean, once you know the company name you can get all those details from companies house anyway so didn’t think that would be a problem. But yes, see what u mean about Keith and the wages. My mistake and am very sorry. Just didn’t know how else to get the help I needed. Apologies.

Ok Uncle Gizmo, no problem. I thought it would be ok as no addresses, email addresses, phone numbers etc (except mine) only random names. However, I totally understand. Thank you

Thank you so much but I’ve kinda lost the Will to live with it at the moment! This looks great but I don’t even know where to put it! Like I’ve said to thedbguy, I think I’m going quite a way out of my understanding. Thanks for trying though!

Thank you DBguy but I think this may be a bit above me. I can’t even get the outputto to work! I’ve googled it, Copied, pasted and amend to my own names etc on several different versions (I assume I put that in the vba of the report?) I think I may have to think of another way round. I may just...