TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
---------- Original Message ----------------------------------
"David A. Barrett" <david -at- nichesyndicate -dot- com> wrote:
>
>Howdy!
>
>1) We are using Access 2000 and we are in the Design View
>
>2) The database contains these three fields:
>
>a) full_name (Text)
>
>b) First_Name (Text)
>
>C) Last_Name (Text)
>
>3) We want to set up and expression or rule so that data entered in
>"First_Name" and "Last_Name" will be automatically entered into "full_name".
>
>4) We tried setting up an expression using a "Default Value" and we took a
>worthy stab at an expression in the "Validation Rule". None of our efforts
>have seemed to work.
>
David,
I'm not a certified DBA, but I've absorbed a little bit of knowledge about the subject.
For starters your table should contain only two fields, not three.
I'm sure there is some way in Access to build a query (not a table) that combines the two names and puts a space between them. In my case, though, I do this sort of thing in an ASP page using Visual Basic, where it would look more or less like this:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Purchase RoboHelp X3 in April and receive a $100 mail-in
rebate, plus FREE RoboScreenCapture and WebHelp Merge Module.
Order here: http://www.ehelp.com/products/robohelp/
Help celebrate TECHWR-L's 10th Anniversary starting this month!
Check out the contests at http://www.raycomm.com/techwhirl/special/contests/
Happy birthday to you, happy birthday to you, happy birthday TECHWR-L....
---
You are currently subscribed to techwr-l as:
archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit http://www.raycomm.com/techwhirl/ for more resources and info.
