Search results

I'm trying to make a form for my DB that allows me to select movie names from a combo box, and after choosing the movie, the movie details will be populated into their respective fields in the form. I created a combo box to select the movies, it lists all the movies in the DB, but when I pick...

It doesnt give me an error number though. It's the default error message that happens when a user tries to enter a duplicate value in any PK field. Here is the exact error (or more like an alert) message: "The changes you requested were not successfull because they would create duplicate...

In my database I have a PK in the Actors table so when I enter a value that already exists in the PK field I get an error message similar to: "The changes you requested were not successfull because... primary key... etc...". Is there a way to use VB code to display a different pop-up message...

I read your article, but I'm affraid it's a bit over my head being a beginner... I've only been learning Access for a little under 3 months now, and am not very familiar with VB, but am trying... This is the furthest I got with your article, but it still gives me an error so I'm sure theres...

I added the info you suggested to my AddStars form, but after adding a star I get this error message: The AddStars form is seperate from the main form (frmMovieDetails), the combo box that needs to be updated with the new star data is in a subform (frmMovieDetailsSubform) within the main form...

Awesome, thanks! I'll try that now.:)

oh, did I already ask that question? Sorry, my bad...:p I'll check now, thanks.:o

I have a DB that allows the user to add data using several forms but am having a problem... In my main form (MovieDetails) I have a command button that opens up another form which let's the user add new actors to the DB but after adding the data, if I go back to the main form (still open), it...

This works great, but after playing with it a little while I noticed something that needs fixing. After adding a new star using the AddStars form, I close the form and return to the main form (MovieDetails) and look through the combo box menu and the newly added actor isn't listed. I know the...

:D Perfect! Thank you very much sir! :D This worked great! And a good idea to do it "after update"... I should've thought of that... ehh, the woes of being a noob... :o For anyone else who stumbles across this same situation (for the TAB key), the following code did work for me: Private Sub...

Exellent! Thanks for the tip! It worked brilliantly of course.:D Your advice sir is like that of pure gold; highly valuable and... umm.... goldish in color??? I dunno... lol What I'm trying to say is, THANKS!!!

I have a home movies database that I'm creating and am trying to prevent the user from entering duplicate star names. My initial thought was to simply make the star name field a PK, but I cant because if I do it breaks some of the relationships. So, I'm curious if there's a semi-easy way to...

I have a home movies database and a form that allows the user to add actors (for assigning them to movies) by entering the star name into a text box. But without a pop up message, there's no visual confirmation that the data was written to the database. I'd like to add an OnKeyPress event (or...

Re: Access noob, subform help. Error msgs, not allowing edits, & not updating fields. I found an alternate way of adding a star, I just used a separate form (the new actors form I created during your tutorial). I re-purposed it and linked it to a command button located in the main form. When...

Re: Access noob, subform help. Error msgs, not allowing edits, & not updating fields. I got it to work, but this method of adding a new actor to the database seems sort of "clunky". Let me explain: If the user enters a new star name, the user then presses tab to go to the next record and a...

Re: Access noob, subform help. Error msgs, not allowing edits, & not updating fields. Okay, thanks for the clarification. Getting late here, time to turn in. I'll try this first thing in the morning, thanks again!!!

Re: Access noob, subform help. Error msgs, not allowing edits, & not updating fields. I went into the VB code editor and added the suggested info but I've tried several times and cant seem to get it to work. When you say to Do you mean the name of the main form or the subform? I tried it both...

Re: Access noob, subform help. Error msgs, not allowing edits, & not updating fields. Thanks :) I was just getting ready to go read that link you provided too. I'll still read up on it, but I'll also attempt this code transplant and see where it gets me. Really, thanks allot for the help...

Re: Access noob, subform help. Error msgs, not allowing edits, & not updating fields. Thanks for the advice. It seems to be more technical than I can handle being the Access noob that I am... There isn't an easier way to do it? I'll research your suggestion for sure, I just didn't think it...

Re: Access noob, subform help. Error msgs, not allowing edits, & not updating fields. Good point about the actor names. I became so confuzzled with my problem that I overlooked that :o Your awesome! Thanks! The form works MUCH better, but I did notice another bug in it still. The user should...