Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SemperSalvus

    Prevent Requery from Blanking Comboboxes

    ProgramError: Yes they are bound. TheAceMan1: Thank you for confirming what I thought, that it was just typical behavior. I will be doing as you said, making the comboboxes unbound, to feed and display the choices in bound text boxes. I will probably put a button on the form to open a popup...
  2. SemperSalvus

    Prevent Requery from Blanking Comboboxes

    I am using Access 2003. I have 4 comboboxes that are dependent in order, similar to how a couple of the Forms FAQs discuss. So, in the afterupdate event on combobox 1, the rowsource for combobox 2 is set and combobox 2 is requried, then so on for the other 2 comboboxes. All of that works just...
  3. SemperSalvus

    Display select query value in list control while maintaining list

    MajP: Sorry, but I have been indisposed with other issues at work. Getting back on task with my question, I think the code you provided is pretty much what I needed to see. I have yet to try it, but I think that will get me to where I need to go. I think the code for looping through each...
  4. SemperSalvus

    Display select query value in list control while maintaining list

    Eureka! I just saw the problem with fneily. All your comments and slams now make perfect sense. Disclaimer: No offense to any teachers/professors out there. I had some great ones during undergrad and for my masters. They helped me out tremendously and I would not be where I am today without...
  5. SemperSalvus

    Display select query value in list control while maintaining list

    fneily: As I said, I am not here to get an education on normalization. Who cares if I am in the first, second, or fifth normal form? With what I am doing for this app right now, I do not care. But, I am shocked you did not refer to Dr. Codd by title and give him the respect he deserves...
  6. SemperSalvus

    Display select query value in list control while maintaining list

    You are right. Sorry I exaggerated the amount, but I am actaully just shy of around 230 fields. I was just estimating to begin with. I knew it was a crapload of categories involved with the inspection. All the more reason for me to convert to Flex/AIR within the next several months. This...
  7. SemperSalvus

    Display select query value in list control while maintaining list

    Well, I am at a loss for how to do that insert. It is something I am not used to doing. What is confusing me is that all the list box rowsources taken up by the tie in to the YellowGreen table to create its list of choices. But, the control source is tied into the table which will hold the...
  8. SemperSalvus

    Display select query value in list control while maintaining list

    Why are you guys insisting on changing the db structure? I cannot do that and have no time for it. Besides that, it is correct and relational despite what you think. fneily: There are no variable length records! If the inspector finds no problem with a particular category, he leaves it alone...
  9. SemperSalvus

    Display select query value in list control while maintaining list

    MajP: Sorry, but I do not need that kind of help. Please get back to my question. I do not mean to sound conceited, but I have been designing db's for 15 years and I normalize with the best of them (I would hope so at least). One of my weak areas is SQL though and querying outside of Access'...
  10. SemperSalvus

    Display select query value in list control while maintaining list

    This is probably both a form and query issue, but I decided to post it here. I am running MS Access 2003. Here is my bottom line, since the explanation below is long, but thorough, in case you need to understand my issue better. BOTTOM LINE: I need to display table values (Yellow and Green)...
  11. SemperSalvus

    Help With Repetitive Code

    That is sweet. Thanks!
  12. SemperSalvus

    Help With Repetitive Code

    Ok, the code works because the labels are in fact attached to each control. I know when I created the first field on this form I pulled it from the field list, so it had a label attached to it then. Every field after that has been a copy of the first since I have some different font stuff...
  13. SemperSalvus

    Help With Repetitive Code

    TheAceMan1: Ok sweet! I never realized I could use the .backcolor and .forecolor properties so simply. Thanks.
  14. SemperSalvus

    Help With Repetitive Code

    traingamer: Ok, I got it to work. Here is what I used. Private Function colorit(strArg) Dim ctl As Control For Each ctl In Me.ActiveControl.Controls With ctl Select Case .ControlType Case acLabel If strArg = "G" Then .BackColor = QBColor(2)...
  15. SemperSalvus

    Help With Repetitive Code

    traingamer: Ok, I see now. I will give that a try too. puforee: traingamer is right. The conditional formatting won't work since I am changing the colors of the label. I tried to format the list box values, but because of the way access uses highlights, it didn't look good at all. For...
  16. SemperSalvus

    Help With Repetitive Code

    traingamer: Thanks, but that seems like too many iterations. I don't need it to check on each control when one control is updated. I just want it to immediately change the color for the control that had a value changed. Most fields will default to green which assumes that most everything is...
  17. SemperSalvus

    Help With Repetitive Code

    If I can, I need to streamline this code. I am using a tab control to manage several hundred fields for an inspection application. Many of the fields have a "green, yellow, red" state for the inspector to choose, depending on how good or bad the particular inspection item is. The table values...

Part and Inventory Search

Back
Top