Re: FW: Access 2000

Subject: Re: FW: Access 2000
From: "Dick Margulis " <margulis -at- mail -dot- fiam -dot- net>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Mon, 7 Apr 2003 15:19:37 -0400

---------- Original Message ----------------------------------
"David A. Barrett" <david -at- nichesyndicate -dot- com> wrote:

>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.


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:

dim objTablename, full_name

full_name = objTablename("First_Name") & " " & objTablename("Last_Name")

response.write full_name



Purchase RoboHelp X3 in April and receive a $100 mail-in
rebate, plus FREE RoboScreenCapture and WebHelp Merge Module.
Order here:

Help celebrate TECHWR-L's 10th Anniversary starting this month!
Check out the contests at
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 for more resources and info.

Previous by Author: A rant about ideas, not persons
Next by Author: Re: Draft then Tag, or Tag while Drafting?
Previous by Thread: Re: Access 2000
Next by Thread: Draft then Tag, or Tag while Drafting?

What this post helpful? Share it with friends and colleagues:

Sponsored Ads