Search results

Filter on form alternatives..... new problems Basically, I search, and the subform data doesn't show up. Or, I search on it, and it only ever shows up a certain category. I have several subforms :( Any ideas?

I've solved it just in case anyone's interested :p I used a subreport of the table in the report for each of the categories. Yay for me. :)

Well basically, all of it. I got the first bit of data in there. Fine. But the relationships are so I have say the main table (Contact ID, Field1, Field2... Field22). And then three other tables. All have something like "Contact ID [linked], Category/Age Ranges/Literature Available" It's a...

Oh nuts. I basically want to do a report in the form of a letter for each record, showing all it's subform bits. So it will be.... Letter Title + logos Dear ___ Text and info (just using the text boxes from query selecting current record - will be a button on form) Subform 1 categories...

n/m

n/m n/m

The help menu says: You use the Option Explicit statement to protect your modules from having undeclared variables and to eliminate the possibility of inadvertently creating new variables when typographical errors occur. This error has the following cause and solution: · You used an Option...

Well I had a play.... I got this code: Forms![frmProfessionalInfo].SetFocus frmtblLiteratureSubform.Visible = True Forms![frmProfessionalInfo].SetFocus ReceivedWritingPermission.Visible = True Forms![frmProfessionalInfo].SetFocus ReceivedTelPermission.Visible = True to make them all visible...

How do I do this? Basically, I got a subform (and another field also) that are invisible. They become visible when a tick box is, well ticked. Ok... so I have a button that does some nice code stuff. Well I have two actually.... What I want, is some code to put in the code builder bit, to...

Ok well I got the filter on form thing working, but I have a problem... When I'm selecting data to search on in the filter on form mode, I can't select a few fields. The reason for this, is because in normal form view, the fields (one subform based on a tick box, and two tick boxes based on...

Thanks Hayley but I've sorted it now. I got a friend to help - basically, we opened another form and ran the filter form command (using DoCmd.) at the same time. On the pop up form, we had the filter form controls - such as run it, clear it, exit and restore etc. Thanks anyways though. :) :cool:

That only applies the last selected filter, it won't let you edit the variables to filter on, like the Filter by Form button does. This is the bigger prob I am having... the report must be customized - ie. Has to look how my boss wants it. And I got no clue about a new object icon, sorry, I'm...

Filter on form button HELP !!!! :-( 1) Ok well I like this filter on form button... but.... is there any way I can get it assigned to a button on the form, and then another button to select the filter (when all the other existing buttons are faded out)? ---------- 2) Also, how do I create a...

How do I do that?

I have a drop down menu, that puts the selected data into the field "Tier". When I select something from the drop down "Either Tier 1,2 or 3" some relating text is shown and stored in field "TierInfo" - basically cos that's the only way I could do it. The code I used (on AfterUpdate) of the...

Ok. So I finished my project.... but...... I got to show my manager the finish database, feeling pretty pleased with myself. And… She tells me she needs to be able to multiple search with ease. So what I’m now looking to do, is to be able to create something, that allows you to search on...