Search results for query: *

Can I use one field on a form to update 5 different records with 1 single value? or can I create a query that does this and point the 1 field on form to the query? For instance: I want to see one field on the form called "Price". I want the value of whatever is entered into that field to...

Thanks! I'm going to give it a try. I really don't need it but just one more experience for me.

I'm not talking about making an actual report. I was talking about as soon as my user is done filling out the form they can click update and it would save it as either a data access page or .pdf. I want to know if any others are doing this and how it works out for them.

Thanks! I do understand that but was wondering if after my PO's were filled out could I maybe save a copy as MS Access Report or .pdf? I have heard of others doing it but never really thought about it until now.

I'm just wondering if after my user fills out a form can it be saved as a file or report automatically in the background maybe on close or something? If possible I'd like each form to have a unique name like maybe PO number or something to distinguish one from another.

It was overwriting the first row because the primary key was not autonumber and therefore wasn't creating a new row. Thanks!

Can anyone help me figure out why when I close my form and it save to the tables it always overwrites the last save which is the first in my table. I believe each should save in a new row. My tables are as such: TblPurchaseOrder (a table holding information on items being ordered)...

I now have a total. I went in and checked and changed the subform control name in each instance. Thanks!

Ha good point. I did use the Expression Builder to make them but never gave it a second thought because they were the only expression categories.

Okay that looks reasonable. Can you tell me why the code that I did run doesn't work even if I do build the query. It worked in the total that I had on the form before I normalized it but doesn't work now. I'm not stuck on running it but would like to know why it doesn't work now. I looked...

...subform'. Here is the code that I used: Private Sub Total_Click() Me.Total = (Val(Nz(Forms![tblItemList subform]![PricePerUnit], 0)) * Val(Nz(Forms![tblPurchaseOrderItems subform]![QuantityOrdered], 0))) + (Val(Nz(Forms![tblItemList subform]![PricePerUnit_2], 0)) *...

The value will be in my total text box. The code is running on the "Private Sub Total__Click()" Event. I was actually just in the Expression builder trying to figure out how to use that instead because I know that I don't have the naming of the subtotals and fields laid out in the proper...

...doesn't work with the form I have now. The last form was based on same values but needed to be normalized. Me.Total_ = (Val(Nz(PricePerUnit, 0)) * Val(Nz(QuantityOrdered, 0))) + (Val(Nz(Price_PerUnit_2, 0)) * (Val(Nz(QuantityOrdered_2, 0))) + (Val(Nz(PricePerUnit_3, 0)) *...

...I used the following code in my original form and it worked fine. It doesn't work with the form I have now. Me.Total_ = (Val(Nz(PricePerUnit, 0)) * Val(Nz(QuantityOrdered, 0))) + (Val(Nz(Price_PerUnit_2, 0)) * (Val(Nz(QuantityOrdered_2, 0))) + (Val(Nz(PricePerUnit_3, 0)) *...

I have two fields from two different subforms. I would like to have a total (on the main form) of the two fields from the two different subforms. Is there a way that the total (that's located on the main form to update as information has been added to the text boxes in the two different...

Sorry about that. I've been working at this much too long. For too many hours at a time. It's been one problem after another. I don't mind putting in the time it's been 1 step forward and 2 steps back. I already have another issue to research. Thanks!!

I put it in contigious and they're still next to one another. I want them in a column up and down.

The default view is set to "Datasheet" right now.

I didn't change it. So far things are going good. I've been able to add my form and subforms. Still going with a few minor snags but I'm sure I'll overcome them.

I created a subform and put in my fields. Text Boxes on forms showing up next to one another (print preview) when I put them in columns one underneath the other?