DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007

    Combo box form search

    Hi all,

    Very simple problem that I hope you can help with...

    The forms within my database use combo boxes to search and select records. These were made using the access wizard.

    The problem comes when I load the database onto the machines at my workplace (database has been created on a different machine running the same version of Access 2003).
    When I try and use the combo boxes I get a VBA error that says:
    "Compile error:

    Can't find project or library."

    ...and the code won't run.

    I've tried remaking the combo boxes on the work machines. Exactly the same happens.
    This happens on every machine in the office, so I don't think it's a local Access error (whatever that is, might have just made it up...)
    All machines are fully up to date and running the same version as the home PC (Access 2003).
    I've done some testing and combo boxes do work on the work machines (I've made another database and run the wizard and they work).

    I'm very stuck with this and really appreciate any input.

    Thanks alot.


  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    What library can't it find?

  3. #3
    Join Date
    Aug 2007
    Thanks for the reply Hack.

    I've pasted the VB code below and highlighted the line that the dubugger highlights.

    Private Sub Ref_Search_AfterUpdate()

    ' Find the record that matches the control.
    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[Referral_ID] = '" & Me![Ref_Search] & "'"
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark

    End Sub

    Does htat tell you what you need to know?
    If not then let me know where I should be looking - sorry for being useless!
    Am wondering if it's simpler to work around the problem (i.e. use an alternative code), but I wouldn't know where to start.


Similar Threads

  1. Search Combo Box
    By CB77 in forum .NET
    Replies: 0
    Last Post: 04-04-2007, 03:30 AM
  2. Combo box changing textbox
    By InsuranceGuru in forum VB Classic
    Replies: 2
    Last Post: 06-23-2005, 10:58 PM
  3. Restricting the values of combo box (look up) in the fly
    By Shahab Malekzadeh in forum VB Classic
    Replies: 0
    Last Post: 02-20-2001, 10:07 AM
  4. combo box and dblist controls
    By Juan in forum VB Classic
    Replies: 0
    Last Post: 01-26-2001, 11:17 PM
  5. I am helpless - Edit Info form
    By Dan in forum VB Classic
    Replies: 0
    Last Post: 03-17-2000, 05:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center