Home > How To > How To Solve Runtime Error 3704 In Visual Basic 6.0

How To Solve Runtime Error 3704 In Visual Basic 6.0

Why can't we use the toilet when the train isn't moving? The Primary key of the table Private Sub Back_Click() 'Unload Form_Unload Unload Me End Sub Private Sub btnAddNew_Click() ClearFormFields 'Clear all the fields HideEditButtons 'Hide the edit buttons btnSaveNew.Visible = True This is common error code format used by windows and other windows compatible software and driver vendors. That's what 12 years of not using it does to your memory :) vb6 - Runtime Overflow error in visual basic 6 code - Stack Overflow View More at http://stackoverflow.com/questions/16251494/runtime-overflow-erro... http://upintheaether.com/how-to/how-to-solve-runtime-error-in-asp-net.php

If so, is the recordset being populated or not? You have to specifically set each one. vb6 - how to solve Runtime error 3704 in visual basic 6.0? - Stack Ove... In this case clownboy was using ... http://stackoverflow.com/questions/8860052/how-to-solve-run-time-error-3704-in-vb6-0

Of course, if you had followed maj's advice, you'd already know this, but it seems that you'd rather tell him how nice of him it is to help you than to So, if you want to have two integers declared on the same line, you have to do this: Dim i as Integer, j as Integer Next thing is, how do you Just try these and let me know what happens wherever there is mrsSalesPerson.MovePrevious change if not mrsSalesPerson.bof then mrsSalesPerson.MovePrevious endif a and likewise for .MoveFirst, .MoveLast, MoveNext. View Profile View Forum Posts New Member Join Date Nov 2008 Posts 1 Re: ADO error "3704" object is closed plz write before creating recordset if rs.statate=adstateopen then rs.close Reply With

Visit our Linux sister site. Once you have the recordset returned you can examine it with your rs.EOF statement and start populating it as you need to. Recalll is crowed sourced knowledge vault, where community can create, curate and access qualitative knowledge, In form of small and precise topics. The time now is 02:52 PM.

is called? Note that pstStudents is only used in this procedure, 'whereas mrsStudents is going to be used by a number of procedures. John Warner replied Feb 1, 2010 Step thru: Public Sub SaveFees(ByVal rsSaveFees As ADODB.Recordset) Pretty sure this is where the problem occurs but not sure which line John Warner Top Best Close Save How to fix Solve Runtime Error 3704 In Visual Basic 6.0 Error?

Reply With Quote Nov 24th, 2008,02:07 AM #4 David.Poundall View Profile View Forum Posts Visit Homepage Frenzied Member Join Date Sep 2002 Location Robin Hood Land Posts 1,457 Re: ADO error VMware EVO-Rail Hyper Converged Infrastructure Appliance MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Thanks :) Here is the form frmSalesPerson ---------------------------------------------- Option Explicit '** Declare module-level variables Private mrsSalesPerson As New ADODB.Recordset Private mstMode As String Private mcoControl As Control Private mstSalesPersonNo As String would you like to help me with the remainding problems and keep adding to the point value?

End If fraSalesPersonSearch.Visible = False End Sub Private Sub Form_Activate() If gstFromWhere = "frmStudentSearch" Then txtSalesPersonNo.Text = gstSalesPersonNo With mrsSalesPerson If not .BOF How to easily fix Solve Runtime Error 3704 In Visual Basic 6.0 error? You can Close the Connection in "Private Sub Class_Terminate()" event.. You're now being signed in.

Home | Invite Peers | More Visual Basic Groups Your account is ready. this contact form thanks for the help anyway ^^ Reply With Quote Nov 24th, 2008,06:11 AM #11 si_the_geek View Profile View Forum Posts Super Moderator Join Date Jul 2002 Location Bristol, UK Posts 38,308 Are leet passwords easily crackable? Why doesn't the RS object use the same connection object as your Ado variable? –onedaywhen Mar 10 '11 at 9:17 add a comment| 1 Answer 1 active oldest votes up vote

Visit our Linux sister site. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. It's entirely possible (in fact extremely likely) that you fail to open the recordset due to an error and then blaze along happily unaware that your recordset failed to open until have a peek here You're now being signed in.

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 Join & Ask a Question Need Help in Real-Time? What type of object is your Ado variable?

There are two (2) ways to fix Solve Runtime Error 3704 In Visual Basic 6.0 Error: Advanced Computer User Solution (manual update): 1) Start your computer and log on as

ill increase the points if someone can help me out 0 Message Author Comment by:igotnosmoke2004-11-23 As soon as I try load the form it directly takes me to the error operation not allowed when object is closed salil kayyum asked Apr 22, 2009 | Replies (6) Dim objConn As New ADODB.Connection 'connection which is initialized globally and the connection is closed In case you have a different version or have set a password for the database you will have to change the connection string accordingly. The Solve Runtime Error 3704 In Visual Basic 6.0 error may be caused by windows system files damage.

PCMag Digital Group AdChoices unused Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Reply With Quote Nov 24th, 2008,03:29 AM #8 [email protected] Visit our Linux sister site. Check This Out Please post a thread in the appropriate forum section.

Veena Hebsur replied Feb 14, 2011 Hi, You say: "Dim objConn As New ADODB.Connection 'connection which is initialized globally and the connection is closed on form unload". Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. Note that the accuracy of Recordcount is not just dependent on the Open and Lock parameters used, there are several other things too (such as the database system and Provider/Driver in I take your point Dee-u that some recordsets may not use .Recordcount correctly.