Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Forms : Give a textfield the value of the concatenation of 2 previous fields

Posted on 2002-03-21
5
248 Views
Last Modified: 2006-11-17
Hi,

I'm new in programming forms in Access ( via VB or wizards).

On a form I have created a textfield A and a date field B.
I have another field C.  C is empty when opening the form and should have the value of the contatenation of A+B on exit of field B.  ( C is gonna be used as unique key).
How do I do that. I tried with C Default Value = [A]+[B].
But alas.


Somebody ideas.   Also can you please recommand we some tutorials on programming in Access  (VB and wizards) who are on the web?
0
Comment
Question by:ruddi
5 Comments
 
LVL 50

Expert Comment

by:Ryan Chong
ID: 6884938
Hi ruddi,

In Form_Current Event, try:

A.Value = B.Value + C.Value
0
 
LVL 1

Expert Comment

by:kirthir
ID: 6884949
In the killfocus event of B, add the following code

C.value = A.value+B.value
0
 
LVL 44

Expert Comment

by:bruintje
ID: 6884989
for the second part of the Q you could check

http://www.microsoft.com/OfficeDev/Articles/OPG/
0
 
LVL 1

Accepted Solution

by:
kirthir earned 100 total points
ID: 6884992
For the second part of the Question, you can check the following site
 
http://www.mvps.org/access/

0
 

Author Comment

by:ruddi
ID: 6885286
I hope the other ones are not angry at me because I give the points to kirthir. The tutorial he linked me to is just what I search however  (and free).
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question