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!

Register Log in
  • Congratulations Mike Lewis 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. uipuih

    Delete data in Tables using VBA from a Form

    I am using a form with a subform to enter data into two tables: Table1 Fields: 1)EMPID and 2)CurrentDate (fields are the primary key fields in Table1). TBLWeekDetail fields: 1)EMPID 2)CurrentDate 3)Activity 4)Organ 5)PreTime 6)Posttime. I am trying to find a way to allow the user to edit...
  2. uipuih

    Help in declaring Variables

    Thanks yet again. Ian
  3. uipuih

    Help in declaring Variables

    Thank you Skip
  4. uipuih

    Help in declaring Variables

    I am trying get the sum of values in a column and then insert that value into a cell. I tried the following but cannot get the MyValue to get the sum of the Range. Dim MyRange As Range Dim MyValue As Integer Set MyRange = Range("E:E") Set MyValue = Sum(MyRange) ' End Sub
  5. uipuih

    run-time Error '3077'

    thanks, I copied and pasted your code it works fine. I tried this earlier but must have been missing something. appreciate your assistance.
  6. uipuih

    run-time Error '3077'

    Having problems when my combo lookup box comes across an apostrophe. below is my code. Private Sub Combo11_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Guarantor] = '" & Me![Combo11] & "'" If Not rs.EOF...

Part and Inventory Search

Back
Top