exception : Either BOF or EOF is true or the current record has been deleted

From: Mradul Mandhanya (mradul.mandhanya_at_teleatlas.com)
Date: 07/05/04 

Date: Mon, 05 Jul 2004 16:41:48 +0530

hi

when i am converting my program from bde to ado,

whaen i run a query by a TADO query object , such as select something
from msaccess database, but if it does not get any value selected means
the record count of that query is 0

then when i am closing that query i am getting an exception in closing
that..

Either BOF or EOF is true or the current record has been
deleted,Requested operation requires a current record

please give me the solution for this...

bye
pintoo

Relevant Pages

  • Re: Calculation
    ... Working through your proposed suggestion will ... which is for 365 days after the closing date. ... Create a query using your existing table ... Drag tblDate.TheDate onto the date field from date field in the query. ...
    (microsoft.public.access.forms)
  • Re: Option Group Question
    ... I did the first one and put it in the query. ... the query it now says Closing And/Or Doc Prep instead of 1 And/Or 2. ... other thing is, if I want to pull ONLY the records marked "Closing", how do I ... there a way to make the 1 say Closing so on the report management knows what ...
    (microsoft.public.access.formscoding)
  • Re: SQL query help
    ... Check out http://www.aspfaq.com/etiquette.asp?id=5006 on how to post DDL ... and example data for your tables, along with the expected output from your ... I have a table with products and closing dates for each of 4 quarters ... I need a query that will look at earning_dates and return the latest 6 ...
    (comp.databases.ms-sqlserver)
  • Re: Enter Parameter Value
    ... The query the report is based on uses the values of the controls on the ... that pops up after closing my query dialog form. ... I have gone back and looked at my query, the record source of my combo ...
    (microsoft.public.access.queries)
  • back to main menu
    ... >Are you closing each of the menu forms as you open the ... >next one or are you just opening the next form? ... >to just Open it from a command button. ... >>select a Query Menu form, ...
    (microsoft.public.access.forms)