Search results

I have a simple one table. With Name, address etc etc. Basically we want to take all of the info from the table, and print mailing labels from it. I thought mail merge into word, but that is a little nuts for me. Not a clue on how to do that. I've seen it done as a report before, and I wanted...

Hi everyone, Cheers for the help so far. Here's the latest.... (Sadly I can't upload on here as it's about 100kb too big) I've added in a 5th tab to my database (I'm using tabs to segregate the form up). This is for the user to set the criteria for a search and run the query (SearchFilter -...

:( This means I'm back to square one. I'll take some time to think and maybe start a new thread in a bit once I've decided on my route, I'm sure I've seen it done this way before... maybe not.

Hmmm I tried Like "*" [Forms]![frmProfessionalInfo]![filtTelNumber] & "*" but I got a syntax error. :( EDIT: Ah, I found Like [Forms]![frmProfessionalInfo]![filtTelNumber] & "*" works. That's solved thankyou :) Hmmm...... I had a quick search mate but i don't really know what I'm looking for...

Right, I'm going Wayne's route now, but I've hit a few snags. I've added a SEARCH tab to the form, and got an unbound text field named "filtTelNumber". In a query which queries all the fields bar the memo ones, I have the criteria: [Forms]![frmProfessionalInfo]![filtTelNumber] frmProfes...

Thanks.

Ok I think Wayne's way might work.... Basically, I want what he did, but on the proper whole version of mine. Plus if I do it myself I will understand it. Basically, I copied his query across. I see the: Like "*" & [Forms]![frmProfessionalInfo]![txtSearchOrg] & "*" ...bit is referencing to...

I'm sorry mate, I don't get that either... Could you explain it a bit simpler for me please? Also: A friend sent me this.... "Filters only work (normally) at the level of the form they are on. So if you apply a filter to a sub-form it merely limits which records are shown on that sub-form...

Just to clear it up for anyone who still doesn't get me and hasn't downloaded... Basically I have a database (i can send to people if they want) that stores organisation information. One main table, with a Contact ID (making it unique), and other things like Town etc. Now, there are 4 or so...

"1) It returns a record for each valid entry that the organisation has in tblCategories and tblAgeList, so if the org has two entries in each it will appear 4 times in the query." I see... But this has really got me confused now. I just need to be able to search on that info, plus the info in...

Hey Wayne that's brilliant!!! But I have some questions..... I don't suppose you could explain in simple steps exactly how you did that? If I could get that for each searchable field that could work, then a button directing it towards the first tab that would be good. Also, would I be able to...

Another bump.... please anyone?

Any luck mate? Anyone? :(

Thanks Wayne :)

Bump as this is ruining my mind.

Anyone? :(

Ok this is the database - zipped up. I’ve taken out some macros and reports to make the file smaller so they won’t work. When it opens, click OPEN DATABASE to get to the main form. Then click the search button. This opens a new form to allow manipulation to the form since Filter on Form locks...

OK mate - how do I do that? It's quite large. On closer inspection this morning it appears that just the subforms aren't searching - linked from ID in the main form to an ID in the subform. I will post one though - but how? Matt

Anyone? :(

Well the main form as say ID, Name, Address 1 etc etc And it can have many things linked in the sub forms. All linked in tables - by ID to ID. So we got MainForm1. And then Sub1 with ID (linked) and category.And maybe Sub2 with ID and age ranges. And a few others. Basically I click filter by...