Search results

A lot depends on how your file folders are set up and how your Pdf's are named. I tend to have one main folder with subfolders. The subfolders are named for each client and hold just the files related to that client. That way I don't have to store the path to any file or worry that any 2 files...

Might depend on how you broke them.

Dirty only happens when you Dirty the form (make an entry) try the current event with Me.OT_Hours = Null

DIr() or my function?

to get filename from Path: Function LastElement(StrIN As String, Optional Separator As String = "\") As String Dim var var = Split(StrIN, Separator) LastElement = var(UBound(var)) End Function

MDB version

I would assume you would want to open the file from the listbox also. You need a list box with a couple columns and set your column count and widths to hide the path. something like this

I think the path is C:\Users\ {Your User Name} \Pictures. You can get it with : Option Compare Database Option Explicit Declare Function Get_User_Name Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, _ nSize As Long) As Long Function GetUserName() As String...

Another quick and easy reference https://www.techonthenet.com/access/functions/index.php

In case you missed it - https://www.access-programmers.co.uk/forums/threads/access-europe-user-group-wed-2-apr-class-modules-how-why-and-when-to-use-them-in-the-real-world-anders-ebro.333737/

Yes and the floor under the green moves around to give the green different contours.

Glad to see you've stuck with it. Have you seen the new TGL golf? It's like a mix of VR and real life.

I struggled to wrap my head around classes for a long time until MajP posted some code which somehow made it make sense. I owe him props for that. Ever since I always try converting things to classes just for fun and as a learning Tool. The things you learn along the way are invaluable. I...

Just be aware of a little quirk with a single value listbox. If you set the value with code it can return that value even though it is not in the listbox.

sounds like you may want a data macro on the table.

I don't see your test code above in the example and I'm not sure what your trying to do. It would seem you could just use the onload event to do all those things without iterating through the controls using got focus. TempVars!Genus = "Acacia" TempVars!Species = "binervia"...

It's collateral damage. https://apnews.com/article/trump-science-medicine-research-cancer-funding-university-0ef3fa47694784e47b0ecd51680410ba https://apnews.com/article/trump-nih-medical-research-funding-cut-indirect-costs-e7629d0d45d141b2ac47c54550411aff

here's a quick example of the method DHookom suggested

From what I understand you can't even buy a cyber truck in the UK. https://www.bbc.com/news/articles/cz0lldd30xlo...