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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by quackslikeaduck

  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

    I've finally got the code together in what I thought was right but now I'm coming up with Run-Time error 2450 Microsoft Access cannot find the referenced form 'tblitemlist subform'. Here is the code that I used: Private Sub Total_Click() Me.Total = (Val(Nz(Forms![tblItemList...
  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

    CORRECTION: Sure my fields are tblPurchaseOrderItems subform.QuantityOrdered 1 - 5, tblItemList subform..PricePerUnit 1 - 5, I used the following code in my original form and it worked fine. It doesn't work with the form I have now. The last form was based on same values but needed to be...
  14. quackslikeaduck

    calculate fields

    Sure my fields are Subform2, ItemList.Subform3PricePerUnit 1 - 5, tbPurchaseOrderItems.QuantityOrdered 1 - 5, 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))) +...
  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...
See more

Part and Inventory Search

Back
Top