Recent content by Annoscia85

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?

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.

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...

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...

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)" _...

'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...

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

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

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...

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...

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;

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...

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...

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"...

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...