Search results

A very simple subform that gives you a tick/cross box! Change the size of the area the subform takes up on the parent form and it will scale up/down to fit. It will fire an event if you want to use that style of coding. Enjoy!

Hi, Has anyone found a way to create a list of fonts in their corrseponding font. The list is obviously very easy. But a list box or even a treeview control does not allow each item to have a different font! Simulating a list box with text boxes and a scroll bar is a huge job and I want to be...

Hi, I was rumaging around in Microsoft Access (2019?) using the Object Browser and it came up with this message: Cannot jump to '(xx...xx)InForm because it is in the library 'ActiveX Controls in Access' which is not currently referenced Fine! But how do I find the DLL/OCX/etc...

Hi, Please don't laugh! Given a string entered by a user how can I verify whether the path is a valid one. NOT that it exists or not, but is the syntax correct and idealy that the drive or UNC path exist. I have seach the web and even asked CHATGP4 but all 'solutions' just check if it exists...

Hi, Does anyone out there have a (complete) list of the possible Attribute statements and what they all mean? Cheers Martin

Hi people, I am sure I am being massively stupid but I have a problem with a very simple (testing only) query. The query: SELECT [Recipes plus category summary].[Recipe ID], [Recipes plus category summary].Expr1 FROM [Recipes plus category summary] ORDER BY [Recipes plus category...

VBA, Access Forms, 2019 Hi, I have my doubts as to the solvablity of this one. I have a form with many (too many most would say) sub-forms each displaying a potentially large JPG. Its intended to be a page of thumbnails that will be resizeable. Problem With NO resize events anywhere when I...

Hi, VBA Access 2019 I want a set of thumbnails displayed with text underneath and for the one under the mouse to be highlighted. I have an unassociated label (I have tried a text box etc with no change) which holds the text and I change the background colour using mouse move etc. Over the top...

Hi, I can't seem to find any help on this issue on the net. I have a multi-column listbox and have set horizontal anchor to both. The listbox is widened but the columns stay the same width. Accessing the width of the listbox at run time only returns the designed width not the current actual...

Hi, Here's an interesting problem. First though I can find many other ways to solve this problem, its just that I can't get THIS way to work which is odd. I am using a QueryDef and setting a parameter to set the order by clause and then setting the the ListBox's record set to the...

Hi, I'm using InternetGetConnectedStateEx to get the name of the current Internet Connection. Apparently randomly it will not return the correct connection name. Instead it returns 'LAN Connection', if the LAN is enabled, or 'none' if the LAN is disabled. I can find no consistency to the...

I have a strange 'bug'. I wrote a query to return the TOP 32 items for a key. Works fine:- SELECT TOP 32 [my Disks Coefficients sub].[thier Disk ID] FROM [my Disks Coefficients] AS [my Disks Coefficients sub] WHERE [my Disks Coefficients sub].[my Disk ID]=1 GROUP BY [my Disks Coefficients...