Results 1 to 4 of 4
  1. #1
    itm is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    69

    Question basic functions are not working in MS Access

    Hi,I am getting a strange error. I am using MS Access 2007. I get an error saying that it cannot find the Project or library and it highlights the Left function. Othertime it says that it cannot find this function. Does anyone know why I am getting this and what I can do about it.

    My code:


    Code:
    Public Function FindStar(ByRef ThisString As String) As String
                  
        If Left(ThisString, 1) Like "[*]" Then
          
           FindStar = ThisString
           
        Else
        
           FindStar = ""
        
        End If
    Thank you

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    itm is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    69
    Thank you that solved it.
    Thanks

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    No problem!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 4
    Last Post: 06-13-2011, 12:14 PM
  2. Basic Access Help
    By alex2300 in forum Access
    Replies: 2
    Last Post: 06-07-2011, 09:42 AM
  3. "And" stops functions from working
    By JimmD43 in forum Programming
    Replies: 5
    Last Post: 03-19-2011, 11:10 AM
  4. nested functions not working in 2010?
    By Gdm in forum Queries
    Replies: 2
    Last Post: 08-02-2010, 08:02 AM
  5. Writing Access functions
    By new2access123 in forum Programming
    Replies: 5
    Last Post: 02-06-2010, 10:47 PM

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