Search results

The Large Number data type is not very well supported in VBA. FWIW, I am using 32-bit Access 365, with support for large numbers checked. Assuming I have a string value and I want to test if it is a valid Large Number, how would I do it? Large numbers pass IsNumeric - good, but the below...

(cross-posted in Access MVP email list) Environment: A365-32. Some variables have a VarType of vbString (8) and I can pass them to a function that takes a Byte array as argument, and some have the same VarType value and trying to pass those gets a compile error: Type mismatch: array or...

I play the Wordle game with friends (where you get 6 chances to guess a 5-letter word), and on Sundays one of us comes up with the Starter Word for the first guess. I wanted a football-related word and asked the Google AI on my Pixel phone. This is what it came up with.

A365-32 semi-annual, v2408. Using classic SQL editor. Experiment 1: Select CSng(Nz([Ingredients].[MaxQty],[Ingredients].[Qty])) AS IngredientQty From … Experiment 2: Select Round(CSng(Nz([Ingredients].[MaxQty],[Ingredients].[Qty])),3) AS IngredientQty From … Both return the exact same value...

I like to know who I'm talking to, but some users choose names that hide their identity. They should be able to do that, no problem. But it would be nice if I could add a nickname to any user's name, to remind me of who they are. This would not breach confidentiality, no user is required to...

NW2 Dev Edition has a ribbon with a dropdown showing MRU items. I'm re-using that concept in my own app. When you drop it down and select the same item as is already selected, the Change event does not happen; no event happens whatsoever. If it was a textbox, you could Invalidate the control and...

The Find feature works differently for combobox with value list and with query. See attached for a form that implements it both ways. MSFT has indicated they are willing to reconsider that behavior, which is NOT a guarantee it will be changed. The question is: for the value list scenario, do you...

I'm writing a tool window, a filter form for Continuous Forms, similar to what MSFT implemented for Datasheet (the downward pointing triangle). If you use that feature in Datasheet, and you click outside of it, it disappears. Of course MSFT's version is not an Access form, but something fancy...