Compile error: Argument not optional

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 29 Apr 2005 17:12 GMT

Im trying to run and sql statement:

DoCmd.SetWarnings = False
DoCmd.RunSQL ("update AdditionalServiceRequests set request1 = 0
WHERE AdditionalServiceRequests.AdditionalServicesID= " &
[Forms]![Login]![MostRecentEventID] & " ;")
DoCmd.SetWarnings = True

but I get an error on this line:
DoCmd.SetWarnings = False

What does this mean and how do I fix it?..thanks

Reply to this Message

Robert Morley - 29 Apr 2005 18:16 GMT

Don't use an "=" sign, it's just
DoCmd.SetWarnings False

Rob

> Im trying to run and sql statement:
>
[quoted text clipped - 8 lines]
>
> What does this mean and how do I fix it?..thanks

Reply to this Message

Van T. Dinh - 01 May 2005 11:53 GMT

... and the same for the 2nd SetWarnings.

Signature

HTH
Van T. Dinh
MVP (Access)

> Don't use an "=" sign, it's just
> DoCmd.SetWarnings False
[quoted text clipped - 13 lines]
> >
> > What does this mean and how do I fix it?..thanks

Reply to this Message