as if the visual basics is disabled

[w0od0o]

hi just a quick post hopefully :S, my database seems to have all of a sudden disabled the vb code? all worked fine and still does except that any code i wrote myself (very basic stuff) doesnt run

any help is appreciatied

thanks

 

[RuralGuy]

What version of Access? How do you know your code is not running? Have you put in a breakpoint and single stepped the code?

 

[w0od0o]

sorry for the delay ive been away, i dont really know much about code only what i have pick up on here, it seems to be working again now for some reason but i havent changed anything since i posted, th reason i know it wasnt working was because it runs a text box after to confirm its done, ill show some sample code

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.NewRecord Then
Me.invoice_number = DMax("[invoice_number]", "invoicedetails") + 1
MsgBox "Invoice number generated"
End If
End Sub

thanks for ur help

w0od0o

 

[RuralGuy]

Sounds like you are off and rolling again. Good, and thanks for posting back.

 

[Banana]

Out of curiosity did you leave the Access idle for a long time? Similar thing happened to me but that was fixed when I restarted Access. I'm still not why, and am thinking it's a 2007 weirdness.