Search results

Yes, If the checkbox is unbind, the on_Click action triggers the function. Since the record source is read only, I'm not able to update the records. Anyhow I need to be able to update that checkbox. Well if I can not update the field, I tried to use a function that is fired when I click the...

Million Thanks for suggesting. It was exactly what @theDBguy suggested. Done.

No, it doesn't.

Very clever. never thought of that. While I will use this for my database, but my intention of posting this question mostly was understanding why on-click event is not fired, even if when I'm clicking the check box. Million thanks for your time.

As I explained above, the checkbox doesn't get updated because the source is a cross tab query. If the checkbox doesn't update, its on update event is not fired.

I could reproduce it in another database too.

I attached a sample database to the first post.

The recordset is not editable. So the checkbox never get updated. ( I believe. But will test it too. wait) Edit : @theDBguy As I had guessed, the function is not triggered because the checkbox is not updated. thanks anyway.

The back end is sql server. It takes a while to manage the local tables and the crosstab query with a limited data set. Give me a little time.

One click on the checkbox sets the focus on the checkbox. I can say it by the rectangle that appears around the checkbox after one click. So I don't think there's anything there to prevent the checkbox focus. If I add the function to on focus, the function is triggered and executes. So...

I have a form with a crosstab query as its source. The query and the form's data is un-editable. I want to run a function when I click on a check box on this form. But clicking the checkbox doesn't fire the event. I added a stop, a msgbox and a break point to the first line of the code, but...

@Isaac I can't judge for others. But for me, I appreciate any reply you post. Not only your replies help me understand the situation, but the way I see you, you are one of those rare members here that sees (or tries to see) both sides (Rep, Dem) fairly and judge according to what you feel, not...

@The_Doc_Man In case of the link you posted about gun laws in different countries, there was something I want to add to Japan's section in that article. 1- Most of our policemen/policewomen doesn't carry guns at all. Most of the rest who carry guns, their weapons are not loaded. It means they...

Doc, you were and are excellent in answering my questions. If I insist and go round a circle and insist on my own beliefs, It's not because of your insufficient reply, but simply because of our cultural difference and it takes a little time for me to be able to stand in your shoes and see the...

on topic: https://www.engadget.com/virginia-covid-19-apple-google-exposure-notification-sytem-210500036.html Virginia's COVIDWISE app is out of beta and available on both mobile platforms. The Virginia Department of Health has launched COVIDWISE, an app that uses Apple and Google’s COVID-19...

@The_Doc_Man @Isaac I think I'm going too much off topic, but I will ask it. I'm sitting here thinking about your replies and try to understand what was explained. But there are too many questions that bother me. What does tyrannical government means at all? I know the meaning of the phrase...

@The_Doc_Man Million thanks for the detailed reply. I actually didn't know lots of what you explained about your history. It was a good read. I had to go through it three times to be sure I understand the situation. In case of your question about our knives and swords, I don't go into details...

We never know how and when we loose the control over ourselves. The other day I saw a clip in Instagram. A man bumped into another one, an argument started and suddenly one of them drew his weapon and fired. One was sent to a hospital the other to jail. And I'm sure one of them regrets why he...

This is meant to be business. It makes us to buy a new one if the procedure of replacing/repairing is difficult. and that's what the manufacturers are after.