Search results

Well, I googled tempvars but it would be removed after I close the data base. I need to (like you said) create a form that just stays open in the backround...maybe a form that has its size set to 0,0,0,0? Im going to try that. Ill tell you if it works. Thanks!

Ok, I was looking at what you said, and I wasn't sure why you said that, but now im thinking, that if I do what you say, I will have exactly what I have already. I want to put what im going to say next in caps locks, but then ill like stupid. I know how to make a text box, that sorts the list...

:) What is TempVars?

Ah, so closing the form was not the smartest thing I could have done :) Should I just never close the frmEvents? Because I get the same thing when I close and use frmItems.

Ok, picture one is pasting the code, picture 2 is me closing the qryAdminEvents and then refreshing frmEvents. And picture 3 is the qryAdminEvents AFTER I have refreshed it.

Ok, :o Here is the correct one, and NOW you can see in the frmEvents there is now the correct txtSearchS

oh.....Never mind, give me a minute, wrong data base :P

Ok, here is a image of it.

I keep doing WHERE Show Name like "*" & [Forms]![frmEvents]![txtSearchS] & "*" under neath were I had Like "*" & [Forms]![frmEvents]![txtSearchS] & "*" and I was able to search and it worked. But I go the the form, refresh, do a search, it brings up no results, and when I go back into the...

err....There is a text box named txtSearchS Its on the form frmEvents its the text box you search in for shows in...

Hello :) I have been trying, no matter what I, I can not remove the Enter Parameter Value. In the attached date base, go to frmEvents, and double click on one of the shows, and you will get that error. I have deleted lines of code, text boxes, and anything else that is associated with the...

Does any one have a idea why this is not working? Do you want me to post my data base for you to look at?

Ok CJ, I have looked and done some things of what you said, and I think, your not understanding me. With Multi Select, I and select multiple items, and that is useless for opening them seeing as it errors. I Dont want that, I just want Multi search :) Just to do what I said. I have shows that...

It looks like I should have some help, or at least some people that have looked at the data base. From what Gasman said it doesnt sound hard, and that is the annoying part of this.

What do you mean?

I see the multiselect options, but, I have 2 options, one is Simple, and the other is Extended. Which do I choose?

???? Yes, I definitely know that, but I would still like the option to (from a form) go to the table, to see the records source, and change anything if needed. err, I dont have a query for the data I get from the tblShowSales.

What you see in the tblshowsales is the same format of the data that I import it from. I import it from a .xlsx file, that will always have the same formatting as the tblShowSales. I posted a .accdb file instead of zip, can you work with that? And if/when your off of work I also posted (in...

Whada mean by that?

Can I use that in a table? Because I import (Or im trying to) my sales to a table, and that is were I have a drop down list (I know there evil, but I still use it there) for the items. But if I try to import, I get lots of errors because the names dont match up.