Results 1 to 2 of 2
  1. #1
    AndrewD is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2015
    Posts
    1

    Error with entry search macro

    I have made a macro for the search of an entry by the value of a particular field. It worked on one computer but when I try to launch it on the other I get the following error. On could be a reason of it and how could I solve it?

    Click image for larger version. 

Name:	error,,.jpg 
Views:	14 
Size:	55.0 KB 
ID:	22969

    This is the code of the macro:

    Private Sub mygtukaspa_Click()
    If IsNull(kodaspa) = False Then


    Me.Recordset.FindFirst "[Kodas]=" & kodaspa
    Me!kodaspa = Null
    If Me.Recordset.NoMatch Then
    MsgBox "Atsiprasome", vbOKOnly + vbInformation, "Irasas nerastas"
    Me!kodaspa = Null
    End If
    End If
    End Sub

    Private Sub Tekstas28_Click()

    End Sub


    Also, this might be off topic but I also get the following error when I launch the query that contains the field with the Date type. Could you help to solve this?

    Click image for larger version. 

Name:	error,.jpg 
Views:	14 
Size:	13.9 KB 
ID:	22970

    Thank you in advance for your help!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    There is an activeX control missing. Either copy it from the working PC or delete it from the form.
    Are you using some odd control, like a calendar or the like?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 09-22-2015, 03:30 PM
  2. Replies: 1
    Last Post: 01-13-2015, 01:33 PM
  3. Search Box Incorrect Entry
    By libraccess in forum Forms
    Replies: 2
    Last Post: 01-01-2014, 03:52 PM
  4. Search Field on entry form
    By Rhubie in forum Forms
    Replies: 7
    Last Post: 03-14-2013, 07:04 PM
  5. Replies: 2
    Last Post: 05-05-2012, 02:34 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
  •  
Other Forums: Microsoft Office Forums