Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / August 2006

Tip: Looking for answers? Try searching our database.

Creating FullName from FirstName and LastName in a form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brucear - 12 Aug 2006 09:44 GMT
I capture LastName and FullName in my Form (Capture Students) and want to
autofill the FullName field in the CaptureStudents form. How do I do this?
Signature

Bruce Rae

Wayne-I-M - 12 Aug 2006 10:03 GMT
In a query
Name: [Table]![1stName] &" "& [Table]![Surname]

In a form (text box control source)
= [1stName] &" "&[Surname]

Signature

Wayne
Manchester, England.
Not an expert.  
Enjoy whatever it is you do.

> I capture LastName and FullName in my Form (Capture Students) and want to
> autofill the FullName field in the CaptureStudents form. How do I do this?
Brucear - 12 Aug 2006 10:27 GMT
Tnaks, Wayne - simple when you know how. I knew the syntax but had not
thought of putting it into the box!
Signature

Bruce Rae

> In a query
> Name: [Table]![1stName] &" "& [Table]![Surname]
[quoted text clipped - 4 lines]
> > I capture LastName and FullName in my Form (Capture Students) and want to
> > autofill the FullName field in the CaptureStudents form. How do I do this?
Wayne-I-M - 12 Aug 2006 10:49 GMT
I know exactly what you mean.  1 + 1 = 2  is simple if you understand the
basic principles behind the + sign and know that the = sign indecates the
results.  

I get loads of tips from this site which when you see them in front of you
"seem" so obvious "but" the original thought by some programmers and MVP’s  
is way above my level.

At the moment (today and for the last week and the next few weeks) I am
trying to combine the 3 access D Bases of an international trekking company
which when it's done will (hopefully) not only produce all the reports
(letters, e mails) that the clients require but also produce different
reports that the government require.  Combine this with ticketing for
airlines, permits from everywhere from Nepal to Peru and Tanzania - not to
mention secure accounts auditing (with they want – to be useable in UK
Pounds, US Dollars and Euros – all linked to a RealTime rate from the web) ,
etc etc. aaaarrrrrgggghhhh :-)

Like you say it's easy when you know - I guess that when I present it, in
all its full flowing simplicity and designed end-user ease (ha ha ha) their
IT dept will say. “Oh yeah, we could have done that”.  Ain't that always the
case?

has 3 seperate D Bases
Signature

Wayne
Manchester, England.
Not an expert.  
Enjoy whatever it is you do.

> Tnaks, Wayne - simple when you know how. I knew the syntax but had not
> thought of putting it into the box!
[quoted text clipped - 7 lines]
> > > I capture LastName and FullName in my Form (Capture Students) and want to
> > > autofill the FullName field in the CaptureStudents form. How do I do this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.