JWColby
jwcolby at colbyconsulting.com
Tue Nov 28 09:15:18 CST 2006
LOL, and even then you get about twice as much per year as they do over the mountains in Yuma. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Beach Access Software Sent: Tuesday, November 28, 2006 9:51 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] DAO Field Name String/Variable Yeah, real gully washer. As you know we had several hundredths of an inch last week - our first in about nine months - and 90 accidents on the freeways. Yesterday we had 9 hundredths of an inch!!! With commensurate loss of life and property. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood Sent: Monday, November 27, 2006 10:06 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] DAO Field Name String/Variable Hey Rocky, Yeah, but i was truing to use teh !String convention. Oh well workied around it. Looks like i missed teh rain back home. See you soon. bob -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Beach Access Software Sent: Monday, November 27, 2006 2:34 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] DAO Field Name String/Variable Bob: Right off the top of my head, I think, after you get the field name from the first recordset into a string variable like strFieldName, then in the second recordset you'd want to use rs2(strFieldName) to get reference the value from that field of the record that recordset rs2 is currently pointing to. Clear as mud? Call me if you want to - 858-259-4334. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood Sent: Monday, November 27, 2006 2:20 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] DAO Field Name String/Variable in my example the field names are in table 1. Sorry i'm Vegas working on a laptop..... Will visit soon. bob -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Beach Access Software Sent: Monday, November 27, 2006 12:20 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] DAO Field Name String/Variable So table one contains the field names of table 2? Rocky P.S. Swing by my office with your laptop and I'll do it for you on the spot (yes I have an ulterior motive). -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood Sent: Monday, November 27, 2006 11:24 AM To: Access Developers discussion and problem solving Subject: [AccessD] DAO Fiekd Name String/Variable Hello to the list, I woild like to: 1. get a value from one table as a string 2. lookup the value of a field in a second table where the field name = the value of field in table 1 Using !s if possible. TIA best Bob -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.430 / Virus Database: 268.14.16/552 - Release Date: 11/26/2006 11:30 AM -- 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 -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.430 / Virus Database: 268.14.16/552 - Release Date: 11/26/2006 11:30 AM -- 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 -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.430 / Virus Database: 268.14.19/555 - Release Date: 11/27/2006 6:09 PM -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com