vieirasoft
New member
- Local time
- Yesterday, 22:55
- Joined
- Sep 12, 2018
- Messages
- 5
Good afternoon. I have an sql instruction like that:
...IN 'CurrentProject.Path & " \ historicoapolice.mdb '" & _ But it gives me error
But if i put like this:
....IN ' C:\loja seguros\ historicoapolice.mdb '" & _ it does not matter anymore.
The "historicoapolice.mdb" is a database to store customer history. In the main MDB there is a button. Clicking executes the sql statement and sends the selected tab to history. It is not connected to the main. I would like the sql statement to run anywhere where the mdb was installed, since the folder is the same for both mdb's.
So, rather than ....IN ' C:\loja seguros\ historicoapolice.mdb '" & _, i would like this......IN 'CurrentProject.Path & " \ historicoapolice.mdb '" & _ But it gives me error. Mujst doing something wrong, but what?
What i'm doing wrong? Can someone help me? Thank you
...IN 'CurrentProject.Path & " \ historicoapolice.mdb '" & _ But it gives me error
But if i put like this:
....IN ' C:\loja seguros\ historicoapolice.mdb '" & _ it does not matter anymore.
The "historicoapolice.mdb" is a database to store customer history. In the main MDB there is a button. Clicking executes the sql statement and sends the selected tab to history. It is not connected to the main. I would like the sql statement to run anywhere where the mdb was installed, since the folder is the same for both mdb's.
So, rather than ....IN ' C:\loja seguros\ historicoapolice.mdb '" & _, i would like this......IN 'CurrentProject.Path & " \ historicoapolice.mdb '" & _ But it gives me error. Mujst doing something wrong, but what?
What i'm doing wrong? Can someone help me? Thank you