473,748 Members | 2,255 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Calculation on a form and a report

Del
Thanks in advance for any help.

I have a database that was created in Access 2000. Several users have
been upgraded to Access 2003. Since upgrading to 2003 we have noticed
that some of the calculated fields are not being populated. The
database is a samll invoicing database on the form and report we have
columns call Unit Cost. This is the actual cost of the part and is
pulled from our parts master table and is displayed in a sub form and
subreport, linked to the master form and report by Part Number. On the
form and report we have a column call Quantity which is the number of
the parts ordered by the customer. We then have a calculated column
called Extended Cost. The Extended Cost has the following
calculation...

=([Quantitly1] * [frmPartDetailSu bfrm1]![Unit Cost])

This calculation has worked fine from the time the database was
created several years ago, until now. When the database is run on a
machine with Access 2003 this calculation doesn't work. However the
machines that have Access 2000, or XP the calculation works fine.

Any ideas????

Thanks again.
Del
Nov 13 '05 #1
2 3913
In your extended cost calculation, Quantity is misspelled. Is
frmPartDetailSu bfrm1 the subform control on the main form and not the name
of the subform? frmPartDetailSu bfrm1should be referred to from the Forms
collection like this:
Forms!frmPartDe tailSubfrm1

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"Del" <dt****@yahoo.c om> wrote in message
news:c2******** *************** **@posting.goog le.com...
Thanks in advance for any help.

I have a database that was created in Access 2000. Several users have
been upgraded to Access 2003. Since upgrading to 2003 we have noticed
that some of the calculated fields are not being populated. The
database is a samll invoicing database on the form and report we have
columns call Unit Cost. This is the actual cost of the part and is
pulled from our parts master table and is displayed in a sub form and
subreport, linked to the master form and report by Part Number. On the
form and report we have a column call Quantity which is the number of
the parts ordered by the customer. We then have a calculated column
called Extended Cost. The Extended Cost has the following
calculation...

=([Quantitly1] * [frmPartDetailSu bfrm1]![Unit Cost])

This calculation has worked fine from the time the database was
created several years ago, until now. When the database is run on a
machine with Access 2003 this calculation doesn't work. However the
machines that have Access 2000, or XP the calculation works fine.

Any ideas????

Thanks again.
Del

Nov 13 '05 #2
Del
Sorry for the misspelling. As for the frmPartDetailSu bfrm1, that is
the name of a subform that is on the main form. The subform has the
Part Description, Unit Cost, and a couple other columns of data
related to the specific part number. The subform is linked to the Main
Form via the Part Number. The Subform is populated when a part number
is entered in the main form.
Like I said in the original post this calculation has worked for a
number of years. Nothing has changed in the database. The only that
has changed is some of the users have been upgraded to Access 2003.
Users that have either Access 2000. or Access XP have no trouble at
all with this calculation function.

Thanks,
Del

"PC Datasheet" <no****@nospam. spam> wrote in message news:<YB******* ***********@new sread3.news.atl .earthlink.net> ...
In your extended cost calculation, Quantity is misspelled. Is
frmPartDetailSu bfrm1 the subform control on the main form and not the name
of the subform? frmPartDetailSu bfrm1should be referred to from the Forms
collection like this:
Forms!frmPartDe tailSubfrm1

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"Del" <dt****@yahoo.c om> wrote in message
news:c2******** *************** **@posting.goog le.com...
Thanks in advance for any help.

I have a database that was created in Access 2000. Several users have
been upgraded to Access 2003. Since upgrading to 2003 we have noticed
that some of the calculated fields are not being populated. The
database is a samll invoicing database on the form and report we have
columns call Unit Cost. This is the actual cost of the part and is
pulled from our parts master table and is displayed in a sub form and
subreport, linked to the master form and report by Part Number. On the
form and report we have a column call Quantity which is the number of
the parts ordered by the customer. We then have a calculated column
called Extended Cost. The Extended Cost has the following
calculation...

=([Quantitly1] * [frmPartDetailSu bfrm1]![Unit Cost])

This calculation has worked fine from the time the database was
created several years ago, until now. When the database is run on a
machine with Access 2003 this calculation doesn't work. However the
machines that have Access 2000, or XP the calculation works fine.

Any ideas????

Thanks again.
Del

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
3608
by: Pres | last post by:
I am not an experienced programmer. I do have a question regarding workday calculations. I have 3 fields. CURDATE, NUMDAYS, CALCDATE After entering the first two fields, normally the current date and for example 10 (10 day period) I need the CALCDATE to pass me the calculated date taking into account workdays and holidays. In other words, the 10th business day. How is this done? Thanks for any help...
2
2455
by: DebbieG | last post by:
I have no idea how to start with this one. I have a subform where records could look similar to: Infraction Date Points 01/01/2000 3 06/01/2002 1 Somehow, I've got to calculate the points the driver has as of the current date. For instance, in the above example:
4
2121
by: lifang85 | last post by:
hi I have a large DB and the user will enter the values in the fields (1st form) and at the end of the day, there is another form (2nd) will get and compute all the values, calculate the diff fields to get the total. e.g: Location 4 --> school 2 --> home 5 --> others
5
1814
by: Greg Teets | last post by:
I am running an Access report from VB via ADO. The report has a field that shows the date it was run. How can I return the data from this field to VB or have Access post it to a table when the report runs? Thank you. Greg Teets
4
3277
by: Michiel Alsters | last post by:
Hello everybody, I hope anybody can help me. I'll try to give a brief overview of my problem. I have running a program that performs a heavy calculation. To give the user feedback what the program is doing I show a window which contains a progress bar and a label. At some point during the execution the state of the calculation is changed, so I want to let the user know this. I have placed the creation of the form in a seperate thread...
6
5295
by: jimfortune | last post by:
In: http://groups.google.com/group/comp.databases.ms-access/msg/60d7faa790c65db1 james.ea...@gmail.com said: :Ok, I've answered the first half of my own question. From a MSDN :article, I can now use the following to reference the last primary :key's values: :
4
3759
by: vg-mail | last post by:
Hello all, I have identical design for form and report but I am getting calculation error on form and everything is OK on report. The form and report are build up on SQL statement. The calculation is very simple. The calculation is done in an underling query if I can call it a query or I should call it a SQL statement. It looks like a query but it is not saved as the query. The calculation in that query is very simple - ExtendedPrice:*....
10
2199
klarae99
by: klarae99 | last post by:
I am working on an Inventory Database in Access 2003. I am having trouble with a report I designed to show current inventory in stock. I have a form (frmInventory) that is unbound. There are four combo boxes on this form that allow the user to select Location, Vendor, Category and SubCategory. These selections (or blank fields) are then passed on to a query (see SQL below) and a report opens to show the inventory. This worked really well...
11
2694
by: Xaysana12345 | last post by:
Hi there, I am having problem with form and report calculation fields showing #Num. ex. fieldA/fieldB if either fieldA or B=null, in the result field obtains #Num. How can I figure out? If either fieldA or B=0 (Null) in the result field = none (Blank) field
0
8980
marktang
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9523
Oralloy
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9307
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8235
agi2029
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6070
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4591
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4862
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3297
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
2
2773
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.