Recent content by CJ_London

how the fairy came to be on top of the Christmas tree.

try setting the form autoresize to yes

what about if there is just 1?

confirmed - potentially it could be null for a new record, but when saved it will save as 0. If the field default value is set to 0 then it can never be null (unless your are in the table and swipe left) but it will still save as 0. The only time a checkbox on a form can be null is if it is...

I misread the OP’s post, thought they were trying to populate an image control based on this line in the original post Lvl1Img = Lvl1Ck

You should be using . Rather than ! And perhaps use the picture property rather than controlsource Me.Lvl1Img.picture = Me.Lvl1Ck.picture

We understand that - that is how those API's work. So the question is does your query, when you filter it with prm produce more than one record? If it doesn't then you don't need that loop. And ' somehow it does not work' does not help us to help you. What does it mean? you get an error? in...

Why do you need a combo box? Why not just loop through a recordset the same as the combo rowsource? Or just loop through your querydef - probably need to to remove the prm

Do be aware that classic outlook will cease to exist (or at least not supported) in I think 2029. Although Classic (i.e. the outlook application) is still available, at some point you won't be able to download it. For individuals like yourself it is not likely to be a major issue but if you are...

for CDO Account is your email address or user name for sending, Server will be something like smtp.gmail.com Port will be something like 465 Authentication is your password some email servers require what is called an app password, all depends Basically the same information as when you set...

If you are just sending, there is also CDO. Plenty of examples if you google - here’s one https://www.devhut.net/vba-cdo-mail/

May be missing the point, but you can use the timer event - away from my computer at the moment but set the timer for say 1/2 second. Reset the timer on each key press. If user hasn’t typed anything for 1/2 second, assume they have finished

not sure how many fields you can have in a composite unique index (certainly more than 2) but what I have done in the past is hash all the relevant fields and store the hashed value in a unique indexed field

Perhaps clarify what you are trying to do and how - seems like your issue is when clicking on the combo down arrow? And the after update on fires if the selection changes