Search results

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

stupid question.

The 2 girls in our school, one who happens to be the daughter of a close friend of mine, have a separate changing area. It's called an accommodation.

I suppose you never considered that societies evolve and those "norms" may evolve with them. Respect others as you would want them to respect you.

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.