excel vba error 3705 Curdsville Kentucky

Address 607 Cypress St, Newburgh, IN 47630
Phone (812) 573-1287
Website Link

excel vba error 3705 Curdsville, Kentucky

Is it appropriate to tell my coworker my mom passed away? Good Luck ^ ^ Mar 1 '08 #5 reply Expert 5K+ P: 8,435 Killer42 You don't need to explicitly load the form anyway. If not Closed, then Close it. wannapiv 0 Message Author Comment by:howardsd2003-05-01 this morning i realized that i should just use the rs provided by the DataEnv, but your hint on open/closing the object helped thnx

the macro i made is only runnable at 1st row of my table.. How to make files protected? I'm not really sure for my previous post. Remember what the dormouse said Feed your head Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently

Join the community of 500,000 technology professionals and ask your questions. Thanks for your help Reply With Quote Quick Navigation Office Development Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual Basic Visual Basic .NET VB.net Hi I recently signed up for VB Forums and hopefully someone here can help with this problem that I am having. share|improve this answer answered Feb 1 at 9:41 PaulG 53617 add a comment| up vote 0 down vote A mistake I've made many times before.

adamsaulnier08-11-2005, 07:31 AMLook in your other post. Need book id. Change the line to Set .ActiveConnection = conn .Source and .LockType are scalar properties, so they don't need Set, but .Activeconnection does. help me plz..

The time now is 04:45 AM. Join Now For immediate help use Live now! 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 Expand|Select|Wrap|Line Numbers PrivateSubcmd_companyinfo_Click() LoadFrmCompany FrmCompany.Show EndSub PrivateSubcmd_duplicate_receipt_Click() LoadFrmDuplicate_Receipt FrmDuplicate_Receipt.Show EndSub PrivateSubcmd_exit_Click() UnloadFrmMain End EndSub PrivateSubcmd_generate_Click() LoadFrmReceipt FrmReceipt.Show EndSub PrivateSubcmd_receipt_Click() LoadFrmReceipt_Details FrmReceipt_Details.Show EndSub PrivateSubcmd_reset_Click() LoadFrmReset FrmReset.Show EndSub

Want to Advertise Here? I started practicing vba programming since yesterday... Promoted by Recorded Future Threat intelligence is often discussed, but rarely understood. Run-time error '3705': Operation is not allowed when the object is open here's my code: ________________________________________ Please Login or Register to view this content. _________________________________________ I got the

slasheringx08-11-2005, 12:24 AMi got problem runnning my program after i put in these line of code hawkers.Open "SELECT * FROM available where stall = 'beverage' and index = 0" If hawkers.Fields("available").Value How do I explain that this is a terrible idea? Have fun!!! Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We

Not sure if this has anything to do with it. Can anyone help me to solve my problem.. It's not clear to me whether you expect multiple records to be returned for each query that you do - if not, there is no need for the movenext; just open Ionut Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #4 Guest_deo001* Reputation: Re: Why do I get Run Time Error 3705 Posted 17 September 2010 - 02:19

Solved runtime error 3705: Operation is not allowed when object is open -- help! I think Veena is right. Not the answer you're looking for? Related 2Operation not allowed when object is closed - Create table statement in first line?1Runtime error when deleting a row in Worksheet_Change1Error message 'Runtime error '1004' Application-defined or object defined error

Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? Can Communism become a stable economic strategy? Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. it has problem with the ElseIf it doesn't close the connection Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #6 Ionut D.I.C Lover Reputation: 385 Posts:

but i got these error.. Editing MSFlexGrid by users Very simple updater 63 More VB Tutorials... Reputation: 6243 Posts: 24,012 Joined: 23-August 08 Re: Why do I get Run Time Error 3705 Posted 16 September 2010 - 02:11 PM Searching Google for your error (always a good What are Imperial officers wearing here?

Starting with a precise definition, along with clear business goals, is essential. First, force recordset's cursor to the first position : rs.MoveFirst Second, if the user manage to log in and show the main form, break from the while, you don't need to Mar 3 '08 #7 reply 100+ P: 122 vikas1111 You don't need to explicitly load the form anyway. Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4.

Third, before disposing the connection, close any object that uses that connection and close the connection. Here is the FAQ for this forum. + Reply to Thread Results 1 to 2 of 2 SQL Loop Problem Run-time error '3705': Thread Tools Show Printable Version Subscribe to this Join them; it only takes a minute: Sign up run-time error 3705 operation not allowed when the object is open up vote 0 down vote favorite Good night, I receive the