Search results

ridders, you are being a great help. I just run the report based on dates and the result is the report shown. Its a unique hyperlink for each record and it works brilliantly, until I pdf it as you well know by now. I used the hyperlink builder to create a url. I have tried doing text but did...

https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=67036&stc=1&d=1501506112 https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=67037&stc=1&d=1501506112 Sorry it will not allow me to paste as a screen shot only as the above. I feel such a nerd, I am...

ridders, thank you as well from me. I am learning all the time. "If you can learn one new thing every day, then your day has not been wasted".

Thank you so much, sorry I am being an idiot a lot of this is all new to me. I did follow the instructions but it would not post, it would only post a link to the jpg, will keep trying (I am very trying). When you say a stripped down version of the database, its linked to a live ODBC so you...

THANK YOU, this has work, I have now learned something new today. Thanks to EVERYONE and thanks for your patience with this slow learner. You can teach an old dog new tricks.:D:D:D:D:D:D:D:D

I am losing the will here. Argggghhhh, you have to laugh. https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=67033&stc=1&d=1501498827

Like this. https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=67031&stc=1&d=1501498369

Sorry I think I am thick as two short planks. No matter what I am doing it will not work. The expression is looking for a date, if the date is blank I want it to say invalid. At the moment it shows; IsNull([DATEAPVAL])=TRUE This just shows it as blue, that is the colour I have chosen in...

Hi ridders, Thanks for all of the advice. The coding is as follows: https://planning.plymouth.gov.uk=online-applicationsapplicationDetails.do=activeTab=summarykeyVal=[KEYVAL] It looks like this in the bottom bar...

I have looked again today. I can get the field to colour blue but I still cannot get it to read INVALID if the field is empty. The Nz bit definitely does not work at all. I bet you guys are pulling your hair out hahaha. Any other suggestions??? Apart from go away:rolleyes:

It should take you to a unique record of an application. Will try it all next week I am getting really confused now. Sorry, I have to say it confusing me so much. Maybe when I am fresher I can give it all a go. Its not the link that's the issue as far as I can see. They all work perfectly...

System has now crashed hahaha, just my luck. Will try next week. Thank you as always. Nick :o

No luck I am afraid. I am signing off, I do not want to give up on this one, it the last report of over 50 I have written. Brain needs to rest hahahaha, getting old. Thank you:D

Sorry, another one that will not work. Once I can do screen shots etc maybe that will help. Thank you again.:(

I am losing the will on this one and maybe I should leave it until next week. I have tried the above and I still call not it to work. Maybe when I can post screen shots etc it may make it easier to understand. Thank you so much for your help so far, I really appreciate it. Have a lovely...

Thanks but it still will not work, I suppose it is the simplest of things, will attack it next week when I am not frazzled. Thank you for all of you help so far, I really appreciate it. Have a lovely weekend.:D

Todays test, here goes I am trying to get my format to say if the field is empty (no date) I want you to show the word Invalid. I can get the colour to come up but not the word. At the moment it looks like this. Expression is IsNull([DATEAPVAL])=True At the moment the colour is BLUE and...

Thank you, I am neither here nor there, I am not really sure where I am these days.......:D

Thank you, I feel I am not alone anymore:)