Jim Dettman <> wrote:
> So I may be missing the point, but what is it exactly that your
> complaining about? The fact that most MVP's don't know what their
> talking about, that you don't know Access, or that the database is
> not properly designed?
Pick any two.
Stephen Russell
DBA / .Net
Andy,
What's the error? My guess is that you have a broken reference in VBA.
Jim.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Andy Davies
Sent: Friday, September 29, 2006 7:42 AM
To: [EMAIL PROTECTED]
Subject: Re: [NF] Access and the Null
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Stephen Russell
Sent: Thursday, September 28, 2006 11:34 PM
To: [EMAIL PROTECTED]
Subject: [NF] Access and the Null Blues
Ok, if you NZ() you can shove a value in for the null in access. Took 5
different MVPs before the sixth came in with that lit
Andy Davies <> wrote:
>> Ok, if you NZ() you can shove a value in for the null in access.
>> Took 5 different MVPs before the sixth came in with that little
>> trick.
>
> I'm guessing this is a VB 'feature' and not specific to Access
> (Verity Stob has a nice diatribe about the inconsistencies o
Took me 5 minutes to figure out how to find the Immediate window. Didn't
blow up here.. Echoed 5 to the screen. Perhaps you have the Access
equivalent of a corrupt resource file?
Andy Davies wrote:
open Access (2003) -> vba window -> in the Immediate window type:
ax = "asdf g"
? instr(ax, " "
--- Access and the Access blues!!!
A user has a problem with Access which I traced to an expression in a query
(probably bad data but...) -
so I tried to verify the expression a step at a time - can anyone verify
this:
open Access (2003) -> vba window -> in the Immediate window type:
ax = "asdf
> Ok, if you NZ() you can shove a value in for the null in access. Took 5
> different MVPs before the sixth came in with that little trick.
I'm guessing this is a VB 'feature' and not specific to Access (Verity Stob
has a nice diatribe about the inconsistencies of Basic - well worth
googling for)
On 9/29/06, Stephen Russell <[EMAIL PROTECTED]> wrote:
Ok, if you NZ() you can shove a value in for the null in access. Took 5
different MVPs before the sixth came in with that little trick.
Be careful ...you'll end up liking FoxPro
A+
jml
___
Ok, if you NZ() you can shove a value in for the null in access. Took 5
different MVPs before the sixth came in with that little trick.
I did it in the report via:
=IIf(Len(Trim([Trouser 1] & ""))>0,1,0)+IIf(Len(Trim([Trouser 2] &
""))>0,1,0)+IIf(Len(Trim([Trouser 3] & ""))>0,1,0)+IIf(Len(Trim(
9 matches
Mail list logo