Recent content by mattkbishop

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.