Search results

Bless you all, there is so much I can take from all of these. As ever, this Forum has been extremely helpful.

Bless you and thank you Pat, but I really do not understand what you mean. I have built a DB for my company not knowing anything really about how it works and unfortunately only found out about RI when I was quite some way in. What we have works for us, rightly or wrongly. I'm looking for a...

Ok, so now you've completely confused me!! I only want a PO system that gives each PO a new number and clears the old form for a new one?? Bless you Doc Man but I think I may have over confused things!

No, I'm not really a DB expert, Have just muddled along with my companies requirements. No experience in DB's at all I'm afraid.

We all use the database i've built at the same time without any problems including this estimate one but I cannot seem to apply the same rule to the PO form??

Yes, and the Macro I built for Excel doesn't like 2 people being in it at the same time

Hi all, Hope you had a good Christmas and Happy New Year to everyone. Sorry, but back here wanting some advice please. I originally created a PO system on excel for our company, using a Macro to issue a new PO for every entry and automatically creating a PDF for each PO. However, since being...

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