By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

Need some input

Expert 100+
P: 1,892
I'm trying to get some input on the best way to handle a situation I have. I have a form with a series of comboboxes ( approx 13 ) called Part#, I would like to make a seperate table called TPartNumbers, however each of the 13 drop down boxes has around 2-4 options. Does anyone have a suggestion on how I should do this? I was thinking 1 table but I may have to do multiple; also, I have thought about a listbox so I can display all the options, however if they pick more than 1I'm not sure how I would handle the multiple entries. I have a ton of tables already about 20 I'm not sure that I want to add another 3 or 4 not to mention I would be making tables like ( eg.. TPartNumbers1to5 ), any ideas or suggestions I may not have thought about? Any input appreciated!
Thanks,
AC
Oct 27 '06 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
DON'T make a new table

Making tables just to hold data is pointless unless there is a very good reason for it.

What do you want to do with this data?

I can tell you how to handle multiple list boxes but I need to know if all the data is the same and what it's for
Oct 28 '06 #2

Expert 100+
P: 1,892
Thanks,

It's basically a repair form, the problem I'm looking at is for part numbers for every different product there could be a different part #, so say one product has a bad part depending on the product the part number could be 1040 ( or 1111 ..... 1115 ) A,B,J,L,S, or ... whatever. So there are about 13 combo boxes ( In the approach DB they were in columns part1, part2, part3, ... , part 13 ) with the part #'s with anywhere from 1 to 4-5 values per combobox, that may need a letter appened to the end of the value in the combo box. I was going to use a list box but no way to add anything to the values.
Thanks,
Aric
Oct 28 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks,

It's basically a repair form, the problem I'm looking at is for part numbers for every different product there could be a different part #, so say one product has a bad part depending on the product the part number could be 1040 ( or 1111 ..... 1115 ) A,B,J,L,S, or ... whatever. So there are about 13 combo boxes ( In the approach DB they were in columns part1, part2, part3, ... , part 13 ) with the part #'s with anywhere from 1 to 4-5 values per combobox, that may need a letter appened to the end of the value in the combo box. I was going to use a list box but no way to add anything to the values.
Thanks,
Aric
You can add to a list box:

For example:

Listbox called List1
Combobox called cboPart

To add an item to the list after selecting a value in cboPart put the following code in the On Click event of a command button cmdAddPart

Expand|Select|Wrap|Line Numbers
  1.  
  2. Private Sub cmdAddPart_OnClick()
  3. Dim strList As String
  4.  
  5.   strList = Me.List1.RowSource
  6.   Me.List1.RowSource= strList & ";" & Me.cboPart
  7.  
  8. End Sub
  9.  
  10.  
If you need more than one column in the list box let me know exactly what you need and I'll post the code
Oct 28 '06 #4

Expert 100+
P: 1,892
I'll post the code so you have a better idea of what I'm talking about. I'll clean it up and pm it you can let me know what you think.
Appreciate the help!
Aric
Oct 28 '06 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
I'll post the code so you have a better idea of what I'm talking about. I'll clean it up and pm it you can let me know what you think.
Appreciate the help!
Aric
Just thinking Aric

If you want to associate quantity, qa# or any other field with the part then you can move the fields form tblRepairs and put them in tblRepairParts.

This will associate them with the repair and the part rather than just the repair. Adjust the forms accordingly.

i.e. Remove them from frmRepairs and add them to the subform.

Mary
Oct 30 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.