Prev: Track Name Autocorrect error when running mdb in 2007
Next: Access 2010 webbrowser control
From: Vincent on 8 Jun 2010 09:20
The following was ran from the immediate window of Access 2007:

?DLookup("PurgePeriod", "Info") = ""
True

?IsNumeric("")
False

?IsNumeric(DLookup("PurgePeriod", "CompanyInfoMaster"))
True


Huh? Is someone able to explain this?

Vincent
From: XPS35 on 8 Jun 2010 10:06
Vincent wrote:

> The following was ran from the immediate window of Access 2007:
>
> ?DLookup("PurgePeriod", "Info") = ""
> True
>
> ?IsNumeric("")
> False
>
> ?IsNumeric(DLookup("PurgePeriod", "CompanyInfoMaster"))
> True
>
>
> Huh? Is someone able to explain this?
>
> Vincent

The value of a boolean (yes/no) field is either -1 (representing true)
or 0 (false).
Try using IsNumeric in a query and you see only -1 or 0 in the column.

--
Groeten,

Peter
http://access.xps350.com


--- news://freenews.netfront.net/ - complaints: news(a)netfront.net ---
From: Bob Barrows on 8 Jun 2010 10:42
Vincent wrote:
> The following was ran from the immediate window of Access 2007:
>
> ?DLookup("PurgePeriod", "Info") = ""
> True
>
> ?IsNumeric("")
> False
>
> ?IsNumeric(DLookup("PurgePeriod", "CompanyInfoMaster"))
> True
>
>
> Huh? Is someone able to explain this?
>
You do realize that, without criteria, the DLookup returns the value from a
random row in the domain (table) you are searching ...

Given that, perhaps the PurgePeriod field in the Info table contains an
empty string in the random row examined by DLookup, and the PurgePeriod in
CompanyInfoMaster contains a number in the random row selected by Dlookup?

--
Bob Barrows


From: Vincent on 8 Jun 2010 10:49
On Jun 8, 10:42 am, "Bob Barrows" <reb01...(a)yahoo.com> wrote:
> Vincent wrote:
> > The following was ran from the immediate window of Access 2007:
>
> > ?DLookup("PurgePeriod", "Info") = ""
> > True
>
> > ?IsNumeric("")
> > False
>
> > ?IsNumeric(DLookup("PurgePeriod", "CompanyInfoMaster"))
> > True
>
> > Huh?  Is someone able to explain this?
>
> You do realize that, without criteria, the DLookup returns the value from a
> random row in the domain (table) you are searching ...
>
> Given that, perhaps the PurgePeriod field in the Info table contains an
> empty string in the random row examined by DLookup, and the PurgePeriod in
> CompanyInfoMaster contains a number in the random row selected by Dlookup?
>
> --
> Bob Barrows

Nope. There is only one row in this table.

Vincent
From: Bob Barrows on 8 Jun 2010 10:59
Vincent wrote:
> On Jun 8, 10:42 am, "Bob Barrows" <reb01...(a)yahoo.com> wrote:
>> Vincent wrote:
>>> The following was ran from the immediate window of Access 2007:
>>
>>> ?DLookup("PurgePeriod", "Info") = ""
>>> True
>>
>>> ?IsNumeric("")
>>> False
>>
>>> ?IsNumeric(DLookup("PurgePeriod", "CompanyInfoMaster"))
>>> True
>>
>>> Huh? Is someone able to explain this?
>>
>> You do realize that, without criteria, the DLookup returns the value
>> from a random row in the domain (table) you are searching ...
>>
>> Given that, perhaps the PurgePeriod field in the Info table contains
>> an empty string in the random row examined by DLookup, and the
>> PurgePeriod in CompanyInfoMaster contains a number in the random row
>> selected by Dlookup?
>>
> Nope. There is only one row in this table.
>
My point was: your example code is referring to two different tables. You
told us what DLookup returns from Info. What does it return from
CompanyInfoMaster?

--
Bob Barrows


 |  Next  |  Last
Pages: 1 2
Prev: Track Name Autocorrect error when running mdb in 2007
Next: Access 2010 webbrowser control