Dlookup with filepath as criteria (2 Viewers)

[Gasman]

That is different result to mine

I tried
C:\Users\Paul\Documents\Bibbys.mdb
z:\downloads\CascadingComboInSubform2k.mdb
z:\downloads\Heartleys Wk 21 Summary 2.pdf

The first two worked fine and Z is a network drive.
Only the last returned Null

 

[nhorton79]

Hey Gasman.

That is weird. Especially with the spaces on yours. I have had no problems with spaces at all.





Sent from my iPhone using Tapatalk

 

[isladogs]

Its a similar issue in URLs where %20 is used in place of a space
Try replacing any spaces with an underscore in the strCriteria line then run the DLookup

 

[Gasman]

Not to worry, you have got your end sorted, though I admit I am curious as to what the differences might be?

Hey Gasman.

That is weird. Especially with the spaces on yours. I have had no problems with spaces at all.





Sent from my iPhone using Tapatalk

 

[nhorton79]

Its a similar issue in URLs where %20 is used in place of a space
Try replacing any spaces with an underscore in the strCriteria line then run the DLookup

Hi Colin,
I’ve had no issues with the spaces, just Gasman.

My issue was with the backslashes and found that if I replaced with a double slash it worked, kind of like in c# (“\\” or @“\”)


Sent from my iPhone using Tapatalk