Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-access > #10863

Re: DMax with Text Field

From Ron Weiner <rw@domain.com>
Newsgroups comp.databases.ms-access
Subject Re: DMax with Text Field
Date 2015-06-23 20:46 -0400
Organization WorksRite
Message-ID <mmcuin$147$1@dont-email.me> (permalink)
References (3 earlier) <mmagr6$rpo$1@dont-email.me> <br0joatc8hi8qedge8q1gbj5n3965buuln@4ax.com> <vf1joatjr2hrm16u23u49u92as9b7dafgq@4ax.com> <mmc2js$ntu$1@dont-email.me> <7lcjoah7rsca1ru2k38grsa2pccdcd8f8n@4ax.com>

Show all headers | View raw


>
> The error msg was, "You cancelled the previous operation".
>
> It stopped on:
>
> If DLookup("Depleted","qryDepleted")=0 then

And the sql for the query "qryDepleted" is?

Seriously, you have received 3 answers to your original post all of 
which look like that should work.  If you have try'd all of them, and 
it still dosen't work, then you need to give us more information.  
Consider providing the DDL for the table in question and all of the 
other code in the Sub or function.  We can not see your project.

Rdub

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

DMax with Text Field croy <croy@invalid.net> - 2015-06-22 08:12 -0700
  Re: DMax with Text Field Ron Weiner <rw@domain.com> - 2015-06-22 13:40 -0400
    Re: DMax with Text Field croy <croy@invalid.net> - 2015-06-22 13:31 -0700
      Re: DMax with Text Field "Phil" <phil@stantonfamily.co.uk> - 2015-06-22 22:43 +0100
      Re: DMax with Text Field Ron Weiner <rw@domain.com> - 2015-06-22 22:39 -0400
        Re: DMax with Text Field croy <croy@invalid.net> - 2015-06-23 09:06 -0700
          Re: DMax with Text Field croy <croy@invalid.net> - 2015-06-23 09:19 -0700
            Re: DMax with Text Field Ron Weiner <rw@domain.com> - 2015-06-23 12:49 -0400
              Re: DMax with Text Field croy <croy@invalid.net> - 2015-06-23 12:27 -0700
                Re: DMax with Text Field croy <croy@invalid.net> - 2015-06-23 12:29 -0700
                Re: DMax with Text Field Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-06-23 12:45 -0700
                Re: DMax with Text Field croy <croy@invalid.net> - 2015-07-07 07:19 -0700
                Re: DMax with Text Field Ron Weiner <rw@domain.com> - 2015-06-23 20:46 -0400
                Re: DMax with Text Field croy <croy@invalid.net> - 2015-07-07 07:17 -0700
                Re: DMax with Text Field Ron Weiner <rw@domain.com> - 2015-07-07 16:40 -0400

csiph-web