Rabu, 09 Agustus 2017

Re: [MS_AccessPros] combo to textbox

 

John,

Its where you can assign a control type Lookup tab in the table designer. But you are probably right I should just create a lookup table.


With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Valar Dohaeris"








On ‎Tuesday‎, ‎August‎ ‎8‎, ‎2017‎ ‎04‎:‎26‎:‎25‎ ‎PM, John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

Art-


Do you mean a multi-valued field?  Those are just a plain bad idea.

Maybe this article will help:

But you're much better off creating a separate "lookup" table.  You'll have more control over that.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Aug 8, 2017, at 4:20 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:




I have a table which has a field as follows:


licensetypeid  number

it is defined as a valuefield

1;RMS Pro Standard;2;RMS Pro Enterprise;3;RMS Pro CRM;4;RMS PRO WIM;5;RMS Pro Housing Pro;6;RMS PRO IP

column width: 0;1


Now on the form I want to display what is in the second column. How would I do that?


Thank you,


Art Lorenzini

Sioux Falls, SD




__._,_.___

Posted by: Art Lorenzini <dbalorenzini@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar