Calculation on a form and a report - Microsoft Access / VBA

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

Subscribe Reply

3908

PC Datasheet

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

Similar topics

3602

Workdate calculation Access 2000

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...

Microsoft Access / VBA

2441

Form Calculation

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:

Microsoft Access / VBA

2119

calculation in forms

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

Microsoft Access / VBA

1813

Getting the results of a report calculation or data field

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

Microsoft Access / VBA

3276

Providing feedback during heavy calculation

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...

C# / C Sharp

5293

Multiple Vehicle Mileage Calculation

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: :

Microsoft Access / VBA

3759

form sum calculation error

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:*....

Microsoft Access / VBA

2198

Query Returning Multiple Results of Same Record Also Calculation Errors (Sometimes)

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...

Microsoft Access / VBA

2690

Calculation field in Form and Report display #Num

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

Microsoft Access / VBA

8840

What is ONU?

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...

General

8730

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9064

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5981

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4484

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

4753

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3189

transfer the data from one system to another through ip address

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

C# / C Sharp

2576

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2130

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General