473,325 Members | 2,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Continous Form

DS
I have a continous form that records payments. I' starting out with a
bill of lets say $10.00. What I want to happen is that when I apply a
payment a new record is made. In that new record I want the remaining
amount left from the $10.00 to appear in the new record. Lets say I
apply $6.00, I want a new record with $4.00 in it How would I pick up
the value remaining and apply it to the new record.
Thanks
DS
Nov 13 '05 #1
6 1629
I would suggest that generally it is a bad policy to store calculated values

Have your original Bill (Invoice) of $10, with an InvoiceID.
You then have a table or payments with PayID, InvoiceID, AmountPaid & Date.
Use a Query to add up the payments for a given InvoiceID, subtract the total
from the original invoice amount, and that is what is still owing.

If you do it your way and mispost a payment, then after correcting it you
will have to adjust the outstanding amount. If you get it wrong on the first
payment, you will have to adjust all subsequent records.
HTH

Phil
"DS" <bo******@optonline.net> wrote in message
news:HP****************@fe08.lga...
I have a continous form that records payments. I' starting out with a bill
of lets say $10.00. What I want to happen is that when I apply a payment a
new record is made. In that new record I want the remaining amount left
from the $10.00 to appear in the new record. Lets say I apply $6.00, I
want a new record with $4.00 in it How would I pick up the value remaining
and apply it to the new record.
Thanks
DS

Nov 13 '05 #2
DS
Phil Stanton wrote:
I would suggest that generally it is a bad policy to store calculated values

Have your original Bill (Invoice) of $10, with an InvoiceID.
You then have a table or payments with PayID, InvoiceID, AmountPaid & Date.
Use a Query to add up the payments for a given InvoiceID, subtract the total
from the original invoice amount, and that is what is still owing.

If you do it your way and mispost a payment, then after correcting it you
will have to adjust the outstanding amount. If you get it wrong on the first
payment, you will have to adjust all subsequent records.
HTH

Phil
"DS" <bo******@optonline.net> wrote in message
news:HP****************@fe08.lga...
I have a continous form that records payments. I' starting out with a bill
of lets say $10.00. What I want to happen is that when I apply a payment a
new record is made. In that new record I want the remaining amount left

from the $10.00 to appear in the new record. Lets say I apply $6.00, I

want a new record with $4.00 in it How would I pick up the value remaining
and apply it to the new record.
Thanks
DS


I agree about storing calculated values. The only problem is that the
invoice total is also calculated. I have tis amount hanging around so
to speak on a unbound field on the form. How do I get the form to make
a new record with this adjusted total? People will be entering various
amounts to each payment record so I want the new record to reflect the
balance so to speak in the paymount amount field. Any examples of this
out there? Thanks
DS
Nov 13 '05 #3

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:41***********************@mercury.nildram.net ...
I would suggest that generally it is a bad policy to store calculated
values

Snip
Why is it generally bad policy?
Stacey
Nov 13 '05 #4
"Zabina" <za**********@yahoo.com.au> wrote in message
news:31*************@individual.net...

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:41***********************@mercury.nildram.net ...
I would suggest that generally it is a bad policy to store calculated values

Snip
Why is it generally bad policy?


It's unnecessary and if the data that supplied the input values for the
calculation ever change then the (saved) calculation is now incorrect.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #5

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:31*************@individual.net...
"Zabina" <za**********@yahoo.com.au> wrote in message
news:31*************@individual.net...

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:41***********************@mercury.nildram.net ...
I would suggest that generally it is a bad policy to store calculated
values
Snip
Why is it generally bad policy?


It's unnecessary and if the data that supplied the input values for the
calculation ever change then the (saved) calculation is now incorrect.


Sorry about the prev name posted, forgot to change it after my sister using
the PC..

I have created databases for work - for payroll, invoicing etc all with
calculations, forms created from queries. I am completely self taught in
Access so I am having trouble understanding your lingo..

