Search results

  1. M

    Verify a File Path

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

    Solved Attribute VB_???

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

    Solved First() and Last() seem to be wrong way round

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

    Prevent Access forms 'hidden' processing on resize

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

    Control 'Flickering' Problem

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

    Listbox columnwidths with horizontal anchor both

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

    Sorting a ListBox

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

    InternetGetConnectedStateEx Returns wrong value (sometimes)

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

    Wrong Number of Rows returned by Subquery with Top Clause

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