Search results

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

Here it is. There are two reports they are both the same. The TEST one is one I have been messing around with. The main one has the original code in it looking for the keyVal and it works brilliantly, but as you all know by now, I have been saying it a million times (sorry) when I PDF it, it...

Hi, I have followed your instructions to the tee, it all works wonderfully like it did last time with my coding, but as soon as its PDF this time it loses the link so it just a dead box. The db is 9MB is size so cannot send it. Also I do not have On Load, I only have On Click, On Dbl Click...

PERFECT WORKED FIRST TIME -YEESSSSSSSS Thank you so much ridders :D:D:D:D:D:D:D

Maybe I am just getting it wrong and need step by step instructions. In the event tab (on click) I am putting the Application.FollowHyperlink I then put the hyperlink as above into the hyperlink address (do I say YES it is a hyperlink), with yes click it would not work, with no clicked it...

Todays puzzle. I am trying to get the overall performance with regards to a report in the footer. It shows applications either in "time" or "out of date" All I need is the overall "in time". How we perform. It just the last box, bottom right I cannot get the criteria right for it to do the...