Search results

  1. A

    populating textfields from tables

    Can you not use DLookups? so for example If (cmbVersion = "Version 1") Then Me.Forename = DLookup ("Forename", "Personal_Details", "Version = 1 AND Forename = '" & Forename & "') end if this populates the Forename textfield (Me.Forename) where the user selects version 1?
  2. A

    Inserting values into a table from a form

    Hey JR, Many thanks for your detailed and honest response. I'll check this out tomorrow, many thanks for all the help you've provided.
  3. A

    Inserting values into a table from a form

    Hi Jr, many thanks for your help, I've attached the strip down version of my database, just enter the Enquiry_No in the frmEnquiryDetails textfield and press tab, this should populate the whole form using the DLookup's but only populates data from Machine_Charge_Out and Costing_Sub. Kind...
  4. A

    Inserting values into a table from a form

    Hi Jr, This inserts work great, but now this has affected my DLookup's. When I type the Enquiry_No in and tab to the next text field it usually populates the whole form with all of the data belonging to that enquiry number. But now that I have done the insert on the modal form, it only brings...
  5. A

    Inserting values into a table from a form

    when i use bound textfields data from the tables shows in them, thats the reason why i have unbound them. I've changed the sql statement to the following and it works great: CurrentDb.Execute "INSERT INTO Costing_Main (Enquiry_No, Part_No, Description, Neida_Part_No, Current_Date, Revision)" _...
  6. 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...
  7. A

    table joins problem

    Hi, All is good and working, many thanks for your responses
  8. A

    table joins problem

    hi, sorry its taken so long for me to reply. Thats works great, thank you, but it still doesnt show anything from the 4th table when they're all joined together. Ive attached an screen shot to show my explanation. Many thanks
  9. 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...
  10. A

    2 table inner join syntax problem

    Hi Sorry its taken a while to post again. attached is my sample database.. this is my full join on all 4 tables, which works now, but i can guarantee at some point it will stop working again SELECT Costing_Main.Part_No, Costing_Main.Neida_Part_No, Costing_Main.Enquiry_No...
  11. A

    2 table inner join syntax problem

    correction, this only shows one row of data in stead of showing all :( SELECT Machine_Charge_Out.Hourly_Rate, Material_Cost.Weight_Per1000 FROM Material_Cost INNER JOIN Machine_Charge_Out ON Material_Cost.Part_No_length = Machine_Charge_Out.Hourly_Rate;
  12. A

    2 table inner join syntax problem

    you know what... i used this.. SELECT Machine_Charge_Out.Hourly_Rate, Material_Cost.Weight_Per1000 FROM Material_Cost INNER JOIN Machine_Charge_Out ON Material_Cost.Part_No_length = Machine_Charge_Out.Hourly_Rate; and now it works?? is there something im doing wrong in the first post today...
  13. A

    2 table inner join syntax problem

    Hi Guus2005, I DID have this working, no suddenly its stopped :( As before the 3 tables join perfectly: Costing_Main Costing_Sub Machine_Charge_Out but when i try to add my table Material_Cost, it returns no data from any of the tables. so i broke it down, so i could try to add the...
  14. 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"...
  15. A

    2 table inner join syntax problem

    Hi, Nevermind just fixed my own problem.. SELECT Machine_Charge_Out.Machine_Type, Material_Cost.Finished_Weight_kg, Material_Cost.Part_No_length, Costing_Sub.Qty_Price_Break, Costing_Main.Enquiry_No FROM Costing_Main INNER JOIN (Costing_Sub INNER JOIN (Material_Cost INNER JOIN...
  16. A

    2 table inner join syntax problem

    Hey, Many thanks, i have now have this working, but onto another inner join problem, I want to join all of my tables together, these are Costing_Main Costing_Sub Machine_Charge_Out Material_Cost the top 3 tables join fine and display the data that i want to view Costing_Main Costing_Sub...
  17. A

    Update for inner join syntax

    Hi, thanks for all of your replies throughout, i have managed to get this working using the following code... CurrentDb.Execute "UPDATE Material_Cost SET Part_No_Length = '" & Part_No_length & "', Weight_Per1000 = '" & Weight_Per1000 & "', Finished_Weight_kg = '" & Finished_Weight_kg & "', " _...
  18. A

    Update for inner join syntax

    ok, this is my complete code for all the updates, the top 3 work perfectly fine, its the last one that's causing me problems. The form i created uses source control text boxes, i use dlookup's to populate all of the textboxes with the table data from all tables by entering the Part_No from...
  19. A

    2 table inner join syntax problem

    and yes it should be Part_No_length that was also a typo :(
  20. A

    Update for inner join syntax

    Hey Jdraw, Im trying to update numeric data types, i read somewhere that quotes around the textbox name updates numeric values i.e. Costing_Time = "Costing_Time" or am i completely wrong? Im trying to update the numeric values from the imputted values of the textbox. Many thanks.
Back
Top Bottom