Lembit Soobik
lembit.dbamail at t-online.de
Tue Jul 7 12:34:56 CDT 2009
no, Gustav, Z as Single would do it also, but the real problem is the unbound form in connection with a surrogat key. BTW, Drew, what are you testing? IQ or responstime? Lembit ----- Original Message ----- From: "Gustav Brock" <Gustav at cactus.dk> To: <accessd at databaseadvisors.com> Sent: Tuesday, July 07, 2009 7:14 PM Subject: Re: [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 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com