Search results

Why can I not put unrelated fields from unrelated tables on different pages of the tab control? Why do they all have to be related to the 1st field from the 1st table I add to the tab? Thanks! Brady

Just tried it and it works!! Hahah Yes! Another quick question if you don't mind. I can search one field great, but let's say I wanted to search two or more fields. Instead of just searching for 'Minnesota Vikings' cards, I want to search for 'Minnesota Vikings 2002' cards meaning Vikings...

After all the work I made you do, I know now why you made me go to the work of uploading a copy! Hahaha LOL o well it was a good learning lesson!! Thank you Bob so much for your help! Anyways, I haven't had a chance to try it yet, but am I'm gonna be able to enter spaces with this code still...

The form is 'Form4' I deleted a bunch of stuff from this extra copy so I could get this uploaded. Thanks...

Is there an easy way to get rid of pictures in the form, report, or tables? Or do I need to manually go through and delete them. For example, I'd go into my table and filter it to those that have an attachment and delete those correct?? Is there an easier way that I'm missing out on? The...

Sure, I can do that. My database is way too big...even for zipping to upload on here. John pointed out some tips for zipping it down. Is there an easy way to make a copy of my database and take some stuff out so I can upload it here? Thanks for being so helpful and wanting to work with...

When I enter that code and try running it, I'm able to type and it starts to filter. However, after just three letters it filters it down to nothing. It does this on every word I start to type in. I also added the brackets because I thought that might be the problem, but it wasn't. Also...

Bob...thank you again. Here is what I came up with. [sport] like '**' OR [year] like '**' OR [manufacturer] like '**' OR [set] like '**' OR [player name] like '**' OR [card type] like '**' OR [card number] like '**' OR [condition] like '**' OR [team] like '**' [sport] like '**' OR [year]...

Yes. But in reference to point #3, How do I run my code? When I click Run, or click the green arrow, or push (F5) is that what you are referring to??? If so, it brings up a menu for macros. Would I create a macro here? Or am I pressing the wrong button? I don't think I should be getting a...

Sorry Bob...I'm completely lost. I have no idea where to go from here. I have my code up in the regular window, but I'm not sure what to exactly put in the immediate window. Again, I REITERATE I'm a beginner to this VBA code and I'm sorry for not being able to understand. If you have the...

thank you! I'm not sure what to look for, but I'll go ahead and give it a try. Hopefully I can figure out what's going wrong. Thanks again Bob!

this is going to sound really stupid...but I inserted the line, but I don't know what to do next? I clicked 'Debug', then 'Compile' n it doesn't do anything. lol Sorry I'm so naive...I'm a total beginner so I appreciate the help. Please clarify what i do from here...thanks!

thank you Bob...so where do I put this debug.print line? Where does that go in the code?

btw...do I need to change the code for [sport] above? Why does it not have another strFilter afer the (= symbol) shown for set, player name, card type, etc. below that one? Thanks...

Which final line do you mean? This one>>>Forms!Form4!frmSubform.Form.FilterOn = True Or is it this one shown below?? strFilter = strFilter & "[team] like '*" & Me.Text0 & "*'" What should I look for to see if it's building correctly? I'm afraid that I won't have any idea what that means...

A few things... ID is the only one that isn't a text field...I just removed it from the code. I'm able to type, but nothing will query...it all remains the same as I type. Please instruct...thanks! Option Compare Database Private Sub Text0_Change() Dim strFilter As String...

Bob, Thank you so much! I haven't had time to work on it yet, but I'll get back to you with the results! Again, thank you for your help!

anybody????

Here's my latest attempt to put your sample to work for me!

Private Sub Text0_Change() Dim strFilter As String Me.Refresh strFilter = "sport like '*" & Me.Text0 & "*'" strFilter = "ID like '*" & Me.Text0 & "*'" strFilter = "year like '*" & Me.Text0 & "*'" strFilter = "manufacturer like '*" & Me.Text0 & "*'"...