[AccessD] test

Hi Drew

The reason for your trouble is that you forgot to dim Z as Double. 
Susan missed that, she believes you are joking (I think) or having an XML source file which you, of course, shouldn't.

/gustav


>>> DWUTKA at marlow.com 07-07-2009 18:18 >>>
LOL!

Whoops, I missed a line:

> Dim x As New ADODB.Recordset
> StartOfCode:
> Z=45.6
>  Dim h as String
Exit function
> H=12
> Goto StartOfCode

LOL

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, July 07, 2009 11:13 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] test

That's just sick! ;)

Susan H.


>I have an unbound form, where the primary key of the table being used is
> a surrogate key/lookup field.  And for some reason, I can't get the
> following code to work:
>
> Dim x As New ADODB.Recordset
> StartOfCode:
> Z=45.6
>  Dim h as String
> H=12
> Goto StartOfCode
>
> <grin>
>
> Drew
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Monday, July 06, 2009 8:25 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] test
>
> Oh yea!!!  Something like "Access 2007 is superior to anything before
> because it doesn't allow
> surrogate keys"...
>
> John W. Colby
> www.ColbyConsulting.com