Yes, I think.
So this select statement in the query builder (?) creates a field named Link with the path and file name combined. I built the query right clicked the query tab and went to SQL view to get this.
SELECT [FID], [Path], [FName], [path] & [Fname] AS Link FROM [02_Detail];
An update statement would look like this.
UPDATE [02_Detail] SET [Link] = [path] & [Fname];
I cannot get either to run in VBA.
Code:
Dim strSQL As String
strSQL = ("SELECT [FID], [Path], [FName], [path] & [FName] AS Link FROM [02_Detail];")
DoCmd.RunSQL (strSQL)
I get an error message that I need an SQL statement. Help says it does not have help for this so clearly I do not understand VBA.