Solved

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

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
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…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

832 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