Recent content by June7

Which only adds to the confusion. I consider a "single quote" as " and a "double quote" as "".🙃

Note, these are not "single inverted commas", they are apostrophes.

Please post code between CODE tags to retain formatting and readability. Probably shouldn't even maintain a "Stocks" table. Review http://allenbrowne.com/AppInventory.html Why are you using Str() function? Are those ID fields text type? If they are not, don't use apostrophes. The posted code...

Are you sure you can't use your 2003 custom menus in an accdb? Review https://support.microsoft.com/en-us/office/use-the-custom-toolbars-and-startup-settings-from-earlier-versions-of-access-eeea8c31-c2fb-4f36-81a7-7886e168a2c8 It's not clear to me what you are asking for. If you need images of...

John, I think Colin is wondering why the title bar is a dark green. My popup form shows a very light green.

If by "brackets" you actually mean "parentheses", use Format property. Review https://support.microsoft.com/en-us/office/format-a-number-or-currency-field-e48f2312-67f0-4921-aca0-15d36b7f9c3b #,###.##%;(#,###.##%);0,000.00 or if you really want brackets #,###.##%;[#,###.##%];0,000.00 BTW...

1. I don't think so 2. Look at the form BorderStyle property

Actually, on second thought, I must have been hitting the button control itself, not the form background.

Be aware clicking between controls onto the form will cause button (or whatever is used) to show up over other controls.

Did you see post 5? The "code" is the Conditional Formatting rules. Use of Access 2003 is not issue.

If you want to compare to cost, need to modify each conditional rule to reference appropriate field or control or expression in place of of "0". Possibly: [Stop_Current] > [TotalCost_$] AND [Text523] > [TotalCost_$] [Stop_Current] < [TotalCost_$] AND [Text523] < [TotalCost_$] Expression for...

This rule also worked in my test of combobox: In (-1,0) Or Is Null

I tested with Colin's app. I cannot use CDO with Outlook any more. Been a while since I tried but as I recall this requires some kind of account I can't have as an individual. However, I can get CDO to work with Gmail. I did have to set up a special Google account. Although, my phone email app...

And the zombie phenomenon should not apply with SQLServer backend? Perhaps we can track down issue with db. Make copy of frontend and import relevant tables.

Review http://allenbrowne.com/AppInventory.htm