Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 2nd, 2006, 04:13 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default Replacing abbreviation with proper text

Hi All Again
I receive information in a database with a shorten version of details
Example CS = International and LS = Local.There are 23 different types of these abbreviations.
Is there any way of replacing the shorten version with the correct version in a report.I have created a table with the both versions.
Thanks


Brendan Bartley
__________________
Brendan Bartley
 
Old June 2nd, 2006, 07:30 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

TO use States in the US as an example, what I do is have a look up table that has these fields:

tblState
StateID = text, like "DE," "MD," etc as PK
StateName = text, like "Delaware," "Maryland," etc.

I allow the user to pull up the abbreviation in the forms, and then when I run a report for addresses, for example, I pull the StateName column instead of the PK field. The nice thing is, even if you only have the State abbrev in the table, you can add the StateName field at any time and replace it in all your queries.

Does this help?


mmcdonal
 
Old June 2nd, 2006, 08:03 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for you're reply
The only problem I have is that the details are all ready in the database how do I update the data for the report
Thanks

Brendan Bartley





Similar Threads
Thread Thread Starter Forum Replies Last Post
Proper use of Arbiters scott.nortman BOOK: Professional Microsoft Robotics Studio ISBN: 978-0-470-14107-6 1 June 23rd, 2008 08:06 PM
Replacing text in text box inside table Larry Landis Word VBA 0 December 27th, 2007 12:03 PM
Convert text from excel to proper date in access bprodman Access VBA 1 June 18th, 2007 03:48 PM
Replacing Text with a String in a Form newgeek Beginning VB 6 2 August 14th, 2003 12:37 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.