Search results

I have a report that draws its info from a home movies database. In the report I'm trying to display the movie title, rating, genre, personal notes about the movie, stars of the movie, and a movie description. All this info just wont fit even on a Landscape report, so I thought I might put the...

Heres my updated DB. PBaldy refresh code still not working on frmAddStarToMovie so I removed the code from this form. Please tell me there's someone out there that can get PBaldy's code to work with my form...

I can add new movies with this form now, I fixed it. I dont get the error message anymore either. What happens now is what was happening before; Even with PBaldy's code, the form still looses focus on the current movie after I add a new star to a new movie. So, I have to navigate back to the...

Naturally I'm not one to give up on things, but this headache of a problem is seriously making me want to toss in the towel on this one... Am I even putting the code in the rite form? I've tried everything I can think of to reference the main form MovieID...

Hmm... weirdness... I'll try yours. Maybe something got FUBAR'd in mine...? Thanks. ;) EDIT: I just tried yours, I got the same error message after adding a star to a new movie. When you tested it, did you type in a new movie name, like "zzzzzzz" or something, then try to add a new star to the...

Thanks for that bookmark, going to read it now. Thats funny, I tried that too (the "Forms!form1.MovieID parts)exactly how you re-wrote the code. It doesnt work, I get the following error: "No current record." Then the form looses focus on the current movie like before. Any ideas?

Well, I gave it a good try, transplanted PBaldy's code into mine, but I haven't got it to work yet... First, I'm not sure which form to put the code into, and second I'm not sure which value to reference. PBaldy references EmpID, which is a constant in his form. But my main form (Form1) uses a...

Good idea. I just did that and it works great, thanks :) I have one more issue with the movies form (Form1) that I need help with. When you assign an actor to a new movie, the form navigates away from the movie you were just editing and displays the first record in the movies table. It doesnt...

Okay, I transplanted the working stars list and your new Add Stars functions to Form1 and it's working great! Thanks for your help! To take this form a step further, the final modification would allow the user to delete the movie if, for instance, they sold it or dont have it anymore. I added...

Did you add the queries to a form in the DB you attached? I looked through the DB but Form1 doesnt work. It doesn't show any actors in the combo boxes so I cant assign actors to any movie. EDIT: I figured out that you applied those queries to the "frmMovieDetails_comboBoxError_notworking" form...

WOW! Yeah, I wouldn't have been able to do that myself. At least not at this point in my noobness :) Thanks for the example, I'll look through it with a fine toothed comb and try to understand what you've done to get it to work. OOPS! I think I meant to use an underscore, my bad. I'll keep a...

I think I did something wrong, it isn't working. It still lets me add duplicate stars to a movie, but also it now lists duplicate stars in the drop down list too. It seems to be listing stars by MovieID because it shows a star name 4 times, and that star is assigned to 4 movies also... Heres...

I'm not sure if I know how to reference the current MovieID or not... Heres what I did though; I created a new query with Query1 as it's source and added the MovieID field to it. Did I do that part rite? As far as excluding all ActorID's that are already linked to that MovieID, I dont know how...

Okay thanks. :) I know how to create a query, and how to specify basic criteria, but I'm not quite sure how to exclude already selected actors in a query. I'll give it a try though. Edit: I just tried to do that but I have no idea how. I hate being a noob sometimes... Could someone please...

I still have allot to learn :) Thanks for the help. Next question, how do I get the subform to not allow duplicate star entries? I just tested it but it let me add the same star several times. I looked in the subform properties but dont see anything that lest you prevent duplicates. I know...

Yes, and your form worked great, but I need to allow the user to either add additional stars to a movie, or add new movies and add stars to the new movies, and it wont do that rite now for some reason. How would I get the form to do this? I tried replacing the Names text box with a combo box...

I've already tried that, but because the form uses a query as its source (or I think thats why...) the subform doesnt list all the stars, it only lists one per movie, even if the movie has 50 stars... It also asks for a value when you start up the form too. Theres something happening that I...

I've modified the layout of the form you helped me with (Form1), but i'm having a problem with it, could someone help? I added an "Add New Movie" command button to the form, but it's not working rite. When I click it, I get all blank fields and I can then add new movie info in the fields, but...

I understand now about the autonumber and why you would use it, thank you for helping me understand. I see the efficiency of using a digit rather than a text string. I really appreciate all the help. My instructor is good, but honestly I'm learning more here than I am in class :D I've got to...

I see, thanks for the advice. Several questions follow: 1) Originally I had autonumber fields in the single column tables, but removed them because I didn't understand what purpose they served. I don't understand (due to my noobness...) why one would use an autonumber when they could use...