Recent content by Martin Beney

  1. M

    Verify a File Path

    Examples? You must be kidding... Here is some code that at least is a good start, but needs expansion... Function IsFilePathNotValid(FilePath As String) As Byte ' formats ' <=255 chars ' split at \ ' each elemnt ' not null apart than first ' none of these chars '...
  2. M

    Verify a File Path

    Valid is that it CAN be used to create a file, whereas Exists is that it is currently extant. Existing is easy therefore. What is difficult ir seems is Valid. I want the user to be able to enter ANY valid path name, with a drive or a UNC or just the default and then the rest of the path.
  3. 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...
  4. M

    Solved Attribute VB_???

    Interesting if I didn't know all that. I wanted a list of Attributes not a disciption of attributes in general...
  5. M

    Solved Attribute VB_???

    Don't worry found a list:- https://vbaplanet.com/attributes.php
  6. 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
  7. M

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

    DOH! Min and max solve it. I am not having a good day!! Many thanks guys Martin
  8. M

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

    Hi, Thanks. The record is indeed the first in the source table. I thought that first referred to the order in the query! That makes it rather hard to get at the items I want,,,, Guess it down to write it myself in code - bother. Thanks again for the info. Martin
  9. 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...
  10. 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...
  11. M

    Control 'Flickering' Problem

    Hi gemma-the-husky, Just to let you know I tried the text box idea but when locked and not enabled the mouse events don't fire (of course, its not enabled) so that ones out too.
  12. M

    Control 'Flickering' Problem

    Hi isladogs, I know the documentation says App.echo=false stops ALL screen painting but it does not! Changing the background colour of a label behind an image causes the image to repaint/reload (not sure which) and this is visible even with echo off!!! All I need is a way to turn painting off...
  13. M

    Control 'Flickering' Problem

    Anyone any idea why turning off echo and painting doesn't work - anyone any work around?
  14. M

    Control 'Flickering' Problem

    Thanks for the links. Will have a good old read.... Cheers
  15. M

    Control 'Flickering' Problem

    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!!!
See more
Top Bottom