DoCmd an Update Query? (AXP 10.2627.2625)

Topic

New Reply

I understand how to run an update query using SQL as a string.

I would like to know, if it is possible, is there a way to pass a parameter to an update query for the value that is to be updated using DoCmd?

For example: here’s the SQL:

UPDATE FilePaths SET FilePaths.[Value] = [somepath]
WHERE (((FilePaths.FilePathName)="TheFiles"));

How do I write

DoCmd.myQuery something, something, something

to update [somepath]? Is what I am asking a reasonable approach?

Reply | Quote

Replies

You could build your own sql string.

strSQL = "UPDATE FilePaths SET FilePaths.[Value] = '" & _
   strSomePath & "' WHERE (((FilePaths.FilePathName)="TheFiles"));"
DoCmd.Execute strSQL

Reply | Quote

Thanks Francois – That looks to be the most efficient way to do it

Reply | Quote