Search results

I have a movie Database and in a blank form (called "movie_search_year") I created some buttons; 1980's, 1990's, 2000's, 2010's. I have my main data table, with all my movies (called "movies"), and I have a user friendly form to view individual movies (Called "movie_list"). I want to know...

Thank you to pbaldy and galaxiom! that did the trick and saved me a lot of time!

Sounds like what I'm looking for...stupid question though...how do I do an update query? where would I type that code in?

I have a DB with over 1000 records and I decided to add a new yes/no field to my main table. So far all the records would be checked to True, but any new records would be set to False. I don't want to go through all 1000 records checking each box. Is there a way to select all the records in the...

The code works great! just what I needed! Thanks so much to everyone for their help and patience. You all rock! :cool:

SQL you say?...I looked into it briefly and I think that is what I need to do. I'll have to fool around with it and see what I get. Thanks once again!:cool:

That looks great! I'll have to try it later when I get home. I'll let you know. Thanks vbaInet!

I want to have a user who isn't familiar with access punctuation be able to do an advanced search of the database using a designed form with textboxes and drop down menus without them using a query. I know you can search in a query using >, <, and = I can have a button place a symbol in the...

I do have HTML experience although it has been years since I last did it. This database I have is the only one I am doing/ will do and I'm not interested in reading up on all the VBA functions and punctuation (Basic and advanced) in order to solve 2 issues I am having with my database. These...

Hey guys! Just had a quick question. Are you able to reference the "criteria" cell in a query for a certain field using VBA code? I know you can input [Forms]![Advanced Search]![YearBox] in the criteria cell of a query to reference a textbox of a form, but can you reference that same criteria...

Thanks for all the help so far guys! I tried a few different things and I think I'm on the right track (could be completely wrong :o). So I have My "open IMBD" button and my code is as followed (not including the "_"): Private Sub OpenIMDB_Click() strURL = "ht_tp://im_db.co_m/find?q= "...

If I have a movie list that displays the movie year and the movie length for a hundred different movies and made an access query I could run that query by searching by year or length. So I could search for all movies that were made in year 2003 or search movies that are 1:56 long, or both. Good...

Some info: I am currently making a DVD database that is quite large and rapidly coming more complex as I have new ideas to improve functionality. Right now I am trying to create an advanced search form for my database. Basically, I just want to make a form that can do the same as an access...

I am relatively new with access, but do have some experience with it. My weakest skill would have to be the Coding. I do have to give some info on my database before asking my question, so please have patience :) I am currently making a DVD database that is quite large and rapidly coming more...