Search results

My Customer table is quite like you said, but I don't quite understand what you're doing with the HireType and CustomerHires. I've uploaded an excerpt of my database, so if you could tell me more specifically what is wrong / how to fix it, that'd be great! :) I know that having CustomerID's...

Ok thanks. Yea no problem, I know you don't intend to sound mean. So how can I 'normalize' my database? :)

Hi there I have a form with two unbound text boxes: HireMovieID and HireCustomerID, and a button HireButton which runs my query: HireHistoryQuery. Then I have a table: HireHistory. In my HireHistory table, I have my CustomerID's along the top as column names. Then the records for those columns...

I forgot to delete it because I was copying my data from my CustomerInfo table. Ok thanks! :)

Oh ok. I've got a table Hire History, and the data in it is laid out like this: Is it possible to make it so that when (for example) John Smith hires something, it adds another cell to the end of his hires in this sort of format?

Hey guys! I've got a problem which I can't seem to figure out the code for. I have the logical process, but I just don't know how to put it into code. I have a form with two boxes HireMovieID and HireCustomerID, with a button HireButton. The two tables which I have are CustomerInfo and...

OH MY GOSH! I finally did it! Thanks everyone for your help. I tried writing my own SQL and it finally worked! :D I'll post it up later on when I can! :)

Yes I know that you said that, but in the code that you showed me it has an '=' operator, so what I was wondering is that if I used your code, would I need to type exact values in order for the records to be filtered. Does that make sense? :o

But I need LIKE for my Name/Rating/Genre etc boxes? As in so that they don't need to type in the full name for it to work. Will that still happen with this code? Because it looks like '=' so the text has to be exact, am I right? I need it to show records even if I don't enter anything into some...

This is all of my SQL: SELECT MovieList.[Movie ID], MovieList.Name, MovieList.Rating, MovieList.Genre, MovieList.MovieYear, MovieList.Director, MovieList.Length, MovieList.Status FROM MovieList WHERE (((MovieList.Name) Like "*" & [Forms]![SearchForm]![Name] & "*") AND ((MovieList.Rating) Like...

:banghead: ^That's exactly how I feel right now. The thing I've been trying to do is make it so that my form filters my records, and I'm trying to make a between function for it. My form is shown below in the attachment. What I need to do is make it so that my form filters my records Between...

It shows all records :) Exactly what I needed

Thanks for you help. I've got a solution now. I used the code: WHERE Between [Forms]![SearchForm]![MovieYear1] And [Forms]![SearchForm]![MovieYear2] OR [Forms]![SearchForm]![MovieYear1] Is Null and it seems to work perfectly. Do you recommend I change it to yours, or does this...

Ok I put it in as in my SQL code under the WHERE: ... AND ((iif(isnull([Forms]![SearchForm]![MovieYear1]) or isnull([Forms]![SearchForm]![MovieYear2]), true, [MovieList].num between [Forms]![SearchForm]![MovieYear1] and [Forms]![SearchForm]![MovieYear2])=true)) AND ... And when I try to run...

Hi, I have two text boxes and I'm wondering how I can filter my records of my table (through my query), between two numbers on my form. So for example lets call the two text boxes Num1 and Num2, the logical process is: IF Num1 or Num2 IS empty THEN filter records with "*" ELSE IF Num1 and Num2...

Ok well I've figured it does what I need it to do, if I just put this into the Criteria in the query: Between [Forms]![SearchForm]![MovieYear1] And [Forms]![SearchForm]![MovieYear2] But, I need to make it so that it also works if I don't put anything into those boxes (as in, it shows all...

I used the code: Private Sub RunQuery_Click() Me.Filter = "[MovieYear] BETWEEN " & "*" & Me.MovieYear1 & "*" & " AND " & "*" & Me.MovieYear2 & "*" Me.FilterOn = True Debug.Print "[MovieYear] BETWEEN " & "*" & Me.MovieYear1 & "*" & " AND " & "*" & Me.MovieYear2 & "*" End Sub Ok, I thought it...

No it's just the year. So for example the Column [Year] is like this: 1990, 2005, 1987, 2012 etc, so I don't think there should be any need for some kind of date-format thing. It's just a plain number. I've tried pretty much everything, but nothing works. I just did it with that code and I got...

Yay that worked! Thank you so much! :) Any chance you could help me with my other problem? I posted a thread on it but I got no replies :(

Hmm tried that and got the same thing Annoying.. After I click OK it also highlights the Private Sub Lock_Click() in yellow. Is it something to do with my naming of 'Name'? Since it's selected?