Recent content by HappyApple

thank you - I will take a look at that now :-)

does anybody know if this is possible? I need a text box on a form where you can enter any number of words and it will search one field and return items with the words in the search box no mater what order they were typed in. Really struggling with this one :-(

thank you, as I thought... its sounding like what I am after is not really a possibility. Thank you anyway :-)

Thank you but this is not what I'm after. The example you give is searching one word in multiple fields --- What I need is to search multiple words in ONLY 1 field. Any other ideas?

Hi guys, I wonder if anybody can help me? I need to create a search box on a form that would work similar to a google search. So if I put 'BLUE BOOTS' into the text box it would find anything that contained these words no matter what order they were in. for example it would return 'BOOTS...

Thanks for replying John but I want to create the button to place it on the form... not just use the standard one on the menu bar. :(

...oh well then... I always think my questions must be relatively easy for the more experienced programmer but I never seem to get any replies on here. Never mind, I'll just have to assume that I'm doing really complex and advanced stuff and leave you guys to the basics. thanks anyway.

Hi there! I wonder if anybody can help me. I want to add a button to my form 'Filter by selection' but it doesnt work on the wizard and if I attach the macro DoCommand filterbyselection that doesnt work either. is there a bit of code I could use (sorry I'm only a beginner) many thanks for any...

Hi there, I have posted a few times before and really hope you can help this time too. I dabble in access but program with macros ... have not mastered the code yet! I'm sure there is a solution please help.... My database is storing records with LINKED pictures. On the form we can just...

that has worked a treat thank you so very much for your help :)

Thank you for all your responses. I will be working on this again this week so will let you know how I get on. ps (yes you are right ... the command wizard button doesnt work)

Hi everybody I wonder if you could help me? I am reporting on certain charactistics and there are a lot of memo fields ... some of which are empty. The report is Columnar. Is there a way to hide the label if the memo field is empty? many thanks for any help you can give. Michelle

yes, records can be added to the form ... this is what the form was designed for. Its just a shame as when adding a number of new records via the form here is a lot of detailed and lengthy info and it can become tedious having to re-type it so many times for each new record

HI there, I have a form which is made up from a query linking together about 3 tables. I would like the user to be able to click a button on the form that enables them to duplicate the entire record without having to retype it in all the fields. The new record should have a new id and the...

Am new to forum (stumbled across whilst searching for help!) Not much experience with charts. Have created pie charts and having difficulty changing the colour of the 'slices'. It appears to accept the colour changes in design view but when I preview it displays the default colours (which is...