I created a form in Access 2007 where some of the fields are "auto filled" from lookup tables. For example, I have a lookup table named "classes taken" which has the columns "class name", "units", and "hours". On the form, entering a "class name" from a drop-down list automatically fills in the units and clock hours in the two text boxes (Units, Clock Hours) that I created. To clarify, the control source for the unit text box is =[Classes Taken].[column](2), and for the clock hours text box is =[Classes Taken].[column](3). Here's the problem: on the form footer, I created text boxes to calculate total units and total clock hours. For example, for total units, =Sum([Classes Taken].[column](2)).However, when I go to the form view, the total unit text box displays "#error". How can I fix this? Is there a way to perform calculations on auto populated fields? Thanks for any assistance that you may be able to provide.
3 1388 NeoPa 32,566
Recognized Expert Moderator MVP
I could be wrong, but I don't believe it is possible to total unbound controls. See Why Values in Unbound Form Controls do not Persist for why.
There may be a way round it, but that would depend on including the data in your Record Source somehow (making the control bound).
NeoPa 32,566
Recognized Expert Moderator MVP
No worries. Sorry we couldn't be more help.
Welcome to Bytes!
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Yan Roosens |
last post by:
Hello all,
I'm a total newbie with SQL Server 2000 and I have a little problem when
moving a database form Access 2000 to SQL Server 2000.
In the Access database, each table has an auto-increment field.
After importing the tables in SQL Server, all the auto-increment fields
are turned into "int" type fields.
Does anybody have an...
|
by: sao |
last post by:
I am currently using Access 2000.
In my table it is the following fields that are set up:
1 - Staff Name
2 - Department
This table is already populated with 100+ records (staff along with
department.)
|
by: peter |
last post by:
I have created a MS Access query where one of the fields displays the
week number. The field is a date value that uses the ww format to
display the week number. However, when I try to create a calculation
such as *2 I get an incorrect value. For example, if the
week number is 11 and I multiply it by 2 I get an answer of 21. How do
I convert...
|
by: gwhite1 |
last post by:
I am using the auto-generate fields option because my query can be
different based on what the user selects. But I would still like to set
the column alignment but I can;t seem to access the columns in code
after the data has loaded. Any ideas?
|
by: zeilak |
last post by:
I am running Windows XP, Access 2002.
I want to know the VB code for the following:
I want to type in the ID # (it's the primary key and is auto-numbering) and then have the access form autopopulate three fields for that ID # record. (The three fields are called pu, am, and qu). Pu should populate with a vaule of 1. Am should populate with...
| |
by: Rotor |
last post by:
Hello,
I have a subform that displays hull# and WO#. I would like for those fields to populate when the user opens up a form that requires them, after clicking on the hull#.
So, I setup the hull# field to open FrmJobAccomplished on click.
Then when FrmJobAccomplished opens, I would like for Hull# and WO# to be populated from subform.
...
|
by: BillE |
last post by:
I am populating a gridview using auto-generated fields, because I need to
enable sorting.
I would like to format a column containing dates in the gridview.
How is this done?
Thanks
Bill
|
by: kkramer |
last post by:
I have a table in Access which is auto populating fields which I do not want to happen. If I list a number in a field, and then another number in the field below it, and then a third number, if those numbers happen to coincidentally follow a pattern (for example, 10322,10324,10326), the fields below are auto populating to follow the same pattern....
|
by: natalie99 |
last post by:
Hello hello
Can anyone please tell me, can you run something similiar to this replace null value code:
FieldNameNZ: nz(,"0")
in a way that it will replace any populated field instead of replacing NULL fields?
the data in the populated fields will always be different, and I was hoping to use 0 or No for null and 1 or Yes for populated
|
by: Iluvatar |
last post by:
Hi,
last week our project upgraded from vs.net 2005 to vs.net 2008. Our
project still uses framework 2.0, because the deployment servers are
not 3.x ready yet. Everything so far while migrating the solution and
project files worked fine.
Today, I tried to add new controls to an existing web form. The markup
doesn't show any errors, but...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |