I have copied this code from an existing database to a new test base on my PC and changed the location where each database record will create a folder when the on current record does not have a folder assigned. The field "directory" will have a hyperlink which will open a database folder. The test database is different from the exiting database and also have a SQL backend just for background.
However I get an error related for VBDirectory. Am I missing some statements for the test database such as Public Sub OpenLinkedDB() that are failing the VB directory line from being performed? The database I am not sure what VBDirectory does.
folder = "C:\Users\USERA\Documents\_sqlTEST\SQLTestDB_Folders\" & Format(Me.P_ID, "\C\A\S\E0000")
If Len(DIR(folder, vbDirectory)) = 0 Then
MsgBox "new folder created here: " & folder, vbInformation, "NEW FOLDER"