You could use the Dir() Function to return the folder name, using a combination of known paths and wildcards and specifying the vbDirectory attribute. See the Access VBA help menu (from the VBIDE window) and search for "Dir"
You could use the Dir() Function to return the folder name, using a combination of known paths and wildcards and specifying the vbDirectory attribute. See the Access VBA help menu (from the VBIDE window) and search for "Dir"
Neatness counts, spelling matters and formatting is REQUIRED. RTFM - I did. STFW - I do.