Search results

I think I should have posted this up before you amended the copy you have - I have updated the GIS_OBJ and MEASURE table so that each site's measures are scored individually. I figured a new thing to do (introducing ID's like you have in yours). The OBJ_ID is now an ID, and OBJ_NO is the...

My weekend hasn't gone too bad, and I understand about the work thing, I really appreciate your help though. You are a complete star!!! Thank you for this! It does work, it's brilliant. There are some other questions I need to ask. The GIS button on the search and primary forms work...

Well then, I shall! lol. (Btw, I am posting this up as a different thread now, just in case your sick of me! lol) It is regarding another search button, well, more like an open form button. If you see for the GIS tab, it doesn't link with the main form (which it should) and I couldn't get my...

Yay! It works. A message box did appear as I copied over teh FRM_SEARCh: "Your Microsoft Access database or project contains a missing or broken reference to the file 'OWC10.DLL' version 1.1 *To ensure that your database project works properly, you must fix this reference" I'm not too sure...

Thank you! Your example does work, but what exactly have you done? I can't see anything different - apart from yours works and mine doesn't, lol

Soooo close! It now finds the first record, but only the first record. I tried two postcodes that are stored, and it returned the first record only (but no error message arose, which is good!). We are nearly there, yay!

Yep sure. Thanks for this.

oh yeah... never thought about that! :) I am very happy with all the help you have given me, thank you very much! However, there is still one problem... the postcode search. It takes the user to the very last record, even if the postcode that has been entered is in the first record. The Ref...

Well, the Ref No search works now... It doesn't let me scroll through to the other records I have (which is good) but if you click on next record, it opens up a new record... Not too sure that is good! :) as for the postcode one, once I have changed the code so it has comments on like with the...

Yep - here it is. I used the same code as you... maybe i forgot something, that might be it. I am doing this through work too. I'm going to be doing it this evening too, which bites (would rather have it all finished with as soon as possible) :(

Yes, I can see it now (for some reason, it was shown without any attachment.. spooky!). I now have a new problem... instead of it going to the site I have searched for, it opens a new record. How can I solve this? I so appreciate all this help by the way.

Have you attached something? Nothing is showing up... But thanks for this.

The #Name? thing is now sorted, thank you very much. However, the last thing that was stated about the Null entry and such, I have put that into the queries and tested it out to see if it would show the form even if nothing is entered, and with the Ref Number, it brings up "Syntax Error...

New error... Sorry I have copied FRM_PRIMARY and called it FRM_SEARCH_P (meaning its the search form for the form primary). I entered a site that exists, and it showed the site, but in most of the field boxes on the main form, it showed #Name? in them instead... Confused! And will that new...

How can you make a form as a source of a query? - it only lets me do tables (in design view of query making, i am assuming that's what you mean). This is the code behind the search button for postcode (maybe the errors are arising because it's a DCount thing???): Private Sub cmdSearchPC_Click()...

Yay! The search bit works! That's cool. Thank you for that! Now, all I need to know now is how to sort out that problem of it going to the very last record... I am not sure on how to do it. Also, I would like to search for postcode too, but when I try it with the same type of code, it either...

thank you!!! You are a star! If you don't mind, I will wait until the evening for your example. This database has been driving me nuts, everything seems to be not working the way it should, and I am a novice at doing access on my own.

I tried putting in that code you gave, and it still comes up with the error. I have attached a copy of my db, the form to open is FRM_MENU and the button states "Search for a site" (or something along those lines). Thanks for this.

I have done that, and a new error now appears. Compile Error: Method or data member not found It now highlights in yellow to Private Sub line, and then highlights in gray .RTP_ID.

I have done that, and it does make the form/tables more manageable, but it still doesn't link to the main form, for some reason. I have a relationship going from the objectives table to the site details table, but its not even showing on the form. When i go to the next site record, the...