Search results

I'm really confused now. I checked to make certain... and as I thought, my subform is already linked to a query (qry_Freelancer's_Languages) rather than to the form. I did this so that I would be able to have a MultiSelect listbox on the subform that allows the user to select multiple records...

How do I go about bindind the subform to a query rather than to the table? Where do I go to view the table-to-subform relationship? I know how to view, establish, & edit relationships between tables & queries, but not forms or reports USEN

Never mind, Paul...I copied the code into my original database and made the appropriate changes to the listbox & it works fine. I don't get that error. I do need some way of updating the records rather than appending to them should someone return to the subform to correct an error made when...

Hi Paul...thanks for the prompt reply; however, using the file you returned, when I click the command button on the subform, it gives this error: "Operation must use an updateable query"

Thanks Paul...here's a "Copy of My Database"...renamed as such for confidentiality reasons with my employer.:D Please tell me what I'm doing wrong here. Keep in mind that most of the tables have yet to be placed on the form(s). Also, the Freelancer Type & Industry Experience listboxes that...

B.T.W. I'm placing the brackets around the table name because of the apostrophe. I see now that using that character is a problem so I won't do it anymore; however, at this state, I'm afraid to start changing names. I've seen where some people attach their database so that you all can view it...

Hi Paul...thanks for the reply. I changed my code to match your suggestion, but it still gives me the error "Object requried". Here's the revised code: Option Compare Database Private Sub cmd_Store_Languages_Click() On Error GoTo Err_cmd_Store_Languages_Click Dim sfrm As SubForm Dim...

Hi Everyone... Since posting my last message, I added a Command Button (cmd_Store_Languages)to the subform which should transfer the items that are selected in the MultiSelect Listbox to the junction table. I think I've found the VBA code I need; however, I'm missing something & don't know...

Hi Mile-O, I downloaded you sample database dbqualifications97.zip. It indicates my situation very closely except that I have a listbox in place of your combo box. When I attempt to save a record in the subform (both in your sample & in my own), it tells me that it cannot be saved because...

Hi Paul or Bob, I'm back to work after some much needed rest. Thanks to both of you, I now have my "junction" table (tbl_Freelancer_Languages) set up with a 1-to-many relationship with both my main table (tbl_Freelancer_Information...using the FreelancerID field) and the tbl_Languages table...

Thanks Paul! I think I might be able to get somewhere with this. Next question...can I use the combo box I already have on my form to insert the data into my tbl_Freelancer_Information table (this appears to be the same as the "Person Table" in your example). It is currently set up with SQL...

Thanks Bob...I'll definitely go check it out. Thanks also for the tip on how to leave positive feedback for you guys. USEN

I fully understand about it helping others. I just didn't want everyone getting "bored" with all my long questions & problems. They surely will be by the time we get through all of this...that is...IF we ever get through it all...lol. Thanks for your time & patience. Perhaps one day I'll...

Thanks Paul. That sounds like a better plan, but how does that give me unlimited choices? I'm still too new using this end of Access. I'm better at using it than I am at writing it...:D. I've set up simple databases before with only a few tables and I didn't bother with forms because I find...

Thanks! Actually, I'm NOT determined...I just can't figure out any other way they can choose multiple categories with an unlimited number of skills within each one. Now I understand why most people have a set amount...it's MUCH easier, but they need to be able to show this data somehow & I...

Hi again...I forgot to mention that I also have VBA coding for Current event of the form. Here is my VBA coding: Private Sub cbo_Skills_Categories__1_AfterUpdate() Me.lsb_Skills__1 = Null Me.lsb_Skills__1.Requery Me.lsb_Skills__1 = Me.lsb_Skills__1.ItemData(0) End Sub Private...

Hi everyone, I'm stuck again. I set up a Combo Box on my form for the first list (Skill Categories), and then a List Box which depends on the choice from the combo box (contains the individual skills). I set the List Box to "simple multiselect" so that each person can select more than one...

Hi Paul, Thank you so much for your quick response. OK, what I have is a company who uses Freelance individuals to work on their client's projects. The projects unlimited and the Freelancers work online thus their skills are also unlimited. It you are familiar with Guru.com...this is a very...

Cascading Combo Box with multiselect option? Hello Bob...I'm fairly new to the developing end of Access. After reading this thread, I'm almost certain that the cascading combo box is what I need; however, I'd also like for the end choice to be multi-select. Is this possible? What I want to...