[AccessD] DAO Field Name String/Variable

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




More information about the AccessD mailing list