Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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'...

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)...

That is sweet. Thanks!

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...

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

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)...

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...

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...

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...