Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gregpen

    Update data in one form from data entered into summary form

    Forms!myMainForm!MyControl = Me.MytxtControlUpdated !MyControl ? Is this refering to the field I want to update if so do I include this line of code for each of the 12 fields that may possible be updated from the summary form. MytxtControl refers to ?
  2. gregpen

    Update data in one form from data entered into summary form

    One other thing when I open the summary form I am not able to edit the information that is displayed. is this just a matter of changing on of the properties of the form..
  3. gregpen

    Update data in one form from data entered into summary form

    My Problem, I am trying to create a form that displays a summary of data relating to a current record. I use a command button on the main form to open the summary form. Once in the summary form I would like my users to confirm the info is correct and if not make changes to the data while in the...
  4. gregpen

    Displaying contents of a shared drive folder in a form

    Hi Hatchetman, I'm looking to solve the same problem any luck yet...
  5. gregpen

    Update table with data from other tabe

    Thanks Mac and Terry, your help has been greatly appreciated, It makes it alot easier to understand when laid out the way you guys have thank you again.
  6. gregpen

    Update table with data from other tabe

    Sorry one other thing that should be said is that the WeeklySales tables contains data from many different weeks. All I neeed to update to the Products table are the items that have been sold during the latest date on the Weeklysales table. The suggested methods want to update all records to...
  7. gregpen

    Update table with data from other tabe

    Just need a little more info if possible: Isn't the method you mentioned going to create a new field named Qty. Should this expression be entered into an update query if so what is the destination and how should it be entered. Thx again Mac..
  8. gregpen

    Update table with data from other tabe

    I have entered as suggested but still no go. The table I am trying to update (Products) has the following fields - Product, Productcode, Costprice, Quantity, CompanyNum. The Table I am trying to draw the data from (WeeklySales) to update the Products table has th following fields - Lastdate...
  9. gregpen

    Update table with data from other tabe

    The problem, For hours I have been trying to update a particular column in a Product table (Quantity). I run a query that groups all sales from the week and appends then to a Weekly Sales Table, I am then trying (everything) to update the quantity column in the Product table so that it...

Part and Inventory Search

Back
Top