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

    Compile Error: User Defined Type Not Defined

    Joe, Sorry for not getting back to this sooner but I am covering for 2 folks who are out for extended time. I am just now getting to take a look at this again. The answer to question 1 is yes. I substituted the parameters line above and still nothing. If you or anyone else has any other...
  2. lp2131

    Compile Error: User Defined Type Not Defined

    I don't mean to sound stupid but where does my Form load fit into the above code? I want to try yours but can't figure out what to leave in and what to cut out of mine.
  3. lp2131

    Compile Error: User Defined Type Not Defined

    I took your suggestion and changed the adVarChar to adInteger. There is still no change. I also verified my query - there are 4863 records in it and I am trying to pull data on those employees. The EmployeeNumber field is a combo box and I am using the drop down list to select an employee...
  4. lp2131

    Compile Error: User Defined Type Not Defined

    Thanks anyway! I really appreciate your help. Anyone else out there have any ideas?
  5. lp2131

    Compile Error: User Defined Type Not Defined

    Done...now, no errors but my form does not populate.
  6. lp2131

    Compile Error: User Defined Type Not Defined

    Made that change and now I get a Block If Without End If error...
  7. lp2131

    Compile Error: User Defined Type Not Defined

    Here is my entire code...there was a With earlier in the code (see first post)...Many thanks! Private Sub EmployeeNumber_AfterUpdate() Dim EmpNo As Integer EmpNo = Me.EmployeeNumber.Value Set prm = New ADODB.Parameter Set cmd = New ADODB.Command Set rs = New ADODB.Recordset 'Setup the...
  8. lp2131

    Compile Error: User Defined Type Not Defined

    Okay - done. Now I get another Compile Error - End With Without With Again, many thanks!
  9. lp2131

    Compile Error: User Defined Type Not Defined

    Okay...now I am getting a Run time Error 3021: Either BOF or EOF is True, or the current record has been deleted. Debug starts at first line of form load. I have verified that the record is there. Formload: If Me.EmployeeNumber.Value = rs!EMPLOYEE Then Me.[Last Name].Value =...
  10. lp2131

    Compile Error: User Defined Type Not Defined

    That helped except I get a Run time error 424 Object required. Debug starts at Active Connection. Thanks!
  11. lp2131

    Compile Error: User Defined Type Not Defined

    I just verified that I do have MS ADO Ext. 2.8 checked in References...
  12. lp2131

    Compile Error: User Defined Type Not Defined

    Hi, I am just starting out in the world of VBA and I am creating a DB which is borrowing code from another DB (created from my programmer co-worker). Even though the functionality in each DB is the same, mine keeps coming up with a compile error. My co-worker is on vacation for 2 wks...I'd...

Part and Inventory Search

Back
Top