Jim Lawrence
accessd at shaw.ca
Sat Jan 28 14:26:34 CST 2006
Hi Rocky: Isn't the record defined as a row and a field as a column? Here is a piece of code that works with a recordset, a standard data set should not work much differently. Dim RowPosition as long Dim ColumnPosition as integer RowPosition = 1200 ColumnPosition = 12 With rsMyRecordset .Move First .Move (RowPosition) MyFieldValue = .Fields(ColumnPosition) End With HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - Beach Access Software Sent: January 28, 2006 10:05 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Function Error How is Row defined as a field in the table that the query uses? Rocky Gowey Mike W wrote: > Sorry about that, > > If I run qryInmatesBinNumberUpdate it runs fine. > > If I run > > SELECT SID FROM qryInmatesBinNumberUpdate WHERE Row = '0' > > OR > > SELECT SID FROM qryInmatesBinNumberUpdate WHERE Row = 0 > > They both give me invalid procedure call > > Interesting...... > > -----Original Message----- > From: Gustav Brock [mailto:Gustav at cactus.dk] > Sent: Friday, January 27, 2006 10:35 AM > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] Function Error > > Hi Mike, you didn't reveal the result of this: > > >> 2005-01-27 16:09:23 >> > > Have you tried running this on its own: > > qryInmatesBinNumberUpdate > > and this in a new query: > > SELECT SID FROM qryInmatesBinNumberUpdate WHERE Row = '0' > > or should it be: > > SELECT SID FROM qryInmatesBinNumberUpdate WHERE Row = 0 > > /gustav > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > -- Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com