Search results

Sorry - read the description. The label is there to highlight which picture (in an array of thumbs) you are hovering over - like file explorer does!!!

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

Found a solution. Yes you can change columnwidths in code the problem was to find the values to use. I eventually found that a Form's InsideWidth always returns the expanded width whilst a Form's Width returns the design width. So a simple ratio can be used to change the column widths of a list...

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

When I say the parameters clause does not work I should have explained it fully. I have tried making the query a parameter query and then used the commented line to set the parameter. The recordset's sort was not used in this case. When that failed I removed the parameter clause from the query...

For what its worth the code is:- Private Sub Sort_By_List_Click() Dim wQueryDef As DAO.QueryDef Dim wRecordSet As DAO.Recordset Set wQueryDef = CodeDb.QueryDefs("aQuery") ' wQueryDef.Parameters("sortByClause") = Me.Sort_By_List Set wRecordSet = wQueryDef.OpenRecordset...

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

Neil, Have created a stripped down db but still over 1MB so can't upload. But more interestingly may have found the problem (bug I think). To set up the mini DB I imported the main table (which I had addd a lot more rows to) and then deleted all except [my Disk ID]<=10. Fine so far. At this...

Neil, Will try and strip down a copy of the db...... A day or two maybe.... Martin

Hi Neil, Can't see how I could join the two queries. What I have is a whole lot too much data for each set of [My Disk ID] & [Thier Disk ID]. The query is trying to get the lowest 32 coeffiecients with their associated [Thier Disk ID] for each [My Disk ID]. It therefore calculates the set of...

Hi Neil, The aliases are needed to get the ID from the encompassing query into the subquery's criteria, otherwise you can't reference the outer query from withing the subquery - does that make sense? Martin

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