Search results

Yeah, I did Dim p as String, and set p to Environ$("USERPROFILE") & "\..." And now it works. Again thankyou for your help.

I get this error when I try to use the Environ$ in the module:

Yes it's like that. But it's a syncronized folder from sharepoint, which means that for instance my colleague LAB, will have access to the same folders on his pc, but on his pc, they'll be located in C:\Users\LAB\SharepointName\IT - General That's why I want to use something like...

Our Database is actually split, the backend is a Sharepoint List, and the pdf's are already located in a subfolder on the same sharepoint

Okay I didn't express myself right. We do indeed use each our own copy of the file, but the file still need to be universal, since I'm the only guy who knows how to make changes to the front end.. And the sharepoint path looks like this: C:\Users\MyName\SharepointName\IT - General

Maybe I misunderstand your question, but we are multiple users of the database, so to be able to use the same frontend I would like it to be as described above

I do have an additional question though, I would like to use "Environ$("USERPROFILE")" in the module, because the pdf files are saved in a sharepoint folder Const p As String ="F:\PathToContacts\" So it looks something like this Const p As String = Environ$("USERPROFILE") &...

Thankyou so much for your patience and for your help :)

Okay, getting there :) But it says No at all numbers?

Just deleted it and made a new and named it Module1. Now I get this

Yes, only difference from your screenshot is that I named the module pdfPath

Okay, now I have done the changes, but when I try to enter the query, I get the attached error?

Thanks for the fast respone. Made the module, no problem, but where exactly in the query do I put the line of code to call the function?

Hi all First of all english is not my native lang. On a school I'm managing PC that students can borrow. For each PC that is borrowed by a student, they sign a physical contract, that is scanned into a .pdf file and placed in a folder in "F:\PathToContacts\" . The PC's are named ABC001...