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

Any thoughts???

anybody have any t thoughts??

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

Great! Thanks for all the help Ken!:D

Got it working, new code is; 'Movie Covers box.Picture = DLookup("[Movie Covers]", "options_menu_folder_directories") & "\" & "default.jpg" 'default value If Me.Use_Alt_Name = True Then box.Picture = DLookup("[Movie Covers]", "options_menu_folder_directories") & "\" & (Me.Alt_Name) &...

didn't work at first but then I noticed that it's name is options_menu_folder_directories. pop up window worked showing the path in that is in the table/in the text box of the options menu form. just to test it further I went into the options menu and changed the file path as a user would, and...

table name is "options_menu_folder_directories" field name is "movie covers" *see attachment

okay that sounds good. I have never used the dlookup() function before so would I use the following? DLookup("FieldName" , "TableName" , "Criteria= 'string'") fieldname= Movie Covers ' this is the column name in the table right? tablename= options_menu criteria= I'm guessing I need to define a...

So with this method I wouldn't need to have the form open? I still learning VBA and have never heard of public variable or domain function. When I look up definitions online I find it hard to figure out the connection to what I want to use it for. What do you think the most practical method...

the use_alt_name check box and the alt_name text box is in the main movie form NOT VISIBLE (.visible=false) since I couldn't figure out how to reference in a different form...like what I'm trying to figure out now. It works fine and doesn't bother me to have it on the main form not visible...

Correct!:D

yes and no. if the directory says: J:\Media\Database\Movie Database\Movie Covers It obviously looks in that folder for the movie cover that matches the movie name. the second part of my code is : If Me.Use_Alt_Name = True Then box.Picture = "J:\Media\Database\Movie Database\Movie...

-have a main switch board with a button that opens an options menu (form) -in that options menu I have a text box with a file directory in it "J:\Media\Database\Movie Database\Movie Covers" (see attached pic "options menu") -this text box is connected to a separate table, so if the user...

So I put a text box in my movie display form I opened the expression builder (which is blank at the moment), I go to the options form with the textbox I want and what am I copying? I opened the expression builder for its control and all it says is "movie covers"...which is the name of the...

Thanks for the quick reply ken, I tried your code and I get the following error: runtime error 2450 access can not find the referenced form so I took out the "form_" looks like this: box.Picture = Forms!options_menu.Movie_Covers.Value & "\default.jpg" and got the error: runtime error 2186...

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

Thanks for the reply PNG Bill! I'll be honest...I'm still a bit lost. Maybe you can break it down for me. So I have my main table of data, I make a query that has no "criteria" filled out so it shows all the data. I then go to SQL view and copy all of the code? I then make a form of this...