Search Result

Collapse
5 results in 0.0042 seconds.
Keywords
Members
Tags
update table
  •  
  • serge castle
    started a topic Update statement doesn't update
    in Access

    Update statement doesn't update

    Hello,

    I'm kind of newby in VBA/SQL in access.

    I'm trying to write a code that sums several columns and the result should be "updated" to a Total record.

    I get no error message, but it doesn't work.

    What can be wrong?

    Here's part of the code.


    Code:
        sqlselect = "SELECT * From 12MonthsTemp"
    Set objrs = conn.Execute(sqlselect)
    ...
    See more | Go to post
    • Brandi Mills
      started a topic Multiselect Listbox
      in Access

      Multiselect Listbox

      I have a table named
      tbl_Questions
      with a column called Region
      I have a total of 8 regions

      I am attempting to set an Unbound multiselect listbox on a form called frm_DH

      I need the user to be able to select and deselect any combination of 8 regions and the record to show in the splitform datasheet and update the questions table.

      So far I can select the data but it does not populate...
      See more | Go to post
      • Mena Williams
        started a topic Access07 Form - How to update value in second table
        in Access

        Access07 Form - How to update value in second table

        I have an order table and an inventory table. I have a form with combo and text boxes to add new orders to order table. I want to be able to reduce the # of stock in inventory table by number of items entered in order form box.
        In other words, when I input a value in QuantityOrdered and save the record to the tblOrders, I would like the value in StockOnHand in the tblInventory to be [StockOnHand] minus [QuantityOrdered]
        See more | Go to post
        Last edited by Mena Williams; Dec 2 '10, 03:47 AM. Reason: clarity
        • 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
          • Fluffygoldfish
            started a topic Update column with content from another table based on criteria
            in Access

            Update column with content from another table based on criteria

            Hi

            I am trying to tidy up an access database that has traditionally just been used as a spreadsheet. I have split up the information into different tables and need some help transferring information.

            I now have two tables:

            Client Info - Client ID (primary key), Name, DOB,
            Client Address - Address Id (primary key), Client ID, Address 1, Address 2, etc

            They are linked (client info)...
            See more | Go to post
            Previous template Next
            Working...