Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. quackslikeaduck

    one field on form to update several

    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...
  2. quackslikeaduck

    saving forms

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

    saving forms

    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.
  4. quackslikeaduck

    saving forms

    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.
  5. quackslikeaduck

    saving forms

    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.
  6. quackslikeaduck

    saving forms

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

    saving forms

    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)...
  8. quackslikeaduck

    calculate fields

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

    calculate fields

    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.
  10. quackslikeaduck

    calculate fields

    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...
  11. quackslikeaduck

    calculate fields

    ...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)) *...
  12. quackslikeaduck

    calculate fields

    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...
  13. quackslikeaduck

    calculate fields

    ...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)) *...
  14. quackslikeaduck

    calculate fields

    ...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)) *...
  15. quackslikeaduck

    calculate fields

    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...
  16. quackslikeaduck

    subform columns showing up from left to right when they should be going down

    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!!
  17. quackslikeaduck

    subform columns showing up from left to right when they should be going down

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

    subform columns showing up from left to right when they should be going down

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

    best way to join - brain block

    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.
  20. quackslikeaduck

    subform columns showing up from left to right when they should be going down

    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?

Part and Inventory Search

Back
Top