Solved

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

Posted on 2002-03-21
5
245 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 49

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
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…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

705 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now