Recent content by oZone

Hi, and thanks for the help! :) I made a query using the second option you listed and it does work, thanks! But, I dont understand someting about the DLookup code that you wrote. Could you explain what the "L" and "B" references do exactly? and why L and B?

I've made a home movie library database and for the most part it's complete but I thought of a handy feature to add last minute but I cant get it to work rite and need some help with it. The main form lists movie details (title, genre, rating, description etc...) depending on which movie the...

Thanks again for the insight. I tried using the error number/text table code you inserted above, but I dont know where to put it or how to use it. I'm still a noob to VB... Do I put the error number/text table code in the form that is giving me errors? Do I put it inside an event declaration...

I understand about the before/after update events, thanks for the insight Gemma :) How exactly (code example) do you find, catch, or trap error codes? This is something I'm highly interested in. I'd love to build code into my databases that will provide error codes along with error messages...

Nevermind, I got it to work :) I found the error code, used the code CyberLynx suggested, and put it into the forms error event code: Dim Msg As String Select Case DataErr Case 3022 Msg = "This star already exists in your database" Case Else Msg =...

Can you tell me how to validate that there is no duplicate? I'm an access noob and definately a VB noob... need a little help with the code. Can you (or someone) show me an example please? When a duplicate is chosen, Access displays error 3022 (duplicates error). So, after some searching...

Just an update, I solved my problem :) I made the forms record source a query containing the borrower details and that solved the blank details issue. Now the form is populating all fields like it should. Thanks for your help Premy, most appreciated! ;)

Thanks for the help Premy! Its working good now. I prefer that the combo box shows all friends, that way I can add loans to friends that arent currently borrowing movies (add new loans). I set the Friends combo box source to use FriendID from the Borrowers table and it now lists all friends...

Thanks for the help. Eventually, when the form is working correctly I plan on using a query for the forms record source for the purpose of not displaying currently loaned movies (so the form will not allow me to loan the same movie to two people at one time). I've already added a "Loaned"...

Okay, I tried to apply what you showed me above to a different form, and I'm close, but the form is still doing some strange stuff and not working quite rite. I have a form that lists friends who have borrowed movies from me, and it has a combo box that lets me select the friends name and it's...

That worked! Thanks a ton!:D I have another form that's not working also, I'll apply what I learned here to that form and see if I can get it working too. If I cant, I'll post it here and see if someone could help me with it also. Thanks again!!!

I'm new to Access and could use some help figuring this out. It should be a super easy fix for someone with Access experience... I'm just a noob!!! :o I have a DB that I use to keep track of friends and am trying to create a form that makes it easier for me to edit existing friends, or enter...

I tried OpenQuery, it produced errors like you suspected. However, DoCmd.SetWarnings False and DoCmd.SetWarnings True worked brilliantly! Thanks!

Well, I'm trying, but I really dont know what I'm doing. I dont know VB, but I'm doing the best I can to learn. :rolleyes: I tried inserting the code in your multiselect listbox example into the "Add Star" buttons OnClick Event in the VB editor, but I dont think I did it rite because it's not...

Need help fixing a form that uses combo boxes to retrieve data. I have a home movies DB and have forms set up for keeping track of loaned movies, but my AddEditLoans form isnt working rite and I dont know why. First, I have a combo box in the main form to select friends names. When you select...