Thats awesome MajP I wondered in the table you were pulling the data from it has 6 fields are those necessary? As the table I want to pull from only has the Id field and the name field. Thank you very much that will work great.
I have a table with a list of names.
on the form I have 4 combo boxes all pulling from the same table. Is there a way to remove a name from the next combo box once its been picked in one of the other combo boxes?
Ok cool thanks MajP I knew it was something so simple. i went and tried changing the queries with no luck. I realize the dbase is in rough form but I am open to good ideas if yant to share with me.
So in all my attempts to try and achieve with the whole hiding buttons thing I have now abandoned. I could not get it to work. will some one tell me what i have to change to get the cbobox to write the name in the saved players table in instead of the ID
So in all my attempts to try and achieve with the whole hiding buttons thing I have now abandoned. I could not get it to work. will some one tell me what i have to change to get the cbobox to write the name in the saved players table in instead of the ID...
Ok CJLondon that makes sense I had planned on setting it up on the after update of the cbobox to docmd.save which works nicely I had thought of having a txt box sitting over the cbobox and on the after update bring it forward so it shows the text box which is linked to the table with...
I guess I am not fully understanding your point, when I put a name in the cbobox its there and when I close the form the data is written to the table but the cbobox come up empty upon reload. I have the form bound to a table (the table I want the data written too) and the control...
I am fine with the user changing the information in the cbobox but what i dont want is it cleared out of the box by closing a form close or a refresh or closing the database. I will be using a delete query to remove the data out of the tables then those boxes will be empty
Pbaldy was spot on and gave me the answer. thank yor for that. but it revealed another bug that i have to over come. I want the combo box to remain with the chosen data until I want it remove the data from the table. I know combo boxes are not designed to do that. so I am looking for...
I am new to this here fine blog, I am not real familiar with where to post what? I have a question on how to get a combo box on the after update pick from one table and save it to another table. So where would I post this or how would I know this has already not been addressed some...
I finally got it LOL
Private Sub cmdSaveRecord_GotFocus()
Me.cmdSaveRecord.BackColor = RGB(49, 159, 52)
End Sub
Private Sub cmdSaveRecord_LostFocus()
Me.cmdSaveRecord.BackColor = RGB(59, 77, 209)
End Sub
Is there a way to use hex colors in VBA
yes but only if I use the command Me.cmdCloseForm.BackColor = VB(something) but the colors I want to use is #319f34 how do I tell VBA to use that color I don't know what its name is. and then on lost focus tell the button to turn back to its original color of. #3B4DD1
Help me I am still stuck still if I have a hover color of #319f34 how do I tell VBA on GotFocus of the button to use the same color and then on lost focus tell VBA to return the button to its original color. What is the code I would be using?
OH yes the compile thing I forgot about that. that totally makes sense. I will go try it I did go remove the button and was able to get it working. Of course one my worst nemesis is what I dont know about programming is not helpiong me much LOL thanks for all the help :)