How would I automatically copy the sum of data in a field of one form into another field on another form?
IE, sum of all the "price" fields on one form will equal the subtotal field on another form.
I know how to make the change on just the form, but it doesn't make the change it in...
How do I take the value of a field in one table and have it equal the value of another field in another table?
I need the sum up a group of "Price" fields and have that sum entered into a Subtotal field in another table. I have a table with the "Price" field, and in another...
Hi.
I have a field on a form that needs to be filled out everytime a new record is entered. The only problem is, I want that field to be entered last and there's a few subforms in this main form. Because of these subforms, when I set that field on the main form as a required field, it won't...
Can anyone solve my mystery? I can't figure out why the "parts" and "price" field aren't being filled in when I enter in the parts#.
Here are the two tables involved:
Parts_List - contains the lookup info; PartsNo, Parts, Price.
tblParts - holds the information pulled from...
How do I either, create a date field that recognizes a 0 in front of the single digit months? Ie, 01 (January).
Or what do I need to put in the query to get a report of a specific month, that has 1 in the month.
I currently have it set up so the user puts in the month to generate a report...
How do I simplify this?
<script>
function calculate1() {
var subtotal = (prefix.form.quantity1.value) * (prefix.form.price1.value);
prefix.form.sum1.value = subtotal;
if (subtotal == "0"){
prefix.form.sum1.value = "";}
}
function calculate2() {
var subtotal =...
How do I print a selected record and only the currently displayed subform record of that selected record?
It prints up all subform records of a selected record instead of just the one I currently have pulled up.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.