Acess97 Delete Record

[katz]

Hello All,
All of a sudden I cant delete a record thrue code "DoCmd.RunCommand
acCmdDeleteRecord" only thru Edit and Delete or Macro.
I get a message The command or action DeleteRecord isnt available now.
Please help.
Thanks, Abe

 

[Nick Coe \(UK\)]

When and where are you calling it? That message comes up if
you are doing something else with the record or some other
process still has a lock on it.

--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.mrcomputersltd.com/ Repairs Upgrades

In katz typed:

 

[katz]

Thanks Nick!
I have a Button on my form that calls this function.
DoCmd.Beep
msg = "ARE YOU SURE TO DELETE THIS RECORD?"
Response = MsgBox(msg, 4 + vbQuestion, "Delete Record")
If Response = 7 Then Exit Function

DoCmd.SetWarnings False
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.SetWarnings True

I found the problem already, I put 600 on the Timer Interval property
together with the on timer, on my Main Menu that starts when I open the
database. I use it to make a control blink. This caused the problem that I
couldn't delete any record thru code.
I dont know what the timer has to do with deleteting records. I guess I dont
know everything.
Thanks for your time
You are a good man