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/Forums.aspx/access-forms/201001/1

0
Nancy
1/6/2010 7:02:44 PM
access.forms 6864 articles. 2 followers. Follow

3 Replies
728 Views

Similar Articles

[PageSpeed] 3

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/Forums.aspx/access-forms/201001/1
> 


0
Al
1/6/2010 7:34:03 PM
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/Forums.aspx/access-forms/201001/1

0
Nancy
1/6/2010 8:05:55 PM
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/Forums.aspx/access-forms/201001/1
> 


0
Al
1/6/2010 10:45:38 PM
Reply:

Similar Artilces:

Proper Table(s) Layout
I have created a couple of Dbs which the table structure seemed to simply fall into place, it was just logical in my head. That said, I am working on a new db and for some reason I am doubting myself and wanted a second opinion. The db is basically a contract db to input all the info, and there is a lot of info, for each contract. Where I am 'lost' is the fact that the contracts are broken into categories: clients, components,engineering, warantee... For all of the components (with the exception of clients) there are a number of fields but only 1 entry per contract....

Showing 0 after decimal with ROUND
Hi, I'm using the ROUND function like this: =ROUND(C29*(92%),1) &- ROUND(C29*(108%),1) Unfortunately, if the numeral after the decimal is a 0, then it doesn't display. How can I force a 0 to display after the decimal? Libby Format the cell as Number with 1 decimal place - it would appear to be formatted as General. Hope this helps. Pete On Dec 4, 1:44=A0pm, Libby <Li...@discussions.microsoft.com> wrote: > Hi, > > I'm using the ROUND function like this: > > =3DROUND(C29*(92%),1) &- ROUND(C29*(108%),1) > > Unfortuna...

100% stacked column chart shows wrong information
I wonder if someone can help me. I have created a table that tracks the profitability of a particular project and I’m using the table as a source for a 100% Stacked Column graph. The source data for the graph is in three rows: • B21:M21 - contain the names of the months from Nov – Oct • B22:M22 - money taken in • B24:M24 - profit B23:M23 contains the money paid to supplier each month. I need this in the table but I don’t need to show it in the graph. I just want to show profit as a proportion of what we bill to customers on that project. My problem is that the graph seems to show in...

Can't create Organizational Forms Library in Exchange 2003 with SP
Hello, I cannot create an Organizational Form in EFORMS REGISTRY folder (from First Administrative Group->Folders->Public Folders->EFORMS REGISTRY in ESM). When I right-click the EFORMS REGISTRY folder and select New, there is no Organization Form. Instead, I only see Public Folder in the popup menu. Do you have any idea why Organizational Form menu does not show? My Exchange Server is Exchange 2003 with SP2. The login user is Administrator. Could you please help me? Thank you very much. Yang Is that account member of "Enterprise Admins" group? Yang Zhang wrote: &...

