 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / August 2006Blank Entry
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.  SignatureLike Nike "Just Do It" >Hello Newbie Here >Biting off more than I can chew, but anyway. Trying to create database for [quoted text clipped - 6 lines] >Thank you. >B. 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] SignatureLike Nike "Just Do It" > >Hello Newbie Here > >Biting off more than I can chew, but anyway. Trying to create database for [quoted text clipped - 19 lines] > > John W. Vinson[MVP] 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]; ) Control Source is (EmployeeID) Bound Column is (1) Colume Count is (2) Column Width is (0") 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]; ) >Control Source is (EmployeeID) Bound Column is (1) Colume Count is (2) >Column Width is (0") 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. SignatureLike Nike "Just Do It" > >John, > >Below is what I have found, not sure if that is the right thing. [quoted text clipped - 8 lines] > > 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. 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] SignatureLike Nike "Just Do It" > >John > >Tried changing column width, but did not change. I changed the name of the [quoted text clipped - 30 lines] > John W. Vinson[MVP] > Program---Access 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]; 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. SignatureLike Nike "Just Do It" > >John, > >Below is what I have found, not sure if that is the right thing. [quoted text clipped - 8 lines] > > 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. > Hello Newbie Here > Biting off more than I can chew, but anyway. Trying to create database for [quoted text clipped - 10 lines] > 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. SignatureLike Nike "Just Do It" > 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 [quoted text clipped - 18 lines] > > Thank you. > > B. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.