Only problem I had with my databases is when rates change - meaning I'd have
to either copy the database and start from scratch again or create a new
table of rates and alter the queries. Is this bad policy? I find it a
small price to pay for the advantages in Access with high volume data entry
and reporting.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #6
I assume the invoice total is calculated as the sum of a number of
individual items (or price * quantity) and a percentage added somewhere
along the line for tax That tax rate should be held with the invoice in case
the government raise it, or lower it!! Who said newsgroups are all serious).

So the total invoice can always be recalculated and the balance can be
recalculated.

Suggest you have a form with the main invoice details such as Name address,
invoice no, date VAT (Tax) rate, etc
A sub form InvoiceLines which has all the individual items purchased:- price
quantity and unbound field of price * quantity and total on the form footer
A second subform Payments:- amount, date, and total on the form footer
Then the main form can show the balance as difference between the total on
the InvoiceLines Subform and the Payments Subform

Phil

"DS" <bo******@optonline.net> wrote in message
news:o8*****************@fe08.lga...
Phil Stanton wrote:
I would suggest that generally it is a bad policy to store calculated
values

Have your original Bill (Invoice) of $10, with an InvoiceID.
You then have a table or payments with PayID, InvoiceID, AmountPaid &
Date. Use a Query to add up the payments for a given InvoiceID, subtract
the total from the original invoice amount, and that is what is still
owing.

If you do it your way and mispost a payment, then after correcting it you
will have to adjust the outstanding amount. If you get it wrong on the
first payment, you will have to adjust all subsequent records.
HTH

Phil
"DS" <bo******@optonline.net> wrote in message
news:HP****************@fe08.lga...
I have a continous form that records payments. I' starting out with a
bill of lets say $10.00. What I want to happen is that when I apply a
payment a new record is made. In that new record I want the remaining
amount left

from the $10.00 to appear in the new record. Lets say I apply $6.00, I

want a new record with $4.00 in it How would I pick up the value
remaining and apply it to the new record.
Thanks
DS


I agree about storing calculated values. The only problem is that the
invoice total is also calculated. I have tis amount hanging around so to
speak on a unbound field on the form. How do I get the form to make a new
record with this adjusted total? People will be entering various amounts
to each payment record so I want the new record to reflect the balance so
to speak in the paymount amount field. Any examples of this out there?
Thanks
DS

Nov 13 '05 #7

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

Similar topics

2
by: JK | last post by:
Hi All, I am working a form which is tabular layout (continuous form) which will display multiple records at a time. Each line of record needs to be reflected on the color code to show their...
1
by: adolph | last post by:
I would like to add a check box to the detail area of a continous form. So that I can check on specific records, then after I've marked all the records I watn to delte, click a button to loop thru...
0
by: gavo | last post by:
Hi. using A2K; i have a form containing a continous subform. The question is, how can i call a calculation for one of the fields in the continous subform from the main form. At the moment i...
0
by: ReidarT | last post by:
I have started to develop in vb.net. Earlier development was in MS-Access. I need a lot of continous forms to present data. The customer add and edits data in the continous form. Is use of...
5
by: Nothing | last post by:
I have a search results form that is being displayed as a continous form. I want to double click the name and then using VBA select the different columns of information. For Example: Name ...
1
by: Karl | last post by:
I have a continous form based on 1 table. On the form I have a button that sets the OrderBy to as follows DataSource = Me.RecordSource If Me.OrderBy = DataSource & ".PaymentDate DESC" Then...
1
by: Kev | last post by:
Hi, I am trying to total a column (Shift1) in a subform (continous forms) from the after update event of the (Shift1) column control within the subform. This column stores shift codes, I want to...
2
by: access baby | last post by:
How do i create continous form i created main form with subform drag and drop into main form but the subform shows me the 1st record of the customer . how can i link main form with subform i tried...
2
by: questionit | last post by:
Hi I know how to implement Continous form. In the method i have tried, the source for data on the continous form comes from table using SQL query Now, i want to try something different and i...
5
by: AccessHunter | last post by:
Hi, I have a continous form that displays Name and Address of Suppliers. In the form there is a combo box for 'Active Address' and 10 other text boxes. All the fields coem from one table,...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.