Search results

@Pat Hartman - That does look quite useful. As for what I am trying to do. I am making toggle buttons more visually clear that they have been selected. Instead of varying the "pressed" color only. I wanted to dynamically change the bezel appearance of the button to one that is pressed...

It's one of those unexposed properties that you can set via vba. Where is the comparison being made in your code? I see placing the frame value in the variant variable. I see cycling through the controls in the frame. I see you checking for control type. I don't fully understand ctl.Bevel =...

@moke123 - My code works a lot like yours. @cheekybuddha - I'm going to have to unpack your code a little more. I think I understand teh concept...

I was trying not to hard code each individual button status into the update event. but, that might be the most expedient way.

For posterity, I put a debug.print in the toggle button "BeforeUpdate, AfterUpdate, Click" events I put a debug.print in the opton group (frame) "BeforeUpdate, AfterUpdate, Click" events When clicking on a button on a form only the option group events fire (as @moke12 correctly stated)...

@moke123 - My apologies. I did not read clearly enough. You are correct. Also, whoever wrote the MS help file....sheesh. You don't copy and paste the same thing with a little blurb at the top that says "by the way, doesn't actually apply to what you think it does...." You put a blurb that...

@moke123 - I'm not sure what you are referring to. Both the frame and the toggle have click events. I can select them in the VBA editor and its referenced in the MS help file. I'm probably trying to do this a complicated way, but my question is also intresting (curiosity and all that). I...

So, here's an interesting one. What is the order of exectution of OnClick events when a toggle button in an option group is selected? Per MS, the Option Group frame OnClick event fires in the order of BeforeUpdate/AfterUpdate/OnClick. But, the info on the OnClick event for an individual...

Well, guess I need more coffee. I was selecting the radio buttton, toggle button, etc controls as opposed to the Option Group control which dutifully launched the wizard. That does seem like a curious differentiation. In any case, dilemma resolved. Thanks!

My wand is highlighted as well. Not sure why the option group wizard isn't launching.

I have the form control wizard toggle turned on, but when I go to create an unbound option group the wizard doesn't launch and I just get one radio button as part of my option group. I'm sure I can figure out the manual way to add more eventually, but, it would be a lot faster for the wizard to...

Private Sub btnEndTime_Click() Dim dt As Date 'Set the value to the current time Me.EndTime = Now() 'Update the site time text box If IsNull(Me.StartTime) = False Then dt = DateDiff("n", Me.EndTime, Me.StartTime) Me.txtSiteTime = dt Else 'Nothing End If End Sub Took out the...

I think I've made this same mistake about 3 times every time I go to do something like this. I wonder where I got that idea in my head....

I have a button that is going to use DateDiff to calculate service call times. I put a basic check in to verify that there are values in the two fields but it doesn't seem to be working as intended. I fear this is something super basic, please help. Private Sub btnEndTime_Click() Dim dt As...

Hm...no active directory makes this interesting. With no server overlord I wondered if both computers need to match settings (i.e. allow networked trusted locations). Full disclosure that I'm just thinking out loud, not providing you definitive answers. Is this an Access related question? I...

You said you are browsing to another PC. Is this a server or a personal computer? Have the appropriate settings been toggled on the host computer also? There may also be a group policy overriding your individual policy of allowing network locations.

Thank you for the link. Just an fyi, unless I'm doing something incorrectly, I get a 403 error on any of the download pages for your utilities.

I could also write a blog post about experienced users not reading entire threads before replying and answering what they THINK is being asked instead of what actually is being asked? ;) Just to be clear, I'm being intentionally feisty, but not seriously :)

Again, I don't know if I misspoke earlier, but, I have no intentions of editing an active BE, only the development BE. Thank you for the warning.

Well, that is the epitome of a brain cramp on my part. I don't know why I was using File > Open. I rarely use that in any other Office product. In fact I use right-click on the taskbar to open recent spreadsheets literally EVERY DAY! 🤪 No wonder I had everyone confused. Trivial indeed! 😑