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!

  • Congratulations strongm 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. SteveMck

    Email from sub form

    Thanks this should really help. Steve
  2. SteveMck

    Email from sub form

    Hi I'm having trouble inserting data from a sub form into an email message. I have a cmd button to send the email from the main form and i have data on my main form & subform that i want to include my code works fine but im unsure how to insert the subform information. Any help would be greatly...
  3. SteveMck

    Update Subform

    Fantastic!! thanks for all your help this works a treat. Steve
  4. SteveMck

    Update Subform

    Wrror should have read as below. object variable or with block variable not set
  5. SteveMck

    Update Subform

    not sure if i had a typo i've run the code again i now get an error here .Recordset.MoveFirst Runtime 91 object not variable or object not set
  6. SteveMck

    Update Subform

    thried that too! Me.Fault_Data_subform.Form!Problem still get the same error
  7. SteveMck

    Update Subform

    Thanks I have altered my code which now looks like this Else Insp = "Pass" Status_Control = "2" With Me!Fault_Data_subform.Form .Recordset.MoveFirst While Not .Recordset.EOF !Problem = "No Problems - Job Approved" .Recordset.MoveNext Wend End With End If But i now get a...
  8. SteveMck

    Update Subform

    Hi Think i have got this in the right section. I have a subform which is in datashet veiw and may return multiple records. Within this form i am trying to update the Problem feild in the subform which is a text box to "No Problems - Job Approved" I am using an IF statement from the main...

Part and Inventory Search

Back
Top