Search results

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

I have permissions set that lock the data for certain users. When I had it set up as just a normal form, it wouldn't allow those users to use the search boxes. As soon as I turned it into a subform, it locked the data and allowed them to use the search field. I inserted the subform onto the...

Bummer :( I'm confused how just changing the type of form could impact the code so much and make it so slow. Thank you for your efforts @arnelgp

Awesome! It is almost working!! So I did a test. I searched for IS191990. I searched 3 different ways and got an instant result for each (191990, IS191990 & ??191990):):) The bad news is that the others like these don't return a result: B11 B158201 AP6484 BON1322 BON79 P4224 CTN485 Some...

So would that mean that I would have to search for an exact match? They often search for just the number with no letters, because they are not sure what the letters will be. So for example if I am looking for RP320200 and not sure if it will be SP320200 or RP320200. I would just search by...

Thanks, but unfortunately it is not always in that format. These are some examples of plan numbers: C3700, SP320200, RP98500, DP500600 etc. I imagine there will be 7 numbers soon the way the numbering is going. When they search, they will often only search by number as they are never sure of...