PC Review


Reply
Thread Tools Rate Thread

Displaying Fields From Other Table

 
 
Din Zavery
Guest
Posts: n/a
 
      21st Jan 2007
Greetings,

I have a form that is based on a MiscTransactions Table and displays all teh
fields for entering records. Now this table has certain fields that are
coming from other tables. i.e. They are setup codes from other setup tables.

What I want is to display the descriptions so that when a user is entering
or viewing the form he/she can see what that code reflects to.

Thanks and Regards
Fakhruddin Zavery


 
Reply With Quote
 
 
 
 
Allen Browne
Guest
Posts: n/a
 
      21st Jan 2007
For an example of how to loop through the Fields of a TableDef and read the
Description property for fields where a Description is set, see this code:
http://allenbrowne.com/func-06.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Din Zavery" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Greetings,
>
> I have a form that is based on a MiscTransactions Table and displays all
> teh fields for entering records. Now this table has certain fields that
> are coming from other tables. i.e. They are setup codes from other setup
> tables.
>
> What I want is to display the descriptions so that when a user is entering
> or viewing the form he/she can see what that code reflects to.
>
> Thanks and Regards
> Fakhruddin Zavery


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying merged cells fields in Pivot table maggiewall Microsoft Excel Misc 0 26th Nov 2007 02:20 AM
Displaying fields in a stock table =?Utf-8?B?UmF5IEM=?= Microsoft Access Getting Started 10 12th May 2007 06:56 PM
Fields not displaying info, but table is correct =?Utf-8?B?SkRKb25lcw==?= Microsoft Access Forms 1 6th Oct 2006 12:29 AM
Multi-table report displaying fields incorrectly =?Utf-8?B?bmVtZXNpczE1Mw==?= Microsoft Access Reports 2 14th Feb 2006 05:03 AM
Displaying items within pivot table fields Gerald Microsoft Excel Misc 1 9th Aug 2003 03:37 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:24 AM.