publisher. why does webpage preview show only half page
When I'm viewing my webpage design in webpage preview I am getting a large empty space on the right hand side and bottom of the page On Fri, 17 Feb 2006 17:50:02 +0000, yousane wrote (in article <65E39911-B9CA-4785-BD48-358D03F3695A@microsoft.com>): > When I'm viewing my webpage design in webpage preview I am getting a large > empty space on the right hand side and bottom of the page And your problem is...? That's how it's supposed to be. Web pages designed in Publisher do *NOT* fill the entire screen. I suggest you learn to use the right tool for the job (I&...

Pass parameter from FORM to QUERY
I have an append query that I trying to call from a cmd btn...but it prompts me for the parameter(ie QuoteID)... How do I tye it into my call: Dim stQueName As String stQueName = "Quote Query" DoCmd.OpenQuery stQueName, acNormal, acEdit On Apr 13, 12:56 pm, jlt...@hotmail.com wrote: > I have an append query that I trying to call from a cmd btn...but it > prompts me for the parameter(ie QuoteID)... > How do I tye it into my call: > > Dim stQueName As String > stQueName = "Quote Query" > DoCmd.OpenQuery stQueName, acNormal, acEd...

Mail will not Send/Receive automatically
I have outlook set up to send/receive every minute but it suddenly stopped doing so. Anyone have ideas why? Robin Several. For starters, a one minute polling interval is just nuts. It is difficult to determine why automatic polling is failing when you do not post your mail account type, connection type and polling settings. If automatic polling once worked and now fails, you also need to examine what changes were made to your setup before automatic polling stopped working. In general, here are the reasons automatic polling might fail in Outlook: 1. You have created an unrealistic po...

Office 2007 forms
I am creating a form with office 2007, will those people who do not use office 2007 be able to fill in my form? should I save it in a particular format? thanks Provided you start from the normal template, don't use fonts that were introduced with Word 2007, and save the form in Word 97-2003 document format, anyone with Word 97 or later should be able to open it. Use only the legacy form fields, to which end http://gregmaxey.mvps.org/Classic%20Form%20Controls.htm will make things easier. -- <>>< ><<> ><<> <>>< ><<...

Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching forever and havn't found a hint yet. I have multiple domains setup on my exchange server. Lets say abc.com, def.com, and hij.com. We only send email with @abc.com but can receive from any domain name. Recently we merged with another company and we brought back their email to our server, lets say xyz.com. Now I configured a new recipient on Exchange 2003, so I now have two policies. The first policy has the three original domains in it with @abc.com as the primary domain. In the second policy I have configured xyz.com t...

Add rows automatically? Accordion
Is there a way to automatically add/show rows that have data? I have a data entry sheet. Then I have a report. The report pulls data from the entry sheet. If there is no data for a specific line/row item, is there a way to automatically hide or not show the row(s) with no data? Thanks Thanks can I have more than one autofilter on a sheet? Sloth wrote: > Use the filter function > Select the data and click on... > Data->Filter->Autofilter > This should make an arrow appear at the top of the data (in the header row). > click the arror and select "Nonblanks"....

Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data columns. Can the data in the columns of a chart table be right justified? In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf- 8?B?c2FtIGVhZ2xl?= <sam eagle@discussions.microsoft.com> says... > Ecxel 2003 and previous versions of the product center the data in the data > columns. Can the data in the columns of a chart table be right justified? > Have you tried to format the table? If yes, and you haven't been successful it is probably because XL allows very limited cust...

Table link documentation
I am having trouble trying to locate A/P check data that has project related costs. I found the check data but it is does not indicate the projects, I found the project data but can not determine thye logical link between the two tables, I may be using the wrong tables the tables I am using are PM80500 and PA31102. Is there any documentation of how all the tables in the system are logically link. I am trying to write reports in MS Access, but there are 1500+ tables in GP (version 10) -- Dave F In an effort to find the correct table you can do a number of things (believe me I do)....

Data migration - Adventure Works
Hiya... I have a company where the adventure works db has been used and had a lot of data populated into the system. We have now purchased MSCRM and have obtained the company reg keys. What is the easiest way to get the data from the 1 system to the next? We will be establishing a new AD domain and users for the new system.... Data Migration Framework? Redeployment Framework? ;) redeploment tools http://www.microsoft.com/downloads/details.aspx?FamilyID=bfced393-61db-49af-9a50-4a90b311fa7d&DisplayLang=en -- John O'Donnell Microsoft CRM MVP http://www.mscrmfaq.us "funboy...

Duplicate record in RM tables
We experienced an issue in Apply Sales Document that may have caused a duplicate record somewhere. We found this when running Paid Sales Transaction Removal and received this message: Violation of PRIMARY KEY contraint PKRM3101. Cannot insert duplicate key in object RM30101. I ran the RM duplicate tool found in the automated help area of this website and found the following: --- Begin copy here ---- Duplicates between RM Open and RM History Document #: 07-003021-17 Customer #: 079100 RMDTYPAL #: 7 --- End copy --- It looks like the duplicte tool also logs the qu...

How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the current form field. This bit of code is attached to the GotFocus event of all fields and the Enter event of all subforms: gxCurrentField = Me.ActiveControl.Name However it doesn't work properly when changing records in a subform. My parent form contains two subforms in a many-to-many relationship. The above variable usually ends up containing the name of the first field in the second subform when switching records in the first subform. How to correctly code this? Or is there some native variable I'm not aware of? I...

140 MB file went to 5.08 MB after editting 1 table
Hello All - I need some ACCESS insight...please... Several years ago, I built an access db to track my business scheduling and accounts payable/receivable. So this database is EXTREMELY IMPORTANT TO ME. The file has grown to 140 MB. Today I made a copy of the file and then edited my calendar table. I removed all columns which had 2006 data (72 totals columns) - the table had about 144 columns originally. I then added 72 columns with 2008 headers. These columns are now blank since I have not added any 2008 data yet. Afterwards, I looked around and everything looks good - my 2007 data is the...

