Search results

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

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!

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

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

Very informative!

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

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

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.

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

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

Don't worry found a list:- https://vbaplanet.com/attributes.php

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

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

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

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

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

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

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