Is it possible to have conditional formating to a dropbox that is populated by a query? ifso, does it have to be based on the bound column? or can it be from an unbound column? but not the bound column
@599CD6 ай бұрын
599cd.com/try
@ZahidKhan-mb6oc2 жыл бұрын
Fantastic idea. Thanks for guideline.
@599CD2 жыл бұрын
Welcome. :)
@michaelrstahl41952 жыл бұрын
Cool Video. Love it!!!
@599CD2 жыл бұрын
Thanks
@VincentAu-un6nq Жыл бұрын
Can I please ask how you color the whole ID column? Was it also conditional formatting with always true condition? Or was it just BackColor? I don't think we can set BackColor for datasheet. Thanks.
@599CD Жыл бұрын
Don't use a datasheet, Batman. ;)
@VincentAu-un6nq Жыл бұрын
@@599CD That's right. Thanks very much!
@howardfreedman57132 жыл бұрын
Thanks for this video. It's the first I've watched one of your videos and I enjoy the way you present. I have a question. I want to concatenate two fields on a report with a comma in between. However, if one of the field is null, I don't want to see the comma ie the &", " should not be displayed. Can this be done outside of VBA coding? Please help.
@599CD2 жыл бұрын
Sure. Use Null Math or the IIF function: 599cd.com/IIF
@howardfreedman42892 жыл бұрын
@@599CD Yes, after I left the comment I found a video on using IIf to handle this which worked perfectly. Thanks again! btw, I don't use Access that much, only this one db for work. If you ran a similar site for Python/Django, I'd sign up for sure. I think this is great!!!
@Ryhor12 жыл бұрын
Conditional formatting loads the system very much. Are there ways to optimize conditional formatting of large tables for fast and convenient operation?
@599CD2 жыл бұрын
Not really. Just try to display as few records as possible if you have a slow connection.
@Ryhor12 жыл бұрын
@@599CD I understood my problem. Slow formatting was due using dfirst/dlookup, but it is better to create a regular query and in the formatting expression make a link to the necessary field. Now it works very quickly. 100+ records table with 60 fields and 10 formatting conditions on each field is ok.
@janniepotgieter58952 жыл бұрын
How do you conditional formatting on different % for instance 50% or less must be red and 50% or more yellow
@599CD2 жыл бұрын
Just remember that percentages are fractions of 1. So 50% is actually 0.5
@ManiacalMangoes Жыл бұрын
Love your videos. I had conditional formatting on a form field that used a look up. If they pick good, it turns green. If they pick bad, it turns red. It was working fine and now all of a sudden it’s not working. The fields are set to normal, not transparent and the selectable value and field types are the same as before. Any idea why it may have stopped working?
@599CD Жыл бұрын
No way I can tell from here. Sorry. Feel free to submit your question with more details (including screen shots) here: 599cd.com/KZbin-Submit-Question
@djl523 Жыл бұрын
While probably obvious, when something like this happens to me, I go back and look at recent changes I made. If you have a backup of your database and reports from when it was working, compare the two and chances are you will find the reason pretty quickly. Good luck!
@LadyCrockettCrafts Жыл бұрын
This video is showing up glitchy for me :( Love the videos and want to be able to watch this one too!
@599CD Жыл бұрын
It's gotta be KZbin or something on your end. If there's a problem with a video, I get dozens of complaints. See 599cd.com/cache
@LadyCrockettCrafts Жыл бұрын
@@599CD I figured out it was the "Auto" video quality selector on YT. I changed the setting manually and it worked! I've learned so much, thank you!!
@luciianalugo52202 жыл бұрын
Hi, I Need to connect SAP with access and dowloand the information to diferente tables. Can You Help me? How can I contact You?
@599CD2 жыл бұрын
I don't offer consulting, but you can see this page for more info on how to get help: 599cd.com/DevNet
@ibaradah Жыл бұрын
thank youfor your effort to learn ACCESS DataBase ,Sorry To Disturbing you Please could you Help me How to use the VbCODES OR the Conditional Formatting between tow feilds inTEXT insted of No.I have Db tow Feilds both are text,the first is The Name ,And the sec is The Result (Yes\No), What I need ,When I check yes the background of the feild Name will be in GREEN color ,And when check No the background of the feild Name will bein RED colr....thank you again
@599CD Жыл бұрын
Check Box Color: 599cd.com/CheckBoxColor
@imstevemcqueen2 жыл бұрын
the video is blurred
@599CD2 жыл бұрын
Must be on your end.
@user-vh6uo2el7r2 жыл бұрын
Hi I am one of your followers on KZbin Is there away to update products prices at once from calculated qury mohammed,from yemen sana'a