Search results for query: *

Thanks Foolie12! This will help me lots! Having an example in front of me is very helpful in helping me to write my own code. Thanks again for your help! :P

Thanks guys. This sounds like it could work for me. Could one of you give me an example of how to write a split function? I'm still pretty new at coding. Thanks in advance :)

I have a textbox with various words in it that are separated by a comma. I still pretty new when is comes to VBA coding and need some help. What I am trying to do is to separate each string and place the words onto a separate record on a table. For example, the user enters: a,b,c,d I want the...

You are right about the combo box being inside a subform. I accidentally left that part out of my original explanation. I think I found a code that works except that now it is doing something completely weird. Ok, here we go. My combo box is fueled of of a table. This is a multi-select combo box...

Well...I must still be doing something wrong. It's still not working. Any other suggestions? Thanks for putting up with me. :P

I'm kind of confused. Where is the subform control?

It didn't work. :( Could it be because the combo box is in a subform?

I'm still pretty green when it comes to Access. I'm not sure how to clear a combo box. I have a multiselect combo box that is bound to a table. The user has the capability to choose several items and then presses a command button that closes out this form and opens up another form. WHen the user...

I'm still pretty new at Access VBA coding. I have built a form that has two subforms. Each subform has a multiselect combo box that is fueled off of a table. The problem I am having is that when I use the combo boxes, close the form, and then reopen it, my previous selections are still showing...

Alright! That did the trick! Thanks bunches! :) I have one last question for you. I have a subform with a multiselect list box in it. I am unable to figure out how to write a code to tell my subform to "clean" the mulitselect list box for the next user. Every time I bring up the form...

Ok this is going to be hard to explain. I have 2 forms: form A and form B. Form A contains several check boxes. The users are able to check multiple check boxes in this form. Once the user checks a box, form B opens up. There the user answers a few questions and returns to form A to start the...

I hate to sound really stupid, but how do I loop and add them. I'm still pretty new at this vba coding stuff. Thanks in advance. :)

OK. I figured out the check box problem, but now I've run into another problem. What I did was make 4 columns in my table with the headings being the same name as my check boxes. I then put yes/no statements for each column. The problem I am having now is that now I have a bunch of check boxes...

Rollie, I'm a little confused. This code will not write to the table, will it? I am not sure how to tell the check box that if it is checked for it to pull the text next to it and place it in the table. For example, if the box is "dog" box is checked then the table should read: Dog yes.

Hi:) I'm pretty new at coding in Access. I have a form that has several check boxes. Next to these check boxes is a word. The problem that I am having is when the box is checked, how do I get the word to move to my table. I know that multi-select box or combo box is much easier, but I can't use...

Unfortunately, my form has several check boxes and I linked them all to the same table via the Control Source, except that when I check one box, all the boxes are being checked and vice versa. What am I doing wrong?

I am trying to get this to work. I would like for my users to be able to check mutiple boxes that are linked to one table. I tried to use the option group, but it only lets you choice one item. I need for my users to be able to choose multiple items. Unfortunately a list or combo box is not...

What I ended up doing is building another table called tbl_Look using the "Look up Wizard" to look up the colors from the original color table. I then created a second field and called it JobUpdate that looked up the jobs from my original job table. Next I built my subform linking back...

Guess what?! I figured out what I did wrong. Now everthing works just fine. Thank you again for everything!

The DEFAULT VIEW is set to DATASHEET. I can't find the VIEWS ALLOWED portion though.