Automatic insertion of data

How do I have Access automaticaly insert info into one field after I have
entered info into another field. Example - I want to enter an "Employee Name"
in a field and I want their "Employee Number" to be automatically entered
into another field on the form. I have already created a table with the names
and numbers

Thanx,

Paul

Hi Paul,

Take a look at the following knowledge base articles for starters:

ACC2000: How to Populate Text Boxes with Multicolumn Combo Box Selections
(322900)
http://support.microsoft.com/default...B;EN-US;322900

ACC2000: How to Use the Column Property of a Combo Box to Update a Text Box
(209738)
http://support.microsoft.com/default...B;EN-US;209738

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: Automatic insertion of data
| thread-index: AcR/Dp1ipLaP43g2Q9SAYvZAfrEX3w==
| X-WBNR-Posting-Host: 206.71.120.1
| From: =?Utf-8?B?cG1wMzUw?=
| Subject: Automatic insertion of data
| Date: Tue, 10 Aug 2004 12:17:02 -0700
| Lines: 9
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:82652
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| How do I have Access automaticaly insert info into one field after I have
| entered info into another field. Example - I want to enter an "Employee
Name"
| in a field and I want their "Employee Number" to be automatically entered
| into another field on the form. I have already created a table with the
names
| and numbers
|
| Thanx,
|
| Paul
|

Eric,

I want to use the DLookUp function but I am not getting what I need. In my
combo box, named "Name", I can choose the employee name I want but in my text
box, named "Emp#", I just get an error message. My table that has the
employee info is named "Employees".

The headings for the "Employee" table are-

Name Employee Emp# Start Date

I have been trying to type in the formula as it is written in the article
but I don't know if I'm getting all the " ) [ and , correctly. I don't know
if there are supposed to be spaces between the different expressions.

I hope I have given you enough info to help me as I really don't want to go
buy "Access for Dummies"

Thanx,

Paul

"Eric Butts [MSFT]" wrote:

Hi Paul,

Take a look at the following knowledge base articles for starters:

ACC2000: How to Populate Text Boxes with Multicolumn Combo Box Selections
(322900)
http://support.microsoft.com/default...B;EN-US;322900

ACC2000: How to Use the Column Property of a Combo Box to Update a Text Box
(209738)
http://support.microsoft.com/default...B;EN-US;209738

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: Automatic insertion of data
| thread-index: AcR/Dp1ipLaP43g2Q9SAYvZAfrEX3w==
| X-WBNR-Posting-Host: 206.71.120.1
| Wrom: CJVTLBXFGGMEPYOQKEDOTWFAOBUZXUWLSZLKBRNVWWCUFPEGAU TFJMV
| Subject: Automatic insertion of data
| Date: Tue, 10 Aug 2004 12:17:02 -0700
| Lines: 9
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:82652
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| How do I have Access automaticaly insert info into one field after I have
| entered info into another field. Example - I want to enter an "Employee
Name"
| in a field and I want their "Employee Number" to be automatically entered
| into another field on the form. I have already created a table with the
names
| and numbers
|
| Thanx,
|
| Paul
|

=?Utf-8?B?cG1wMzUw?= wrote in
:

I want to use the DLookUp function but I am not getting what I need.
In my combo box, named "Name", I can choose the employee name I want
but in my text box, named "Emp#", I just get an error message. My
table that has the employee info is named "Employees".


I am not completely clear what you are trying to achieve here. It sounds
like you have a form bound to the Employees table, and you want to be able
to choose a name from a combo and have the form placed on the correct
Employee record. If that's not right, then don't bother reading on!

You should start with an unbound combo called, say, cboPickName. You should
set its rowsource to something like

SELECT DISTINCT FullName FROM Employees

(side note: Name is a really bad choice for a field name, because it's the
name of a property of just about every object in the Access world. If you
have to use it, then it needs brackets round it like this, "SELECT [Name]
etc". But it's a bug waiting to happen, and it is a good idea just to use a
better field name.)

Now you can use the OnChange to set the Filter property of the form

Private Sub cboPickName_Change()

' set the filter to records with the same name
Me.Filter = "FullName = """ & cboPickName & """"
' and make it look them up
Me.Requery

End Sub

You can then use the PgUp and PgDn keys to move between all the "John
Smith" records to find the one you want.

An easier way is to teach your users to use the query-by-form method of
finding names, so you don't have to do any programming at all.

Hope that helps


Tim F