Search results

There is a new blog post here. Apparently, they decided to incorporate in Canada and work the project full-time. I think that's great. Seems to me it's not as big of a project as twinBASIC (going on 4 years), but still substantial. Let's see where they are in 18 months.

I downloaded @MajP excellent treeview example from here. I run frmDemo, select "Show Checks", and check the box for Dr. Andrew Fuller. I answer Yes to check the descendants, and then expand the node to see the result (see screenshot). Not all descendants are checked. I believe this is a...

In Report_Open I have: Me.Filter = "EmployeeID = 1" Me.FilterOn = True For example, you can paste this in Northwind Dev edition rptSalesByEmployee. Set a breakpoint on the next line. Observe that FilterOn is still False. Why is that? And the report is not filtered. I know there are other ways...

In a Continuous form, if we want to change the RowSource of a combobox for each row, we can overlay that combobox with a textbox. An example is implemented in NW2-Dev, Order form, Order Line Items subform, the Product section. The textbox shows the value for the non-current rows, and the...

Access splitforms have their issues, so I wanted to write my own lookalike. Open mySplitForm, and observe you can navigate using the mainform, or the unbound listbox. To make this a generic module I am using form subclassing. So far so good. Now filter the mainform. You will get an error because...

I expected this to fail compilation on the indicated line. Decompile did not make a difference. This is A365-32 MEC. I was using a test module in Northwind 2 Dev Edition. Sub test1() Dim db As DAO.Database Dim td As DAO.TableDef Dim qd As DAO.QueryDef Set db = CurrentDb...

If SQL Server is the back-end (BE), we can link to tables and views. Views are like queries. However, if Access is the BE, we can only link to tables, not queries. My form is listing BE objects and I have a "View Data" button. When clicked, I link to that table, and use DoCmd.OpenTable to view...

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...