Search results

Good day. Either I'm not interpreting the BeforeUpdate event docs correctly or it doesn't work as described. Here's a line from the docs: Sorry, I don't have enough posts to be able to post links but it is the Form.BeforeUpdate article in the standard Microsoft documentation. The following...

I actually had tried to set the focus on the control and call .Requery but it still displays no value at all, not even the 24.0 the debugger shows is being held in the control's .value.

Thank you. Yes, that does work. I think that workaround will have to be the quasi solution. It appears the .Requery method doesn't work when called manually, which is frustrating.

Thanks for all the answers I've found here over the years. Now I have one that I can't seem to resolve just from information already posted in the forums. I have calculated textboxes in the footer of a form to sum the data in the detail section. The data is stored on SQL Server. Over the LAN...

I'm pretty familiar with the color codes. The hex value #000000 should be black, vice grey. I was able to post an image... had to work around our corporate restrictions only to realize I have to have 10 posts to post a link - argh! Here's the text of the link anyway. tomusn.com/images/borders.png

Using Access 2010. I have a form on which I've placed a simple label. I try to set the label border color to black but it shows grey. I can set the border color to #000000 and it's grey. I set it to #000001 and it shows black as expected. I'm thinking it has something to do with the themes, but...

Hello, my name is Tom Wiley. I live and work in Pensacola, Florida, USA. I build computer training products for a major IT company. I have been tasked with a few Access projects and have almost always found the answers here after a Google search. So, THANKS to all the contributors. I joined...