Re: Refresh of a DBGrid

Bill Todd wrote:

> Save the primary key value(s) for the current record. Close the query.
> Open the query. Call Locate to find the record that was current.

additionally you could use DisableControls before closing the query and
EnableControls after locating the record. This way, the user will not
notice the closing/opening/locating, unless he or she is working on the
grid at the same moment of closing the dataset. In this case, the user
will not be able to continue to work on it until the EnableControls is
executed.

--
Best regards :)

Guillem Vicens
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
in order to contact me remove the -nospam
.

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)