Hi,
I've created an SQL code in VBA to update some tables on a server.
Now I want have the path of the database on a form, so the user can edit the path if needed.
How can I use a variable link for the path in this code?
thanks in advance,
rg,
Andre
I've created an SQL code in VBA to update some tables on a server.
Now I want have the path of the database on a form, so the user can edit the path if needed.
How can I use a variable link for the path in this code?
thanks in advance,
rg,
Andre
Code:
DoCmd.RunSQL "INSERT INTO [;database=C:\Users\nlbruand\Documents\Braakman\HOB server\IBS-data.mdb].orders ( OrderNr, MedewerkerNr, KlantNr, Onderwerp, Orderdatum, " & _
"OrderStatus, Notities, ContactpersoonNr, Lokatie )" & _
"SELECT orders_lokaal.OrderNr, orders_lokaal.MedewerkerNr, orders_lokaal.KlantNr, orders_lokaal.Onderwerp, orders_lokaal.Orderdatum, orders_lokaal.OrderStatus, " & _
"orders_lokaal.Notities, orders_lokaal.ContactpersoonNr, orders_lokaal.Lokatie " & _
"FROM orders_lokaal;"