[AccessD] DAO Field Name String/Variable

Bob Heygood bheygood at abestsystems.com
Tue Nov 28 00:05:47 CST 2006


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






More information about the AccessD mailing list