Search results

  1. A

    Form design help

    i have solved this by creating a temp table to hold the summed qty, thaks for your help
  2. A

    Form design help

    thanks for your suggestion, i have tried the following; the query is only readonly as it sums the recieve qty. So when i try and run the query i get a message 'Operation must use an updateable query' any way i could get round this? UPDATE tblOrderDetail INNER JOIN qryReceiveRunningTotal ON...
  3. A

    Form design help

    i need to run a condition that compares 2 field quantities together based on the same item. If they both equal the same then i want it to run a code and change a property for that record. I will have a OrderQty and a Total receivedQty when these 2 equal each other then it updates the items...
  4. A

    Form to view newly created records

    I have tried my best Paul, its access 2013 im using you will have to add your PC useranme in the tblUser. Click on frmMenu CLick to view or Edit your Orders You should have one order 62AR0? Click the Recieve button This is the form that opens up that im trying to run the code on the load.
  5. A

    Form to view newly created records

    Haha sorry my bad i totally missed that! i have replaced with the ID number of my query. Im still getting a blank subform though? it is creating the new records fine just not displaying them?
  6. A

    Form to view newly created records

    I have amended the code to, which no longer errors but the 2nd subform is still blank. I have attached an image the 2nd subform on the right is the one im trying to populate If Len(filStr) > 0 Then filStr = Left(filStr, Len(filStr) - 1)...
  7. A

    Form to view newly created records

    I have changed it to the following, but it says Access cant find the field 'sfrmReceiveDetailEntry' referred to in your expression? Me!sfrmReceiveDetailEntry.Form.RecordSource = "SELECT * FROM qryReceiveDetailEntry WHERE autoIDFieldName IN (" & filStr & ")"...
  8. A

    Form to view newly created records

    the following code gets highlighted when debugged Me.RecordSource = "SELECT * FROM theTableTheFormIsBased WHERE autoIDFieldName IN (" & filStr & ")"
  9. A

    Form to view newly created records

    thank you, I have just tried the code and get the following run time; Run time 2580 The record source 'Select * FROM thetableTheFormIsBased Where autoIDFieldName IN (35,36) specified on this form or report does not exist any ideas?
  10. A

    Form to view newly created records

    when I copy the code into VBA I the following is red CurrentDB.Execute("INSERT INTO tblreceivedetail (OrderDetailFK, UserFK, ReceiveFK) VALUES (" & _ rstSubForm.Fields("OrderDetailPK") & ", " & rstSubForm.Fields("UserFK") & ", " & _...
  11. A

    Form to view newly created records

    my code is as follows Private Sub Form_Load() Dim rstSubForm As Recordset Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("tblreceivedetail") Set rstSubForm = Forms!frmReceive!sfrmReceiveDetail.Form.Recordset With rs While Not rstSubForm.EOF .AddNew .Fields("OrderDetailFK") =...
  12. A

    Form to view newly created records

    that sounds like it could work, have you got any sample code using that process to get me started? thanks
  13. A

    Form to view newly created records

    There could be between either 1 to say 50 new records that get created. Will this still work on multiple new records?
  14. A

    Form to view newly created records

    I have a piece of code that is creating new records when the form loads using recordsets. I need a subform to show only the newly created records, any help would be great! thanks
  15. A

    Loop through a recordset while adding new records to another?

    thank you for the help, i've managed to get the code working, i want to display only the new records in the continuous 2nd subform? do you have any ideas how i can achieve this? thanks finished code Private Sub Form_Load() Dim rstSubForm As Recordset Dim rs As Recordset Set rs =...
  16. A

    Loop through a recordset while adding new records to another?

    thank you for your reply, am i referring to the fields or should i refer to the forms textbox names that hold the data? thanks
  17. A

    Loop through a recordset while adding new records to another?

    I'm pretty familiar i have the following code which loops through my 1st recordset, i need help adding new records to another recordset? Private Sub Form_Load() Dim rstSubForm As Recordset Set rstSubForm = Forms!frmReceive!sfrmReceiveDetail.Form.Recordset Do While Not rstSubForm.EOF...
  18. A

    Loop through a recordset while adding new records to another?

    It will only need to be done once when the form loads. thanks
  19. A

    Loop through a recordset while adding new records to another?

    Is there a way of looping through a form record set, while adding new records to a different form record set? using some data from the 1st record set in the new records? any pointers would be great! thanks
  20. A

    Order Receive Form Detail

    Hi There i need some pointers as im struggling with a form setup, I have a Purchase Order system with an OrderDetail and Order Table. I have created an ReceiveDetail and Receive Table. i need to receive the order, i currently have a main form with a subform. Im struggling with the subform...
Back
Top Bottom