[AccessD] Retrieving a Record Field

Yes, that makes sense.  With a recordset, you can retrieve a value from a
field by the field's position (the first field being 0), or by the field's
name.  So you could retrieve that value with something like
rs.Fields(rs.Fields("Huh_Field").value).value

Drew

-----Original Message-----
From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us]
Sent: Friday, April 04, 2003 8:14 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Retrieving a Record Field


That is correct, the name of the field that has the error will be
displayed in the field named Huh_Field.  I need to be able to display
the information that is in the field that is listed in Huh_field.  For
instance the DOB field is incorrect this field name will be listed in
the Huh_Field, I need than to display the information in the DOB field
so the end user can correct it.  I hope that makes sense.

Thanks,

Mike Gowey, MCP
Technical Support Analyst
SRCI ISSD Team Leader
(541)881-4808


-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com] 
Sent: Thursday, April 03, 2003 3:58 PM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Retrieving a Record Field


So let me get this straight.  You need to display a form, that has 'two'
fields at top, one is the name of the field that had an error, and the
second is the value of the field.  Right?  (Do you need to display the
rest of the data too?)

Drew

-----Original Message-----
From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us]
Sent: Thursday, April 03, 2003 10:53 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Retrieving a Record Field



Hi Everyone,

I have a a need to pull a field from a record in a database when the
field name is listed in another Field.

What I am doing is I have a flat file that is imported into an Oracle
database and it is run through a filter that checks the validity of
certain fields in each record.  If the record does not pass the filter
the record is put into a temp table and the field name that has the
error in it is put in a new field.  I need to be able to display the
field with the error on a form when the record is brought up.  This will
allow the end user to fix the record.

Is this possible???

Thanks,
  
Mike Gowey, MCP
Technical Support Analyst
SRCI ISSD Team Leader



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com