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 Chat with Support Chat with our experienced staff to receive help right away. What Is The "Real Estate Loophole"? When I run the exact same query in the same function without the WHERE clause, like this strsql0 = "SELECT lnk_stockitm.C_C FROM lnk_stockitm; I get the correct result of 56,000 records.

So allow me to reword this.... Windows or Linux for Monero Determine if a coin system is Canonical Why are there no BGA chips with triangular tessellation of circular pads (a "hexagonal grid")? C# questions Linux questions ASP.NET questions SQL questions VB.NET questions discussionsforums All Message Boards... General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ

Connect with top rated Experts 14 Experts available now in Live! With the passing of Thai King Bhumibol, are there any customs/etiquette as a traveler I should be aware of? maintaining brightness while shooting bright landscapes Are professors allowed to participate in political activities? Solved Getting run time error 3021 either BOF or EOF is true, or current record has been deleted, Requested opration...

strsql0 = "SELECT lnk_stockitm.C_C FROM lnk_stockitm WHERE (((lnk_stockitm.C_C) Like 'T*'));" newRS.Open strsql0, cn1, adOpenKeyset, adLockReadOnly if not newRs.eof then newRS.movelast else ' do something here if necessary to handle blank results Join them; it only takes a minute: Sign up Run time error 3021 - EOF or BOF is true or the current record has been deleted up vote 0 down vote I have also mentioned in which do i get the error when I click on debug. 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

Error No. : 3012 Error description : Either BOF or EOF is True, or the current record has been deleted. I just chopped out all the code to get to the minimum case causing my error, to make it quick and easy for people to look at. –Colin Nov 12 '09 When the form loads, the client combo box gets populated with all the clients. Browse other questions tagged vb6 or ask your own question.

Either BOF or EOF is True, or the current record has been deleted. Are there any rules or guidelines about designing a flag? Either BOF or EOF is true or the current record has been deleted. It would be a bit easier to help if you provided ALL the necessary info to debug the issue. –C-Pound Guru Oct 13 '15 at 18:24 @C-PoundGuru : Hi,

Results 1 to 12 of 12 Thread: Runtime error 3021- Either BOF or EOF is true, Unable to resolve this Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Appease Your Google Overlords: Draw the "G" Logo My pictures come out bland: Should I change from Nikon to Canon? My best guess is the query returns no rows because it includes a space just before the value of idtask, and no [ID - Tarefa] values match space plus idtask: idfunc Got the offer letter, but name spelled incorrectly How to avoid Root[] when using Solve[] What is the weight that is used to balance an aircraft called?

share|improve this answer answered Oct 13 '15 at 18:53 John Price 864 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Insults are not welcome. I've just forwarded this onto a friend who was doing a little homework on this.And he in fact ordered me breakfast due to the fact that I discovered it for him...lol.

more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science Do you need your password? Optional Password I have read and agree to the Terms of Service and Privacy Policy Please subscribe me to the CodeProject newsletters Submit your solution! The mortgage company is trying to force us to make repairs after an insurance claim Are there any rules or guidelines about designing a flag?

Your Email This email is in use. Else, i'm sure someone more experienced here might help u out. Let's work to help developers, not make them feel stupid. I have 2 combo boxes in a form- One for the client and the other for the projects.

Requested operation requires a current record. I so much surely will make sure to don?t disregard this web site and provides it a look regularly.Also visit my page :: AdrienYMckeirnanReplyDeleteAnonymousJuly 27, 2015 at 7:43 PMHey!

Please give us: A description of each table: the name of the table; the names and data types of the fields, and any relationships between the fields of one table and Whenever you issue either the .AddNew or the .Edit method on a recordset, you must finish the operation with either a .Update or a .CancelUpdate method. Below is the part that worked (BTW, here is just a key so you know what means what just incase u get confused... You can copy the statement text and paste it into SQL View of a n...

Determine if a coin system is Canonical How to solve the old 'gun on a spaceship' problem? share|improve this answer edited Jun 27 '13 at 7:34 answered Jun 27 '13 at 6:51 Gord Thompson 56.3k74794 Thank you for your answer. Why do you think that might be? It opens the recordset, loops through the records until it finds a person that matches BOTH criteria, sends the e-mail, and continues to loop through and sending messages to the appropriate FlexGrid: fill from recordset .?. If you we...

I have no problem to complete my MACRO. And, long ago, I decided that, if I'm going to "touch" every record in the database, I'll just count them myself. There's just no guarantee of the order of the records. DriverDoc updates all of your PC device drivers, not just those associated with your 3021 error. Checking for .eof is a more fool proof method. Corruption in Windows registry from a recent Microsoft Access-related software change (install or uninstall). simply Code: rt.addnew rt!f...

I did it, but it doesn't help :/ –Kaja Jun 27 '13 at 6:55 1 @Kaja I have updated my answer. –Gord Thompson Jun 27 '13 at 7:35 add a You're right. Reply from Martin Walke | Jul 28, 2011 Popular White Paper On This Topic The Six Questions Every IT Leader Needs to Ask All Replies (6) Best Answer 1 Mark this Beyond that, it's just completely untrustworthy. View All Topics View All Members View All Companies Toolbox for IT Topics Visual Basic Groups Ask a New Question Visual Ba...