Re: MS-Access and Data Verification
- From: "Mesut" <mesut.kokalan@xxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Fri, 10 Jun 2011 21:43:53 +0300
You can do this buy using stored procedures.
----- Original Message -----
From: "Homme, James" <james.homme@xxxxxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx>
Sent: Friday, June 10, 2011 7:54 PM
Subject: RE: MS-Access and Data Verification
Hi Bill,
I think this is possible. Unfortunately I don't know the exact SQL syntax,
but I think it can work. You'd simply say something like:
select table.field
where table.other_field = 'data_I_wwant_to_search_on';
Jim
-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Bill Gallik
Sent: Friday, June 10, 2011 10:27 AM
To: Blind Programming
Subject: MS-Access and Data Verification
Can anybody tell me if the following can be done, it's a somewhat recursive
scenario:
1) There's a "Donor Table" in the database, each record consisting of a
key, name and address usual info and a reference to another contact. That
contact should be another/different entry in the same table. Can Access be
configured to use the same table for which a new record is being added to
verify the validity of another entry in that table?
For example, the XYZ Foundation has been an annual donor to a charity. The
person to directly contact for XYZ Foundation is John Doe, is it possible to
fill in the "Contact" data field for XYZ Foundation with the key identifying
John Doe and have Access use the same Donor Table to verify John Doe's key?
----
Holland's Person, Bill
- The early bird may get the worm, but the second mouse gets the cheese!
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
This e-mail and any attachments to it are confidential and are intended
solely for use of the individual or entity to whom they are addressed. If
you have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
keep, use, disclose, copy or distribute this e-mail without the author's
prior permission. The views expressed in this e-mail message do not
necessarily represent the views of Highmark Inc., its subsidiaries, or
affiliates.
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
