Search results

thanks again

Thanks...sorted that problem. now I have noticed a lot of grey space after the last list on the subform, is there a way of stopping this so you can only scroll left to the end of the data rather than continuing into oblivion? Lee

I have been looking at my form and i have now noticed that there is annoying bar (circled in red) that doesn't do anything and i cant find the option to remove it:- Does anyone know a quick way to remove it or is it because of where it is placed? Lee

hi, I ended up using an access startup form as it was the easy option. thank you so much for all your help. Lee

with the wildcard is there a way of embedded that into the coding or would it always have to be manually entered when searching? and finally...is there a way of making only the search engine visible to the user (basically to run like a program rather than having to open up access and then open...

Hi, i have looked up wildcards and it appears i cannot get the result i want. I found on this website (http://www.fontstuff.com/access/acctut06.htm) that the wild card would not be able to find a second word (e.g. Yor* would find York, Yorkshire and Yorktown but not New York). do you...

hi, no i really dont get it. i feel really stupid as i did all this when i was at sixth form but it has all gone out of my head now. with the "like" coding it seems to only search for the first charaters or so, is there a way to make it search the whole line (e.g property address like high...

hi, i have been looking at the lines of code and i see that you have entered an "else" command. but when using the database i cant actually see what this is doing. and you mention how to undo the filters but i really dont know how to do that. is there a way of setting up a button that will...

hi, thanks for doing this for me. At the same time is there a way of making the search less specific (e.g. name like "smi" rather than entering smith?) thanks

im not sure what you mean by "SQL" but when i press the debug button it highlights this line of code:- Me.Archive_subform.Form.FilterOn = True Lee

Hi, i have attempted to fix this problem over the weekend but have still not succeeded and really have no idea what is causing this to happen as i cannot see anything wrong with the code. if anyone could help me i would be very grateful. thanks in advance Lee

hi, i have tried to copy the coding to add different searches in using different command buttons but on some of them i am getting a window come up:- which doesn't happen on the original version of the code. Any clue how to stop this? this is how my code looks now:- I cannot see why the...

thanks that worked for me. How can i make the search less specific? thanks

hi, realised what i have done now...putting the name of my button when i should have been putting the name of the text box. i have replaced that but now i am getting a different error thanks

hey thanks...feels like im getting somewhere now. it comes up with compile error and highlights .Value of the code below and then when i pressed the ok and then debug it highlights the top line of the code below:- Private Sub Command3_Click() Me!archivesubform.Form.Filter = "Surname = '" &...

do i need to add something to this code? Lee

hi, i did that but it came up with an error:- Lee

I have managed to put a subform in now, but how do i link it to the search and also make it only show what is relevant? this is how the form looks now Lee

Im ok with putting in buttons, text boxes etc but I dont know how to add in a result type box that will show the results and then how to link them up. I am currently using a text box and a command but to enter the search (but there is no code to make it search) and that is as far as it has got...

Hi, thanks. I still don't really understand as I don't even know how to make a form like the one I have shown in the example. I really need a lot of help with this if anyone has the time Lee