Search results

  1. A

    Inserting values into a table from a form

    'Hi All, 'Hope somebody can help. I have a form called "frmEnquiryDetails" which is attached to the thread, the user is able to enter details in all textfields, when the user wants to insert the data into table they click the save button. 'when the save button is press a modal form appear with...
  2. A

    table joins problem

    Hi All, This has been bugging me for a few day's. I want to join 4 tables together, these are: 1 - Costing_Main 2 - Costing_Sub 3 - Machine_Charge_Out 4 - Material_Cost I can join the first 3 tables together no problem, and they return the columns I need to view, but when i add the final...
  3. A

    using a modal dialogue form in insert into tables

    hi all, I have a form called frmEnquiryDetails where the user can enter new/existing product details once the user has filled in all textboxes, they can click save which then opens a modal dialog box called dlgStoredata on the dlgStoredata i have two buttons "Add record" and "Update record"...
  4. A

    2 table inner join syntax problem

    Hi all, I'm trying to join two tables together that dont have the same column names, I can get this to work on my other tables, but for some reason this join isn't returning the data from the tables. These are my two tables:- Material_Cost ID(PK)...
  5. A

    Update for inner join syntax

    Hi, I hope somebody could help.. Im curreently joining my tables together which work fine, but i want to use an update sql statement for my update button. this is the code i have.. Private Sub Update_Click() CurrentDb.Execute "UPDATE Material_Cost INNER JOIN ((Costing_Main INNER JOIN...
  6. A

    Passing textbox data and populating the rest of the form

    Hi, I'll explain what I'm trying to do first... I have two tables (Costing_Main and Costing_Sub) and two forms, one my first form (Dashboard) I show 4 columns from my costing_main table, these are: Part_No Enquiry_No Revision Current_Date On my 2nd form (frmEnquiryDetails) I want to show all...
  7. A

    Inserting values into a table from a textbox

    Hi, I've been working on this for a few hours.. I have a form with a few textboxes on it, they all have source control, these work fine and all the data entered by the user is inserted into the correct tables. Also on this form i have a textbox called Revision, I need this unbound as I need...
Back
Top Bottom