Blank Entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Newbie Here
Biting off more than I can chew, but anyway. Trying to create database for
purchase requisitions at work. Through trial and error I have been able to
fix most issues that have come up. Problem I seem to be having is on purchase
order form. I have created drop down boxes for vendor name and employee name.
On the vendor name I can pull up any vendor name and it shows on my form, but
for some reason when I click on employee name, I can see the list of
employees but when I select one it will not put it in the box. What can I do?
Thank you.
B.
 
Hello Newbie Here
Biting off more than I can chew, but anyway. Trying to create database for
purchase requisitions at work. Through trial and error I have been able to
fix most issues that have come up. Problem I seem to be having is on purchase
order form. I have created drop down boxes for vendor name and employee name.
On the vendor name I can pull up any vendor name and it shows on my form, but
for some reason when I click on employee name, I can see the list of
employees but when I select one it will not put it in the box. What can I do?
Thank you.
B.
Click to expand...

Correct the error in your form... which we cannot see, of course!

What are the Row Source and Control Source properties of the combo box
of employees? It may also help to check the Bound Column, Column Count
and ColumnWidths properties.

The Bound Column should be the unique EmployeeID from the Employee
table; the Row Source should be a query returning the ID and the
employee's name; the ID should be the bound column, and its width
should be zero.

John W. Vinson[MVP]
 
make sure your employee name combo box is set to the name of the field in
your form. Check to make sure the control source contains a field name for
the employees. Also, if you do not connect your employee list correctly to
the combo box even if the control source contains the field name, it won't
work. Your combo box at minimum should contain the Primary Key, lastname and
firstname, generally in this order for sorting purposes. The Primary key can
be hidden by defning your size as 0.
 
--
Like Nike "Just Do It"


John Vinson said:
Correct the error in your form... which we cannot see, of course!

What are the Row Source and Control Source properties of the combo box
of employees? It may also help to check the Bound Column, Column Count
and ColumnWidths properties.

The Bound Column should be the unique EmployeeID from the Employee
table; the Row Source should be a query returning the ID and the
employee's name; the ID should be the bound column, and its width
should be zero.

John W. Vinson[MVP]
Click to expand...

John,
Below is what I have found, not sure if that is the right thing.
Row Source is (SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employee ORDER BY [LastName] & ", " & [FirstName]; )
Click to expand...
Control Source is (EmployeeID) Bound Column is (1) Colume Count is (2)
Column Width is (0")

Thank you
B.
 
G.
I can change the row source for first name, last name or employee id and
they will show up in the box, but when I change it to first and last name, it
will not show up in the box.

Thank you.
B.
 
John,
Below is what I have found, not sure if that is the right thing.
Row Source is (SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employee ORDER BY [LastName] & ", " & [FirstName]; )
Click to expand...
Control Source is (EmployeeID) Bound Column is (1) Colume Count is (2)
Column Width is (0")
Click to expand...

Change Column Width to 0";1.25" <or some nonzero width). You're not
specifying a width in which to display the name.

John W. Vinson[MVP]

John W. Vinson[MVP]
 
John
Tried changing column width, but did not change. I changed the name of the
spreadsheet from employee to employees. Changed all the spreadsheet headers
and other places I could find. Could that have something to do with it? Maybe
not changed in all places.
B.
--
Like Nike "Just Do It"


John Vinson said:
John,
Below is what I have found, not sure if that is the right thing.
Row Source is (SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employee ORDER BY [LastName] & ", " & [FirstName]; )
Click to expand...
Control Source is (EmployeeID) Bound Column is (1) Colume Count is (2)
Column Width is (0")
Click to expand...

Change Column Width to 0";1.25" <or some nonzero width). You're not
specifying a width in which to display the name.

John W. Vinson[MVP]

John W. Vinson[MVP]
Click to expand...
 
--
Like Nike "Just Do It"


John Vinson said:
John,
Below is what I have found, not sure if that is the right thing.
Row Source is (SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employee ORDER BY [LastName] & ", " & [FirstName]; )
Click to expand...
Control Source is (EmployeeID) Bound Column is (1) Colume Count is (2)
Column Width is (0")
Click to expand...

Change Column Width to 0";1.25" <or some nonzero width). You're not
specifying a width in which to display the name.

John W. Vinson[MVP]

John W. Vinson[MVP]
Click to expand...
 
John
Tried changing column width, but did not change. I changed the name of the
spreadsheet from employee to employees. Changed all the spreadsheet headers
and other places I could find. Could that have something to do with it? Maybe
not changed in all places.
B.
--
Click to expand...

Wait a minute here. You're saying "spreadsheet" - an Excel construct.
Are you using Excel, or Access???

Obviously if you change the name of the Table (if indeed it is a
table, not a spreadsheet) and the names of fields, then you must make
the corresponding changes in your queries and your combo box
definitions.

Again: let's go back to square one.

What program are you using? Excel or Access (or both, linked)?
What is the name of your employee table?
What are the relevant fields in your employee table? fieldnames and
datatypes?
What is the Recordsource of your form?
What are the relevant properties of the combo:
Row Source (post the SQL if it's a query)
Control Source
Bound Column
Column Count
Column Widths

And what precisely happens when you select a row from the combo: what
do you see, and what (if anything) gets stored in the table?

John W. Vinson[MVP]
 
--
Like Nike "Just Do It"


John Vinson said:
Wait a minute here. You're saying "spreadsheet" - an Excel construct.
Are you using Excel, or Access???

Obviously if you change the name of the Table (if indeed it is a
table, not a spreadsheet) and the names of fields, then you must make
the corresponding changes in your queries and your combo box
definitions.

Again: let's go back to square one.

What program are you using? Excel or Access (or both, linked)?
What is the name of your employee table?
What are the relevant fields in your employee table? fieldnames and
datatypes?
What is the Recordsource of your form?
What are the relevant properties of the combo:
Row Source (post the SQL if it's a query)
Control Source
Bound Column
Column Count
Column Widths

And what precisely happens when you select a row from the combo: what
do you see, and what (if anything) gets stored in the table?

John W. Vinson[MVP]
Program---Access
Click to expand...
Name---Employee
Field Data
EmployeeNo Text
FirstName Text
LastName Text
EmailName Text
Ext Number
WorkPhone Number
DepartmentID Text
RecordSource??? Think it might be EmployeeNo
Relevant Properties?????
Row Source: SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employee ORDER BY [LastName] & ", " & [FirstName];
Click to expand...
Control Source: EmployeeID
Bound Column:1
Column Count: 2
Column Widths:0";2"
I am trying to create a Purchase Order form that can be filled out with
vendor,product,employee requesting items, etc.....
When I pick vendor(supplier) name it stays selected on my form, but when I
select employee it gives me a drop down list I select employee name but it
does not show up on form. Might delete form and try making it again.
 
Back
Top