Recent content by Martin Beney

  1. M

    Prettier and Scalable Tick and Cross Box SubForm

    Hi, Should work o a subform without problem, tell me if you find one..... For a continous form I very much doubt it. If a control isn't bound to the rowsource then it acts 'funny', there is effectivey one copy of iit that applies to each row, changinng one changes them all. And I don't think...
  2. M

    Prettier and Scalable Tick and Cross Box SubForm

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

    Font List in font style

    Thanks for the suggestions. The opening the font picker will do perfectly.
  4. M

    Font List in font style

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

    How do you find which DLL to add to References

    Very informative!
  6. M

    How do you find which DLL to add to References

    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...
  7. 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 '...
  8. 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.
  9. 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...
  10. 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...
  11. M

    Solved Attribute VB_???

    Don't worry found a list:- https://vbaplanet.com/attributes.php
  12. 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
  13. 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
  14. 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
  15. 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...
See more
Back
Top Bottom