Re: Checking Tadoquery for changes


>
> Is there anyway I can check a query for changes?
>
> Reason being, I don't want to prompt the user to save the information on
> the form close if the data has not been modified or is blank.
>

Hi,

I think we can check the status of the ADODataset when close form. May be
like this
FormCloseQuery(....)
begin
if ADODataset.State in [dsEdit,dsInsert] then
if MessageDlg('Save change?',mtConfirmation,[mbYes,mbNo],0) = mrYes
then
ADODataset.Post
else
ADODataset.Cancel;
end;

Thang


.

Relevant Pages

  • Time () on the form
    ... on table and query. ... [StartTime] ... Is there a reason for Timethat won't work on Access 2002? ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • RE: prompt criteria in find command
    ... the reason why I am not creating a query to prompt the ... user for criteria is that although my main form where I want to do my search ...
    (microsoft.public.access.formscoding)
  • Can you use a combo box in a selct query
    ... I know when I build a query that I can prompt a user to answer a question, ... which will filter the data. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • TransferSpreadsheet
    ... I'm trying to export data from a query to excel but I need the 'save as' ... dialog box to prompt the user for a file name. ... Prev by Date: ...
    (microsoft.public.access.externaldata)
  • Re: Report: how to get rid of border
    ... > The reason that I used list box is that I want to get a count ... >, which is based on a query, show up in the report. ... Prev by Date: ...
    (comp.databases.ms-access)