Search results

No problem. Glad I could help :D. - Jordan

I think that would be the best option. I would prefer to be able to choose the category, then length, then possibly actor/actress, using filters. It would also help, if you didn't have to choose a Movie Length for example. If you know any solutions, I will be very thankful. - Jordan

Hey there! I have been building my Database for the last few months as part of my I.C.T Coursework, and have come to a standstill. My Database is based on a "Film Rental Store" in which the employers will make sales e.t.c at a Film Store. I had a ingenious (If I may say so :rolleyes:) idea...

I think this should work. Build a query, and add the table CustomerTable. Then add the field LastName, and put the following in the Criteria box - Like [LastName] Then in Parameters put [LastName], and Text as the Data Type. Hope this helps :) - Jordan EDIT - I just realised you said to use...

Thanks Bob - I have only recently started Databases, so I am learning all the time, so thankyou for your tips. I will try the expression on Monday when I get back to the database, as well as the other solutions posted here. I have also added to your reputation for your reply. Thanks again, Jk

Thanks for the reply - Sorry I haven't replied quicker. Joey - I have already tried the "=Count([Film Name]) in the text box control source", however it did not work. Craig Dolphin - I will check if your solution works on Monday, when I can use my database. I have also added to both your...

Hey Aj. Thanks for the reply - Sorry I haven't replied quicker. I will check if your solution works on Monday, when I can use my database. I have also added to your reputation, and again I must say thanyou for your reply. I will also try to reply to you once I try the solution. Thanks once...

Hi. I have recently made a video database for a project, and have have come to a small problem. What I wanted to do was to, using a query search, find the total number of results found, in a form. Basically, I have a query, in which I have the Film Name, Movie Cost e.t.c, with - Like ("*" &...

Hi. I have recently made a video database for a project, and have have come to a small problem. What I wanted to do was to, using a query search, find the total number of results found, in a form. Basically, I have a query, in which I have the Film Name, Movie Cost e.t.c, with - Like ("*" &...

Hi Keith. I am not sure closing the password form would work. I have a Switchboard, in which I follow the steps: Member > Edit Member - Now the Login Form Opens - (If typed correctly), a Macro goes to Edit_Member Form So when I have finished with the Edit_Member Form, and go back to the...

Hi Keith. Thanks for the quick reply, I have added to your reputation. The DoCmd.Quit solution worked, so thankyou VERY much. My problem, however, is that I am not sure what you mean about: "you need to assign null values to your password form controls to clear the values" I go onto the...

Hi, I'm quite new to Databases, but am learning fast. I have currently made a database, for a Movie Rental Store (not a real one), but have now come to a halt. My problem is that I have created two tables in which, 1 one them I have a log of Staff names, passwords and Dates. In the other table...