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...
Thanks for your input. But I need the field to be filled out before that record is closed out and having them click a validate button just won't be easy enough for the people who'll be using it. Isn't there a way of setting that field to be the last field to be entered and have it be required?
jo
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...
Thanks. I tried all your suggestions, and renamed the "Parts#" name to "PartsNum" but still no go.
I am already using the DLookup in another database, so I know the general set up of the statement is correct, but still no go.
Is there anything else I'm overlooking. I...
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 =...
Yes, I did read your suggestioned thread, bobbster. That seems to be the best solution. I just wanted to see if there's an easier way then entering in values. But thanks, that's what I'll probbably do.
Thanks again, mulligh, but there doesn't seem to be a way of printing a specific record in...
Setting up a print button to print record doesn't work, it prints all the subform records for a specific main record.
Thanks anyway, it was worth trying.
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.