Search Result

Collapse
5 results in 0.0043 seconds.
Keywords
Members
Tags
update query
  •  
  • sg2808
    started a topic Update Query is not working
    in Access

    Update Query is not working

    The update query is not working and I cannot understand why. I have attached the screenshots with SQL and Design view.

    SQL -
    Code:
    UPDATE DetProcess INNER JOIN RiskDetailsTable ON DetProcess.DetProcessID = RiskDetailsTable.DetProcessID SET RiskDetailsTable.DetProcessID = [DetProcess].[DetProcessID];
    Kindly advise.

    Many thanks,
    SG...
    See more | Go to post
    Last edited by NeoPa; Mar 14 '12, 01:17 PM. Reason: Added mandatory [CODE] tags for you.
    • Amy Badgett
      started a topic Proper syntax for using an update query in VBA?
      in Access

      Proper syntax for using an update query in VBA?

      Could anyone give me the proper syntax for executing a SQL Update Query in VBA in an on_click event?

      Maybe like a step-by-step explanation?
      See more | Go to post
      • murtazadoc
        started a topic Update one table with another table record
        in Visual Basic .NET

        Update one table with another table record

        Hy...

        am having a query regarding updating a table A records from table b on a button click...

        have created connection sting and commandtext to exexute d query
        am tryn ds query bt it seems to throw some syntax error

        Code:
        cmd.CommandText = 
"UPDATE stockno_table SET(product_id,Sold,Rec_No)
=(SELECT product_id,Sold,Rec_No from stockno_temp_copy 
where stockno_temp_copy.stock_no=stockno_table.stock_no)
        ...
        See more | Go to post
        • CJOB1
          started a topic Periodically merging 2 tables from 2 identical dbs but in different locations.
          in Access

          Periodically merging 2 tables from 2 identical dbs but in different locations.

          I am trying to periodically merge two tables from 2 identical ms access databases as well as one sub table to that table. This is required on a periodical basis as the hardware in place will not support a live link.

          The Source database will be the dominant database where all the programming for updating the tables will originate. I'm then thinking: import table to source db, append and update the destination table to source table,...
          See more | Go to post
          • atksamy
            started a topic How to get a reports of update query
            in Access

            How to get a reports of update query

            hi,

            Is it possibel to get a report of the records that are updated using a update query.
            I mean without using recordset. suppose
            Code:
            sqltext = update table employees set bonus = 0 where salary > 50000 

DoCmd.RunSQL sqltext
            now after theis query runs is it possible to get the name of the employees for whom this update query was performed.
            i would like to get the updated records in a...
            See more | Go to post
            Previous template Next
            Working...