Recent content by nickaccess

The weird thing is that there are no passwords that I have programmed on anything, certainly not on the PDF. We do not have passwords on our emails. We obviously have a general log in password to access our systems. I am assuming some sort of MS upgrade has been done that has affected the...

The macros I have written are all for reports from access to go out to various people. I have set them up to run as PDFs and just email out to each person they need to go to. The only other setting I used was to say no to Edit Message. They have worked for weeks if not months and now they...

Hi I created a number of macros and they have all been working really well until now. They run but will not send. The message I get is. The password is invalid; the message has not been sent Has anyone ever come across this? Not sure what I am looking for apart from a password which...

Hi Guys Its me again, the pain. Sorry to bother you all but I am having issues with my macros. They have been working perfectly up until last week when the message now comes up. The password is invalid; the message was not sent. Have no idea why none of them now work. Any ideas. I just...

Thank you, will play around, I am sure it is there. Thanks for all of your assistance, it is very much appreciated. Have a great weekend.:D

Hi the In_time shows the percentage of applications in time from the total =Count(*) the other box will show "out of date" (the balance of the in time ones) again as a percentage so it should look like this: In time 9 90.00% out of date 1 10.00% Hope that makes sense...

I have changed it to read just [In_time] and the result shows as attached. https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=67280&stc=1&d=1502459011

It is showing the result attached. Even if I do =[bottomcount]/[topcount] I get nothing coming out. Weird, its so simple but its not working. thank you as always https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=67279&stc=1&d=1502456740

Hi Guys I am back, yes its me the nuisance. I am finding the most simplest thing difficult to do at the moment, and I am sure the answer is easy, but I just cannot see it. I want to show the In_time results as a percentage from the Count(*) on the In_time Header. What am I not seeing? I...

Thank you ridders, your help has been really appreciated. From the start I made it clear that I was by no means an expert, I have taught myself as you all know. I cannot thank you and everyone else, especially you with this matter. I know it was never going to be easy, so THANKS A MILLION...

Here goes, I think its all there. And go............ https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=67131&stc=1&d=1501765116

Hi ridders Not sure what is happening now. I have put the CNCODE into the system and deleted everything on it apart from Wards. It will not run without error, as in the screenshot. I am sure there is enough records to pull through but still unsure why this is happening. Sorry, I have...

Sorry I am making a pigs ear out of this one:(

I think I have managed to get the Ward Names in. If I take out the () would that affect anything? I have a lot of lists that have () in them, carried over from a old system (not my way of doing them). Thank you again, the light is shining at the end of the tunnel:D...

Hello, Thank you so much for the links I will watch them all. I think I have done everything that needs to be done. Can you please have a look and let me know. Don't worry if its wrong, I will give it a rest and look at it another time. There should be some things to look at and work on...