Updating a chart Automatically
Hi, i update a spreadsheet with new data from Access everyweek. I have a chart that displays the last thrity days, how do i do this automatically, so i dont have to keep updating the chart manually ? Thanks in advance Jay Jay Richardson wrote: > Hi, i update a spreadsheet with new data from Access > everyweek. I have a chart that displays the last thrity > days, how do i do this automatically, so i dont have to > keep updating the chart manually ? > > Thanks in advance Jay See www.tushar-mehta.com, Dynamic Charts. Dave dvt at psu dot edu ...

Label a chart of counts with other percentage data
Here's the data: Group 2005 2006 2007 LTM Data A 19.4% 22.8% 21.2% 19.9% Profitability A 6 7 7 7 Count B 9.5% 31.6% 30.4% 30.7% Profitability B 2 3 3 3 Count C 22.4% 23.6% 16.6% 17.6% Profitability C 15 16 17 18 Count D 19.2% 20.5% 15.9% 13.7% Profitability D 8 8 9 10 Count I have successfully generated a stacked bar chart that shows the counts per group by year. Now I would like to include a label for each group to show profitability for each group in each year in the 4 stacks. How would I do that? Thanks, --...

Creating a chart based on the data in an embedded worksheet
Hi, I have a worksheet with several embedded worksheets. I would like to create a chart based on the data of one of the embedded worksheets without putting the chart in the embedded worksheet. I have tried unsuccessfully to do this. I just wondered if anyone knew how to do it. Thanks, JK JK - You're embedding worksheets within worksheets? Why? Why not just insert the worksheets in line with the main worksheet? To open or edit the embedded worksheet, the parent Excel has to open another instance of Excel, and the chart on the outside of this other instance will never be able to acce...

Automatic changes in cells
Hi for some reason I now have to save my work for any formlas etc to change when I update a worsheet, how can I stop this as it is a pain and sometimes I need to do changes to see how they work before saving the work. Many thanks Click on Tools | Options | Calculation tab and set to Automatic calculation, as it is probably set to Manual. You can press F9 to force a recalculation under a manual setting. Make sure you save the file with the Automatic setting, to avoid it happening next time. Hope this helps. Pete On Feb 1, 11:42=A0am, Office 2004 Test Drive User <heepenm...@yahoo.co.u...

cursor missing from form textboxes
I believe that I know 98% of the little intricacies of Publisher, but I'm stumped on this one. I created a website with a contact page and none of the standard textboxes will show a cursor to indicate with field you are in (I've even made the site live to double check). If you tab between textboxes, the tabbing works, as does typing, there is just no visual cursor to indicate where you are. If you click on the first textbox and type, all is good you can tab to the next box and type, and it's fine. I'd like to have the visual cursor show and can't get it. I also have ...

Pivot Table Defaults
In the pivot table field list, whenever I create a new pivot table and I am inserting fields into the value area, I generally get as default field setting the 'Count' value. Is there a way to format the spreadsheet to make Excel recognize the data as all numbers so it defaults to the "Sum" function as opposed to "text"? Hi The rule that the PT Wizard adopts is, If all the values in the field being added to the data area are Numeric, then it uses Sum. If any of the values are Text or BLANK, then it uses Count. It sounds as though you have defin...

Like a pivot table
Hello every body I'm first time requesting in this group, so I opologize in advance for any mistakes or something annoying I repeat what I have sent before 10 min because I see it unclear when it goes to news group If any one can help me I'm working with data which most of it comes like a table with feilds as columns and records as rows. I want it to be as many rows with each feild an example what is exist name age Joining Date Tele John 20 Jun-90 4321251 Iqbal 30 Jul-95 6583752 George 40 Sep-85 7843125 What I wa...

how to automatically update inventory list with sales
Please provide the help on how to update the inventory list when some items are sold. Do you want to check this out while you wait for an answer? http://office.microsoft.com/en-us/FX011429711033.aspx Epinn "lalani" <lalani@discussions.microsoft.com> wrote in message news:07A10BC7-97FB-4E93-A686-CAAE3AA2DE88@microsoft.com... > Please provide the help on how to update the inventory list when some items are > sold. The page that Epinn points out is probably as good as any. Excel is a rather poor tool for trying to track inventory. You'll notice that the actual...

VBA form
Im using a form/macro that i linked to through another thread and a tailoring it to my needs. I basically have it doing what i need but cant get a button to do what i want. When the user starts the macro i brings up the form with a message and 2 buttons (Continue/Cancel). Whe continue is pressed i want the message on the form to change to aniothe message and so on until all messages are shown. Ive attacehed what i working on and apprecaite any help offered. Thank yo +------------------------------------------------------------------- |Filename: Excel.zip ...