Adding a NULL Value in a Currency table in an Access DB

[Raven]

Hello there,

I have a problem with Adding a NULL Value in a Currency table in an Access
database. The problem accurs when i'm trying to Update an empty field. The
error message is:

Error Type:
Provider (0x80020005)
Type mismatch.
/travel/update_delete_datprijs.asp, line 43


Can some one help me with a solution?

Thanks in advance.

[Bob Barrows]

Raven wrote:

> Hello there,
>
> I have a problem with Adding a NULL Value in a Currency table in an
> Access database. The problem accurs when i'm trying to Update an
> empty field. The error message is:
>
> Error Type:
> Provider (0x80020005)
> Type mismatch.
> /travel/update_delete_datprijs.asp, line 43
>
>
> Can some one help me with a solution?
>
> Thanks in advance.

This always seems to work for me:
update table set [moneyfield] = Null

Bob Barrows

[Bob Barrows]

Raven wrote:

> Hello there,
>
> I have a problem with Adding a NULL Value in a Currency table in an
> Access database. The problem accurs when i'm trying to Update an
> empty field. The error message is:
>
> Error Type:
> Provider (0x80020005)
> Type mismatch.
> /travel/update_delete_datprijs.asp, line 43
>
>
> Can some one help me with a solution?
>
> Thanks in advance.

Please do not multipost. i've already answered this question over in
..asp.db.

[Ronnie Patton]

a currency cant be null dont add null add 0.00 or 0 instead. Try it
"Raven" <raviram@tiscali.nl> wrote in message
news:bfgctc$pvc$1@reader1.tiscali.nl...

> Hello there,
>
> I have a problem with Adding a NULL Value in a Currency table in an Access
> database. The problem accurs when i'm trying to Update an empty field. The
> error message is:
>
> Error Type:
> Provider (0x80020005)
> Type mismatch.
> /travel/update_delete_datprijs.asp, line 43
>
>
> Can some one help me with a solution?
>
> Thanks in advance.
>
>

[Raven]

Hello Bob,

Thank you for your support, it's working.

Raven

"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:%23HRA4k3TDHA.1868@TK2MSFTNGP11.phx.gbl...

> Raven wrote:

> > Hello there,
> >
> > I have a problem with Adding a NULL Value in a Currency table in an
> > Access database. The problem accurs when i'm trying to Update an
> > empty field. The error message is:
> >
> > Error Type:
> > Provider (0x80020005)
> > Type mismatch.
> > /travel/update_delete_datprijs.asp, line 43
> >
> >
> > Can some one help me with a solution?
> >
> > Thanks in advance.

>
> This always seems to work for me:
> update table set [moneyfield] = Null
>
> Bob Barrows
>
>
>

[Raven]

The problem is solved.

"Ronnie Patton" <someone@microsoft.com> wrote in message
news:s4RSa.8271$ii2.817@fe2.columbus.rr.com...

> a currency cant be null dont add null add 0.00 or 0 instead. Try it
> "Raven" <raviram@tiscali.nl> wrote in message
> news:bfgctc$pvc$1@reader1.tiscali.nl...

> > Hello there,
> >
> > I have a problem with Adding a NULL Value in a Currency table in an

Access

> > database. The problem accurs when i'm trying to Update an empty field.

The

> > error message is:
> >
> > Error Type:
> > Provider (0x80020005)
> > Type mismatch.
> > /travel/update_delete_datprijs.asp, line 43
> >
> >
> > Can some one help me with a solution?
> >
> > Thanks in advance.
> >
> >

>
>