Recent content by jillnoble

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