Search results

unfortunately you've used hyperlink datatype. see this link - https://codekabinett.com/rdumps.php?Lang=2&targetDoc=access-hyperlink-data-type It's much easier to use plain text to store a path and vba to follow it.

Here's an example i made for someone on another forum. It does not store the path to any files. when the database is opened it creates a folder named Clients in the same folder as the database. When you enter a new client and open the client form, it will create a folder for that client within...

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