A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how can I type in cell and the rest of the row will fill in.



 
 
Thread Tools Display Modes
  #1  
Old March 5th, 2005, 07:01 PM
William from fl
external usenet poster
 
Posts: n/a
Default how can I type in cell and the rest of the row will fill in.

If I type in a empleyees # it will bring up employees name automatlicly
  #2  
Old March 5th, 2005, 08:23 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

I assume you have an employee table with all the information. I would create
a combo box based on this table and include all the columns you want to
"bring up". Name the combo box cboEmployeeNum. You can then add other text
boxes and set the control sources to something like:
=cboEmployeeNum.Column(1)
=cboEmployeeNum.Column(2)
=cboEmployeeNum.Column(3)
Theses text boxes will display the 2nd, 3rd, and 4th columns from the combo
box.
--
Duane Hookom
MS Access MVP
--

"William from fl" William from wrote in
message ...
If I type in a empleyees # it will bring up employees name automatlicly



  #3  
Old March 6th, 2005, 12:35 AM
william from fl
external usenet poster
 
Posts: n/a
Default



"Duane Hookom" wrote:

I assume you have an employee table with all the information. I would create
a combo box based on this table and include all the columns you want to
"bring up". Name the combo box cboEmployeeNum. You can then add other text
boxes and set the control sources to something like:
=cboEmployeeNum.Column(1)
=cboEmployeeNum.Column(2)
=cboEmployeeNum.Column(3)
Theses text boxes will display the 2nd, 3rd, and 4th columns from the combo
box.
--
Duane Hookom
MS Access MVP
--

"William from fl" William from wrote in
message ...
If I type in a empleyees # it will bring up employees name automatlicly


I understand the table part but how do you do a combo box and where do you type the controls in excel it is at the top but where in access

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.