Recent content by DatabaseTash

Thank you soooo much!!! It works like a dream!! THANK YOU :D:cool:(y)

Yes, that is a hyperlink field. I just tried that and got the error "run-time error '9': Subscript out of range"

It appears to be "Plan link" Is the the square brackets the correct thing to put around it seeing there is a space??

Thanks for the reply! I just tried it. I seem to be getting a Run-time error '438' Object doesn't support the property or method. When I Debug it highlights the .attachments. Add line. This is what I changed the code to: Option Compare Database Private Sub Command19_Click() Dim Msg As...

I would like to add the option of emailing a plan as an attachment, once the user has searched for the plan. I have managed to work out the code to get the email to pop up (very chuffed about that! :D). I would now like to get the code to use the search result (See screen shot for example)...

Thanks CJ London. Seems to be working well so will leave it alone while it is working. ;)

🥳🥳🥳 Just wanted to let you know I worked out the issue! :D I did a compact and repair on the backend and it searches SO fast now! The backend file went from 211,284kb to 7,668kb. Thanks for all the input guys!

@arnelgp thanks for the comment. Sorry for the delay in replying. A Christmas break thrown in the middle means I haven't had a chance to get back to this. The code I have mentioned in #12 seems to work well from what I have tested. Is your concern that they will only search by one field and...

Thanks for the hint!! I worked it out and it is doing everything I need it to now. :D:D Thank you so much for your help! You are worth your weight in gold!!🏆 This is the code I ended up with. SELECT tblCadastralPlansRegister.* FROM tblCadastralPlansRegister WHERE ( ( ( Streets_Included...

Thank you The_Doc_Man that seemed to do the trick! :) While I'm at it, I decided that I should change the other search fields to partial searches also. As they aren't really displaying true results. This is the code I have now. I don't think I have the Parish line right though. No matter...

Thanks guys for the different ideas. I have tried this code and it seems to work well for the Streets_Included. However when I search by Parish and Portion it returns incorrect results. For example If I search for the Parish of Barolin and Portion 4, it returns Barolin records for any of the...

Thank you for that The_Doc_Man! :) That seemed to work well for the partial search in Streets_Included, but I broke something else. :LOL: How would I tweek that so that it only shows results that always include that Parish. How this stands now it is showing results for one or the other. So...

Thanks for the reply theDBguy Where do I put the WHERE? :LOL: Does it have to go at the start? Or can it some how be included in the 3rd last line? This is what I tried, but am obviously way off, because it didn't work. SELECT tblCadastralPlansRegister.* FROM tblCadastralPlansRegister WHERE...

Hi all! :) I have the following code which is working on a multisearch form. I would like to make the Streets_Included a partial match rather than an exact match. I have tried including wild cards, but am obviously doing it wrong as I can't get it to work.:rolleyes: SELECT...

Thanks, I did try the tag property method and a few others and had many problems. Guess I will have to have to just settle for a slow search for the time being. Thanks for your help