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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Why isn't data that is automatically generated in my form showing up in table?
Ok, I've been messing with this problem all day (for those of you who have
been following me, I'm so sorry!). But I think I finally figured out the root of my problem. I have created a form that allows users to enter in an employee's clock number using a combo box and it automatically generates the employee's name in a text box next to it by pulling information from the Employee Data table. This data shows up fine in the form view and the datasheet view. However, when I open the table up that this data is being saved to (Weekly Data), the data that has been automatically generated is not showing up. What could be causing this and what can I do to remedy it? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 |
#2
|
|||
|
|||
Why isn't data that is automatically generated in my form showing up in table?
Nancy,
I take it that the table does show the entered ClockNo, but not the EmployeeName? If so, that 's correct. As a general rule...don't save a value in a record that can be derived from other value/s on that same record. Since you have captured the ClockNo, you only need to "display" the EmployeeName on your form. Given that you capture the key unique ClockNo, you can always re-derive the EmployeeName, through it's relationship to ClockNo, in any subsequent query or report. It may not be in the table, but in a query, you could join the name back up to the ClockNo. Ex. combo name = cboClockNo A common method is to make the combo 2 columns... with ClockNo and EmployeeName. (Ex. combo name = cboClockNo) An unbound calculated text control, with a Countrol Source of... = cboClockNo.Column(1) will always "display" the correct name whenever a ClockNo is selected. (Combo columns are numbered 0, 1, 2, etc... so the second column is Column(1)) On my website (below) I have a 97 and 2003 sample file called... Combo Populates Multiple Controls, which demonstartes the above. -- hth Al Campagna Microsoft Access MVP 2006-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Nancy via AccessMonster.com" u57097@uwe wrote in message news:a1b7d09d0786a@uwe... Ok, I've been messing with this problem all day (for those of you who have been following me, I'm so sorry!). But I think I finally figured out the root of my problem. I have created a form that allows users to enter in an employee's clock number using a combo box and it automatically generates the employee's name in a text box next to it by pulling information from the Employee Data table. This data shows up fine in the form view and the datasheet view. However, when I open the table up that this data is being saved to (Weekly Data), the data that has been automatically generated is not showing up. What could be causing this and what can I do to remedy it? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 |
#3
|
|||
|
|||
Why isn't data that is automatically generated in my form showing up in table?
Thanks for the response! I actually am using = cboClockNo.Column(1) as the
control source for my Employee Name box to look up the employee name when the clock # has been selected. And it works perfectly. I am using this form so that supervisors can do quick data entry so having the clock number generate the employee name is a must. The problem comes in when I need to print out all of that data in a report. You were right in saying that the table shows the entered clock # but not the employee name. I am actually needing the report to show the employee name and if it shows the clock # as well that would be fine but it doesn't have to be there. What do I need to do to either make the Employee Name show up in the table or set up a query to run this report? I've tried making a query out of the two tables that make this form up (the Employee Data table that supplies the form with data to pull from and the Weekly Data table that the form actually saves data to). However, it just returns a blank report. Any extra help you can provide on this would be greatly appreciated. Thanks in advance! Al Campagna wrote: Nancy, I take it that the table does show the entered ClockNo, but not the EmployeeName? If so, that 's correct. As a general rule...don't save a value in a record that can be derived from other value/s on that same record. Since you have captured the ClockNo, you only need to "display" the EmployeeName on your form. Given that you capture the key unique ClockNo, you can always re-derive the EmployeeName, through it's relationship to ClockNo, in any subsequent query or report. It may not be in the table, but in a query, you could join the name back up to the ClockNo. Ex. combo name = cboClockNo A common method is to make the combo 2 columns... with ClockNo and EmployeeName. (Ex. combo name = cboClockNo) An unbound calculated text control, with a Countrol Source of... = cboClockNo.Column(1) will always "display" the correct name whenever a ClockNo is selected. (Combo columns are numbered 0, 1, 2, etc... so the second column is Column(1)) On my website (below) I have a 97 and 2003 sample file called... Combo Populates Multiple Controls, which demonstartes the above. Ok, I've been messing with this problem all day (for those of you who have been following me, I'm so sorry!). But I think I finally figured out the [quoted text clipped - 8 lines] not showing up. What could be causing this and what can I do to remedy it? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 |
#4
|
|||
|
|||
Why isn't data that is automatically generated in my form showing up in table?
Nancy,
Please don't delete important info from previous posts. Just let the thread grow, so responders can se the whole flow of the problem. It's very rare that reports use a table/s as the RecordSource. Usually it's a query. In this case, using the query design grid... Bring in the Weekly table. Bring in the Employee table Create/drag a relationship between WeeklyData ClockNo and Employee ClockNo. "Show all in Weekly, and only those in Employee that matches." Drag ClockNo and EmployeeName to the grid. Run the query from design mode, and when it returns the correct data, place those fields on your report. -- hth Al Campagna Microsoft Access MVP 2006-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Nancy via AccessMonster.com" u57097@uwe wrote in message news:a1b85dcff0682@uwe... Thanks for the response! I actually am using = cboClockNo.Column(1) as the control source for my Employee Name box to look up the employee name when the clock # has been selected. And it works perfectly. I am using this form so that supervisors can do quick data entry so having the clock number generate the employee name is a must. The problem comes in when I need to print out all of that data in a report. You were right in saying that the table shows the entered clock # but not the employee name. I am actually needing the report to show the employee name and if it shows the clock # as well that would be fine but it doesn't have to be there. What do I need to do to either make the Employee Name show up in the table or set up a query to run this report? I've tried making a query out of the two tables that make this form up (the Employee Data table that supplies the form with data to pull from and the Weekly Data table that the form actually saves data to). However, it just returns a blank report. Any extra help you can provide on this would be greatly appreciated. Thanks in advance! Al Campagna wrote: Nancy, I take it that the table does show the entered ClockNo, but not the EmployeeName? If so, that 's correct. As a general rule...don't save a value in a record that can be derived from other value/s on that same record. Since you have captured the ClockNo, you only need to "display" the EmployeeName on your form. Given that you capture the key unique ClockNo, you can always re-derive the EmployeeName, through it's relationship to ClockNo, in any subsequent query or report. It may not be in the table, but in a query, you could join the name back up to the ClockNo. Ex. combo name = cboClockNo A common method is to make the combo 2 columns... with ClockNo and EmployeeName. (Ex. combo name = cboClockNo) An unbound calculated text control, with a Countrol Source of... = cboClockNo.Column(1) will always "display" the correct name whenever a ClockNo is selected. (Combo columns are numbered 0, 1, 2, etc... so the second column is Column(1)) On my website (below) I have a 97 and 2003 sample file called... Combo Populates Multiple Controls, which demonstartes the above. Ok, I've been messing with this problem all day (for those of you who have been following me, I'm so sorry!). But I think I finally figured out the [quoted text clipped - 8 lines] not showing up. What could be causing this and what can I do to remedy it? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 |
Thread Tools | |
Display Modes | |
|
|