Search results

Hello everyone, I want to make a button that selects a random record in a form. I used code from a previous thread: http://www.access-programmers.co.uk/forums/showthread.php?t=248325 Dim RecordNumber As Integer Dim RecSor As String RecSor = Me.RecordSource RecordNumber = CInt(Rnd() *...

I have already read the following thread that has a similar issue: http://www.access-programmers.co.uk/forums/showthread.php?t=117793 It seems a bit dated and the solutions offered don't seem to work for me. I have a button on a form, when it is clicked it opens a video file located in a...

Hello again guys and gals, I have another puzzler from my movie database that baffles me :confused: I am copying and pasting some explanation of my database from a post I did about 10 minutes ago. Just in case you think it's a double post since the titles are similar. I have my main data...

Hey Guys, I hopefully have an easy question for you guys. I haven't done VBA in a while and don't know how to solve my problem.:o I have my main data table with each record being a movie. The fields consist of movie name, genre, rating, runtime, etc. My question is on my runtime field which is...

Hello all, I have an easy to solve problem which I can't figure out. :o I have a movie database I'm creating. I have a form to nicely display movies from a main table, complete with movie covers. Currently the movie covers are saved on a hard drive and not embedded. here is part of my code...

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...

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...

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...

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...