basic Use Update problem

[sup919]

hi there i have simple question to ask
basically how do i use the update table in the access
I do the command

Dim sqls As String

sqls = "UPDATE checkEquipment SET AmountofUse = AmountofUse - " & Me![amounts] _
& " Where Machine_code Like '*" & Me![deletemach] & "*'"


DoCmd.RunSQL sqls
and it take a long time to update the data so i m thinking of using the update in the access. The problem is that i do not know the command to run the update in access
please help

 

[RickSpr]

I believe you're asking how to run an Access Update query. The syntax is:
DoCmd.SetWarnings False
Set db = CurrentDb()
db.QueryDefs(&quot;<query name>&quot.Execute
Set db = Nothing
DoCmd.SetWarnings True
The SetWarnings stuff temporarily turns off the confirmation prompts that would normally occur for the Update query. Rick Sprague

 

[sup919]

Many thanks Rick it work now
sun