Combo box form search


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Combo box form search

  1. #1
    Join Date
    Aug 2007
    Posts
    2

    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.

    Mark.

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    What library can't it find?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Aug 2007
    Posts
    2
    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.

    Thanks.

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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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