Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2011
    Posts
    1

    Question Unanswered: Error code 3113, can't update (field).....

    Hi,
    I am new for Ms access. and learn something in access from a book.

    my problem is :
    i have an update query. Previously it was working well. but to day when i run this query (after 8 months) error code 3113 is appearing.

    code of update query is :

    UPDATE Register SET Forms!RepEntryMain.NewStatus = [Register].[Status], Forms!RepEntryMain.NewNoOfParaReplied = [Register].[NoOfParaReplied]
    WHERE (((Register.RefNo)=[Forms]![RepEntryMain].[RefN].[Value]));


    here, register is the file name in which i want to update (status and NoOfParaReplied are fields)

    and
    Forms!RepEntryMain.NewStatus
    Forms!RepEntryMain.NewNoOfParaReplied are value of text box.

    If you want any more information kindly ask for it.

    can you tell me why error code 3113 comes
    Last edited by ashishkumar1200; 04-28-11 at 05:43.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Error 3113 means that a field is not updatable.

    What's this query supposed to do? It seems very confusing to me. At first sight you update something (controls?, fields?) in a form using values from a table: <Form>!<Something> = <Table>.<Something> (I guess that when you say:
    register is the file name in which i want to update
    you mean that register is the name of a table).
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    i could believe
    strSQL = "UPDATE Register SET Status = " & Forms!RepEntryMain.NewStatus & ", NoOfParaReplied = " & Forms!RepEntryMain.NewNoOfParaReplied & "
    WHERE Register.RefNo= " & [Forms]![RepEntryMain].[RefN].[Value] & ";"

    ..mind you thats assuming that none of those columns are string / text otherwise you'd need toencapsulate those values with either single or double quotes.
    eg
    WHERE Register.MyTesxtColumn = '" & [Forms]![RepEntryMain].[RefN].[Value] & "';"
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •