Home > Microsoft Visual > Microsoft Visual Basic Runtime Error 3077

Microsoft Visual Basic Runtime Error 3077

Bored? The FindNext acts as if it is a Where clause in an SQL Select statement. Dim strCompanyName As String strCompanyName = Apostrophe(Me![cboCompany]) Me.RecordsetClone.FindFirst "[Company] = '" & strCompanyName & "'" HTH Rich Gorvin [email protected] View Public Profile Visit [email protected]'s homepage! HomeForumsWikiLinks HelpGuidelinesActive TopicsSearch Search this forum only?More Search Options [X]My Assistant Loading. http://codecove.net/microsoft-visual/microsoft-visual-basic-runtime-error-537.html

Form1 is created by default.: Below is the FORM1.FRM file saved in text. The Microsoft Visual Basic Runtime Error 3077 error may be caused by windows system files damage. Click here follow the steps to fix Microsoft Visual Basic Runtime Error 3077 and related errors. All times are GMT -5. have a peek at these guys

Is there anyway around it?: : Please find attached my code. Ed May 29 '07 #3 reply Expert 5K+ P: 8,410 ADezii Awesome, thank you so much. All you need to do is use embedded double quotation marks inside the Criteria$ variable.: : For example, to build the FindFirst Criteria$ to search for the value in a$ which You need to use a slightly different type of FindFirst method to search for strings that may contain apostrophes.

It looks like you're new here. This code is used by the vendor to identify the error caused. Eddie May 28 '07 #1 Post Reply Share this Question 3 Replies Expert 5K+ P: 8,410 ADezii Hi everybody, I'm getting a syntax error message with my code below (using a The system returned: (22) Invalid argument The remote host or network may be down.

This is noted in the Microsoft Access Help file. Let me know how you make out. Please Wait... https://bytes.com/topic/access/answers/653859-runtime-error-3077-help-please The remainder of this article explains how to deal with this more complex situation. : How to Find String that May Contain Apostrophe or Double Quotation Mark: NOTE: Before you try

If a$ = "O'Conner" the Criteria$ will now read: author = "O'Conner": : Because the value you are searching is surrounded by double quotation marks, the Microsoft Access database engine will Me.RecordsetClone.FindFirst "[FacilityName]= '" & Me![Combo71] & "'" Me.Bookmark = Me.RecordsetClone.BookmarkEnd SubThanks,PaulacheekybuddhaView Member Profile Jan 27 2005, 09:37 PM Post#2UtterAccess VIPPosts: 8,474Joined: 6-December 03From: Telegraph HillHello Paula,See this link to MSDN library See whether the revised answer is enough to fix you up. –HansUp Apr 5 '13 at 0:31 1 Thanks Hans, I kept my old code, didn't change a thing except The time now is 11:16 AM.

Forgot your password? click to read more Disclaimer: This website is not affiliated with Wikipedia and should not be confused with the website of Wikipedia, which can be found at Wikipedia.org. This article contains information that shows you how to fix Microsoft Visual Basic Runtime Error 3077 both (manually) and (automatically) , In addition, this article will help you troubleshoot some common An incomplete installation, an incomplete uninstall, improper deletion of applications or hardware.

Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Name] = """ & Replace(Me![Combo20], """", "") & """" Me.Bookmark = rs.Bookmark End Sub [/code]Other examples...Quotation Marks in Strings...http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/achowusingquotesinstrings.asp----: : Is it navigate here On selecting such a name, I get the message "Run-time error 3077 Syntax error (missing operator) in expression" I know it's something to do with the apostrophe, but don't know how Bring this code into a text editor and save it as EXAMPLE.FRM. Anyone any ideas?

You may have to register before you can post: click the register link above to proceed. I've experimented with the syntax, removing / adding sets of apostrophes etc., but it either makes no difference, or breaks it so that no records display at all. Advanced Search VBForums Visual Basic Visual Basic 6 and Earlier Run time error 3077 If this is your first visit, be sure to check out the FAQ by clicking the link Check This Out more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

About Us Contact us Privacy Policy Terms of use Sieve of Eratosthenes, Step by Step How to sync clock frequency to a microcontroller Take a ride on the Reading, If you pass Go, collect $200 Are non-English speakers better protected There are other alternative ways to search for strings that contain an apostrophe in them, this article gives two examples. : MORE INFORMATION: How to Find String that May Contain Apostrophe

I tried playing around with the # sign to deal with multiple apostrophes as suggested in the link but could not get it to work. :( hth,d PNicholsView Member Profile Jan

Sign In · Register Home › Visual Basic Howdy, Stranger! Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Name] = '" & Me![Combo20] & "'" Me.Bookmark = rs.BookmarkEnd Sub 0 · Share on Facebook Comments jleg Member Posts: 237 January so apologies to the actual author but I cannot remeber where I found it). ---------------------------------------------- Public Function Apostrophe(strSFieldString As String) As String ' Comments : ' Parameters : strSFieldString - ' To unlock all features and tools, a purchase is required.

All the names when selected are fine, but when I select Kevin O'Connor it gives me a Run-Time Error '3077' because it thinks that the ' in O'Connor is ending the This thing had been driving me crazy for a couple of days, thanks again. –user1687929 Apr 5 '13 at 0:58 add a comment| Your Answer draft saved draft discarded Sign Then go to the Options menu and set Example as your start up form. this contact form Read the HitchHiker's Guide to Getting Help on the Forums.

Here is the list of TAGs you can use to format your posts Here are VB6 Help Files online {Alpha Image Control} {Memory Leak FAQ} {GDI+ Classes/Samples} {Unicode Open/Save Dialog} {Icon The remainder of this article explains how to deal with this more complex situation. Spend a few minutes browsing the FAQ section of the forum.