Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Computers for Beginners (https://www.askmehelpdesk.com/forumdisplay.php?f=79)
-   -   Why am I getting a runtime 3075 missing operator error in the following statement (https://www.askmehelpdesk.com/showthread.php?t=591239)

  • Aug 5, 2011, 07:38 AM
    atchou69
    Why am i getting a runtime 3075 missing operator error in the following statement
    strSQLA = "SELECT * FROM tblAgreements WHERE tblAgreements.[ID] = LIKE " & "*" & [Forms]![frmSearch]![txtFind].[Value] & "*"*" ;"

    This code is inserted in as VBA in Microsoft access 2010, basically look in the table agreements within ID, for the user's input, say 550 entered in text box.
    Can you assist?

    • All times are GMT -7. The time now is 04:23 AM.