How to make a dynamic link in Access?

Question

Visual Basic

I created a database in access, with export to a Word according to certain templates. But the path to these templates had to be entered in full. How to implement a link like //templates/document.doc? It's easy to implement in HTML, but VBA asks for the full path, isn't there a workaround? I would like the program to be able to work on any computer, or from a flash drive for example.

Answer 1

Look in the documentation for a way to get the path to the current database file. After that, you will just need to combine the two paths (and there must be such an API too).
I can't be more precise because I don't know VBA.
PS In vain you swear at mamkaololosha - the advice is generally correct, even if it is written clumsily. Access is a dead technology, if you want / need to study databases, you need to study something else.

Answer 2

Very simple. You go to the dean's office, write a complaint not from a teacher and ask for another one who will read you at least mysql or oracle.