Hi all!
Is there anyway I can override a value in a calculated field on a
form? For example:
I have a form which displays the following fields based on a query:
Premium Due field has the value of 12,527.75 in it.
Brokerage Due field is the calculated field which multiplies a factor
of 0.10 (10%) with the value in the Premium field. In this case, the
value in this field will automatically calculate to 1,252.775. I want
to be able to have the ability to be able to change the value in this
field to 1,253.00 or 1,252.78. The reason I want to be able to do so
is for accounting purposes. The Brokerage Due is often different from
what is actually paid due to rounding error. Therefore, I need to be
able to edit this to reflect actual payments.
Thanks for your help in advance... 9 7814
I assume that brokerage due is calculated in the after update event of the
Premium Due control. If the Brokerage due control is not locked you should
be able to edit it - No?
"Haas C" <ha*****@yahoo. comwrote in message
news:11******** *************@a 75g2000cwd.goog legroups.com...
Hi all!
Is there anyway I can override a value in a calculated field on a
form? For example:
I have a form which displays the following fields based on a query:
Premium Due field has the value of 12,527.75 in it.
Brokerage Due field is the calculated field which multiplies a factor
of 0.10 (10%) with the value in the Premium field. In this case, the
value in this field will automatically calculate to 1,252.775. I want
to be able to have the ability to be able to change the value in this
field to 1,253.00 or 1,252.78. The reason I want to be able to do so
is for accounting purposes. The Brokerage Due is often different from
what is actually paid due to rounding error. Therefore, I need to be
able to edit this to reflect actual payments.
Thanks for your help in advance...
Kevin,
The form is based on a Query in which the Brokerge due is calculated
within the uery. In other words, there is no After Update event. Any
suggestions?
Thanks!
On Feb 12, 7:42 pm, "Kc-Mass" <connearney_AT_ comcast_PERIOD_ net>
wrote:
I assume that brokerage due is calculated in the after update event of the
Premium Due control. If the Brokerage due control is not locked you should
be able to edit it - No?
"Haas C" <haas...@yahoo. comwrote in message
news:11******** *************@a 75g2000cwd.goog legroups.com...
Hi all!
Is there anyway I can override a value in a calculated field on a
form? For example:
I have a form which displays the following fields based on a query:
Premium Due field has the value of 12,527.75 in it.
Brokerage Due field is the calculated field which multiplies a factor
of 0.10 (10%) with the value in the Premium field. In this case, the
value in this field will automatically calculate to 1,252.775. I want
to be able to have the ability to be able to change the value in this
field to 1,253.00 or 1,252.78. The reason I want to be able to do so
is for accounting purposes. The Brokerage Due is often different from
what is actually paid due to rounding error. Therefore, I need to be
able to edit this to reflect actual payments.
Thanks for your help in advance...- Hide quoted text -
- Show quoted text -
Haas C wrote:
Hi all!
Is there anyway I can override a value in a calculated field on a
form? For example:
I have a form which displays the following fields based on a query:
Premium Due field has the value of 12,527.75 in it.
Brokerage Due field is the calculated field which multiplies a factor
of 0.10 (10%) with the value in the Premium field. In this case, the
value in this field will automatically calculate to 1,252.775. I want
to be able to have the ability to be able to change the value in this
field to 1,253.00 or 1,252.78. The reason I want to be able to do so
is for accounting purposes. The Brokerage Due is often different from
what is actually paid due to rounding error. Therefore, I need to be
able to edit this to reflect actual payments.
Thanks for your help in advance...
I might have two columns in the query;CF (calced field) and IF (input
field). When I open the form, the default value of IF would be CF.
Drop for IF and CF on the form. Make CF visible = False.
Salad,
Thanks for the suggestion but i rather have one field. There's got to
be an easier way to do this. Thanks!
On Feb 13, 9:48 am, salad <o...@vinegar.c omwrote:
Haas C wrote:
Hi all!
Is there anyway I can override a value in a calculated field on a
form? For example:
I have a form which displays the following fields based on a query:
Premium Due field has the value of 12,527.75 in it.
Brokerage Due field is the calculated field which multiplies a factor
of 0.10 (10%) with the value in the Premium field. In this case, the
value in this field will automatically calculate to 1,252.775. I want
to be able to have the ability to be able to change the value in this
field to 1,253.00 or 1,252.78. The reason I want to be able to do so
is for accounting purposes. The Brokerage Due is often different from
what is actually paid due to rounding error. Therefore, I need to be
able to edit this to reflect actual payments.
Thanks for your help in advance...
I might have two columns in the query;CF (calced field) and IF (input
field). When I open the form, the default value of IF would be CF.
Drop for IF and CF on the form. Make CF visible = False.- Hide quoted text -
- Show quoted text -
Eliminating the need for an override. Create a rounding function and use it
in your query.
dblRoundBrokera geDue([Premium Due] * 0.10)
"Haas C" <ha*****@yahoo. comwrote in message
news:11******** *************@a 75g2000cwd.goog legroups.com...
Hi all!
Is there anyway I can override a value in a calculated field on a
form? For example:
I have a form which displays the following fields based on a query:
Premium Due field has the value of 12,527.75 in it.
Brokerage Due field is the calculated field which multiplies a factor
of 0.10 (10%) with the value in the Premium field. In this case, the
value in this field will automatically calculate to 1,252.775. I want
to be able to have the ability to be able to change the value in this
field to 1,253.00 or 1,252.78. The reason I want to be able to do so
is for accounting purposes. The Brokerage Due is often different from
what is actually paid due to rounding error. Therefore, I need to be
able to edit this to reflect actual payments.
Thanks for your help in advance...
Haas C wrote:
Salad,
Thanks for the suggestion but i rather have one field. There's got to
be an easier way to do this. Thanks!
You don't update calculated fields manually.
Since you are looking for a method to update the field but don't want to
mess with the calculated field's result perhaps you can modify the
Premium Due field so that it forces a correct calculation. IOW, make
the PremiumDue the calcuated field.
For example, plug in a value for where the calced field is. Then it
gives you the Premium Due result. It won't be what you want, but it
matches your calculation.
Good luck in your quest.
>
On Feb 13, 9:48 am, salad <o...@vinegar.c omwrote:
>>Haas C wrote:
>>>Hi all!
>>>Is there anyway I can override a value in a calculated field on a form? For example:
>>>I have a form which displays the following fields based on a query:
>>>Premium Due field has the value of 12,527.75 in it.
>>>Brokerage Due field is the calculated field which multiplies a factor of 0.10 (10%) with the value in the Premium field. In this case, the value in this field will automatically calculate to 1,252.775. I want to be able to have the ability to be able to change the value in this field to 1,253.00 or 1,252.78. The reason I want to be able to do so is for accounting purposes. The Brokerage Due is often different from what is actually paid due to rounding error. Therefore, I need to be able to edit this to reflect actual payments.
>>>Thanks for your help in advance...
I might have two columns in the query;CF (calced field) and IF (input field). When I open the form, the default value of IF would be CF.
Drop for IF and CF on the form. Make CF visible = False.- Hide quoted text -
- Show quoted text -
Ron,
Thanks for the suggestion but I realy need to override this. Thanks
again.
On Feb 13, 11:09 am, "paii, Ron" <p...@packairin c.comwrote:
Eliminating the need for an override. Create a rounding function and use it
in your query.
dblRoundBrokera geDue([Premium Due] * 0.10)
"Haas C" <haas...@yahoo. comwrote in message
news:11******** *************@a 75g2000cwd.goog legroups.com...
Hi all!
Is there anyway I can override a value in a calculated field on a
form? For example:
I have a form which displays the following fields based on a query:
Premium Due field has the value of 12,527.75 in it.
Brokerage Due field is the calculated field which multiplies a factor
of 0.10 (10%) with the value in the Premium field. In this case, the
value in this field will automatically calculate to 1,252.775. I want
to be able to have the ability to be able to change the value in this
field to 1,253.00 or 1,252.78. The reason I want to be able to do so
is for accounting purposes. The Brokerage Due is often different from
what is actually paid due to rounding error. Therefore, I need to be
able to edit this to reflect actual payments.
Thanks for your help in advance...- Hide quoted text -
- Show quoted text -
Adding an actual paid field would solve you problem and provide useful
payment information without a override of the calculated value.
"Haas C" <ha*****@yahoo. comwrote in message
news:11******** **************@ m58g2000cwm.goo glegroups.com.. .
Ron,
Thanks for the suggestion but I realy need to override this. Thanks
again.
On Feb 13, 11:09 am, "paii, Ron" <p...@packairin c.comwrote:
Eliminating the need for an override. Create a rounding function and use
it
in your query.
dblRoundBrokera geDue([Premium Due] * 0.10)
"Haas C" <haas...@yahoo. comwrote in message
news:11******** *************@a 75g2000cwd.goog legroups.com...
Hi all!
Is there anyway I can override a value in a calculated field on a
form? For example:
I have a form which displays the following fields based on a query:
Premium Due field has the value of 12,527.75 in it.
Brokerage Due field is the calculated field which multiplies a factor
of 0.10 (10%) with the value in the Premium field. In this case, the
value in this field will automatically calculate to 1,252.775. I want
to be able to have the ability to be able to change the value in this
field to 1,253.00 or 1,252.78. The reason I want to be able to do so
is for accounting purposes. The Brokerage Due is often different from
what is actually paid due to rounding error. Therefore, I need to be
able to edit this to reflect actual payments.
Thanks for your help in advance...- Hide quoted text -
- Show quoted text -
Haas C wrote:
Ron,
Thanks for the suggestion but I realy need to override this. Thanks
again.
What you "want" cannot be done. A field in a query and thus a control on a
form is either bound to a calculation (not editable) or to a field in a
table (editable). One control and/or query field cannot do both at the same
time.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Anonymous |
last post by:
Hi all,
I have a form people use to enter checking data. One of the fields is
calculated based on finding the difference of two input fields on the form.
Here are the fields:
CheckAmount
AmountApplied
Funds Remaining
|
by: Miguelito Bain |
last post by:
hi everybody.
i'm trying to find out what you can and can't do with/in calculated
fields. any help, pointers, and/or advice would be greatly
appreciated. i'm a newbie, but i want to learn, and i've tried a lot
before posting.
here's my situation.
i have a simple form with dates on it. i have an indate and outdate
|
by: douh |
last post by:
I know that this is not the way, however I need to save certian
calculated values so that they do not change over time, ie. new tax
rates etc. This is for an invoice header and invoice subform. I have a
form myheader and mysub that are linked via a invoice number. mysub
calculates qty * list = extprice. I am summing these into a sum_ext
field in mysub footer. I need to have this value updated into the
myheader invsubtot. I have tried many...
|
by: Norbert Lieckfeldt |
last post by:
MS Access 2002 here. I am just trying to set up a simple database for a
friend who's an optician. Basically, all clients with address details, date
of last eyetest and a drop-down combo box to choose a number of months to
the next eyetest (3,6,12,24). I then have a calculated field in the form
which works out the date of the next appointment on the basis of the
previous two sets of information .
All that works . I am now trying
to set...
|
by: david |
last post by:
Hi,
I have a form with a couple of calculated fields.
I want to put some code into the 'Form-Load' event to set various
object states on the form, depending on the value of these fields.
The problem is that the calculated fields are blank for a split second
when the form opens, and then the value appears. This makes any tests
fail. How can I test against these fields once the calculation has been
done ?
| |
by: tconway |
last post by:
I have an Access program that displays Customer data into a form and
OrderID data into a subform. The totals in the Subform are based on
calculated fields, i.e. the Total Amount field Calculates the
following: =*
The Subform Order fields are pulled from a Query along with each
calculated Total. They are displyed in a DataSheet View.
This works fine on my developement environment which includes a server
set up just as our client has. ...
|
by: markm75c |
last post by:
Does anyone know of a way to sort a column which isnt databound or an
actual field in the database, but is derived from a method?
IE. I have a grid showing stats for softball, with a calculated field
called AVG, I want to be able to sort based on AVG when they click on
AVG.
I can't seem to find a way to do this out there.
Thanks!
|
by: kelley.l.turner |
last post by:
Hi all,
I am very new to MS Access so please bear with me! I have created a
simple calculated field in my data entry form, yet when I view my data
table or try to generate a report based on this calculated field, no
value is posted. How/where do I get my calculated values to also show
up in the tables and reports?
Thanks,
Kelley
|
by: jcf378 |
last post by:
hi all.
I have a form which contains a calculated control ("days") that outputs the # of days between two dates (DateDiff command between the fields and ).
However, when I click "Filter by Form" in order to search for records based on this form, I would like to be able to enter a value in this "days" control so that I can filter records on the form based on this calculated interval (i.e., i want to search for records specifically where...
|
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...
|
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,...
| |
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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...
|
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...
|
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();...
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |