Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    inserting values forn one table into another (Access 2000)

    How to replace values in a table from another table with the same fields



    I have a function called RefrehSTock but i cant get it working.The aim is to insert the values from the
    fields stock and items from the table ProductsTemp into the same fields stock and items of the table Products.
    My function is the following:


    Public Function RefrsehStock()

    CurrentDb.Execute " INSERT INTO products ( stock, items )SELECT Clng(ProductsTemp.stock),(ProductsTemp.items) FROM

    ProductsTemp;"
    End Function


    Can anybody tell me why it is not working? I jave copie this functiuon a year ago but obvisouly i miss something.

  2. #2
    Star Lounger
    Join Date
    Nov 2001
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: inserting values forn one table into another (Access 2000)

    I am not sure what is going on as I have tried your code, as presented, and it works for me....

    Jack

Posting Permissions

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