Mysterious List Box

[mcmichael13]

Hey, I have a form that is used to update previous entries to the table... that way when RMA's are received or closed, that information can be added.

For some reason when I type in the RMA number (which is my primary key) and hit "Look Up"...

it looks up all the fields for the table and puts them to the correct box, but the fields that are list boxes go black to match the background color of the form. anyone know why it would do this?

Thanks

 

[mcmichael13]

another issue is that when i update an entry that doesnt exist yet (because the entry was skipped for whatever reason)... it wont add that entry even though all the steps are performed with no error.

 

[RuralGuy]

What version of Access are you using and is the patch level up to date?

 

[mcmichael13]

oh sorry, i'm using acess 07

 

[RuralGuy]

Do you have Office 2007 SP1 applied along with the HotFix? Did it ever work correctly?

 

[mcmichael13]

a lady was using it yesterday with no problems... i just designed this program and we are just testing it out now, today we are having issues.

i honestly dont know what version SP we have and if any hotfixes are installed... I just started here as an Engineering Co-Op.

 

[RuralGuy]

i honestly dont know what version SP we have and if any hotfixes are installed...

Here's a link that can help.

 

[RuralGuy]

Office 2007 SP2 was just released on April 28th. It has a known bug where the Nav pane on the left no longer displays the Description field when you set it to View Details. Other than that I'm sure it resolved some other issues.

 

[mcmichael13]

We have SP1...

 

[mcmichael13]

oh and i solved the second half of my problem...

i forgot to add the "INSERT INTO" of my sql... so it was only updating current records, but couldn't create new ones that were skipped... thats all solved now

 

[RuralGuy]

Any chance you can post a sample of your db that demonstrates the issue? It is hard to say what the problem might be from here. Remove any sensitive data of course but leave enough sample data to show the problem.

 

[RuralGuy]

We're working on this off line right now. So far this is an unbound form with unbound ComboBoxes that are acting up. Will post back when we have a resolution.

 

[mcmichael13]

hey thanks a lot... i guess when learning i didnt know the difference between "bound" and "unbound" and figured i just had to code everything... so, the "update RMA" button is no longer needed?

 

[RuralGuy]

hey thanks a lot... i guess when learning i didnt know the difference between "bound" and "unbound" and figured i just had to code everything... so, the "update RMA" button is no longer needed?

That is correct! With some rare exceptions, I have yet to find a situation where a bound form will not work. Access does all of the work for you and no coding required. You should also know that setting the DataEntry property to YES causes the form to only display NEW records. As soon as you save any new record, it "vanishes" from the display. Have fun.

 

[mcmichael13]

instead of a listbox, what if i wanted the user to be able to enter the RMA number then have everything come up... how would that be done?

 

[RuralGuy]

instead of a listbox, what if i wanted the user to be able to enter the RMA number then have everything come up... how would that be done?

To set the record straight, those controls are ComboBoxes and not ListBoxes. I forgot to say that earlier. You can type in a ComboBox just like a TextBox. Are you talking about forcing the user to enter the RMA blind; with no help from the control?

 

[mcmichael13]

also, it seems the "black" is still a problem... when i select an RMA number from the drop down menu.... then click on one of the fields to change it... the RMA list box field goes black...

 

[mcmichael13]

To set the record straight, those controls are ComboBoxes and not ListBoxes. I forgot to say that earlier. You can type in a ComboBox just like a TextBox. Are you talking about forcing the user to enter the RMA blind; with no help from the control?

oh right, yes, i just saw a list and thought "list in a box" haha. but i see it is a combobox.

I just realized I can type in there too... nevermind, thats even better

Thanks a lot, but still the black issue...

 

[RuralGuy]

You're right about the black issue. Hmm...that's where we started. Does not seem to be a problem when you use a licht background for the Detail section of the form. I'll keep working on it.

 

[mcmichael13]

what is happening is the background of the combo box is becoming transparent to the background of the form... i just dont know where that setting is to change it