Search results

  1. C

    Call up Module Function

    Brill cheers m8, can't thank you enough for helping with this one, Your a star the only last problem I have now with the DB, Is I want to create a field on Customers, to show the total unpaid balance on all workorders for that customer. But because the field is a calculated field, I cant...
  2. C

    OpenQuery

    Hiya I have a button that has the following Macro in the Onclick event OpenQuery - Quote Material, Datasheet OpenQuery - Labour Material, Datasheet Runcommand - Refresh Both those querys are Appends, so once the button has been click it shows the Append # Records, yes, no, cancel etc How...
  3. C

    Sum Totals

    Hiya Looked through the link but still couldn't get this going The control source for my AmountDue filed is =Forms![Workorders by Customer]![Workorders by Customer Subform].Form![Workorder Total]-nz([Total Payments]) I have an unbound field on the footer Tried, nzsum, dsum and sum but...
  4. C

    Call up Module Function

    ***Update*** I found a quock fix to the problem just now. I created another button next to Create Workorder and called it Update to Workorder. I did it as a Macro, and had it add in the Appends for Materials & Labour and had a refresh too. appears to be working now.. I now, fill out the...
  5. C

    Call up Module Function

    Hmm after creating a few Quotes with the new module I run into a small problem It appears that when in the Quote form, I have to Click on Create Workorder button before I start to get the WorkorderID. Then I have to enter the Materials in sub. I exit and goto workorders, and its created the...
  6. C

    Call up Module Function

    WOW 3 weeks off atempts on this and you got it pinned in 2 days lol Your a genius Seems to be working perfectly. That button will do the trick nicely. I think I will add in a check field in the quotes tho, so once a Workorder has been created by the quote, a check could be placed, letting the...
  7. C

    Call up Module Function

    Also, is there a way the code could be fixed, so that it won't add the workorder if the button has been click previously. For example, if the customer double clicked the Execute button, it would create 2 identical workorders? I would imagine somewhere there would be an IF workorderID then blah...
  8. C

    Sum Totals

    Hiya Access 2007 I have a field called Amount Due The control source for this is =Forms![Workorders by Customer]![Workorders by Customer Subform].Form![Workorder Total]-nz([Total Payments]) on the footer of that sub I have an unbound field called text4 How can I sum this and show the...
  9. C

    Call up Module Function

    Can you manage to add this code into the Module somewhere INSERT INTO [Workorder Materials] ( QuoteID, MaterialID, Quantity, UnitPrice, WorkorderID ) SELECT
  10. C

    Call up Module Function

    ok got it going, I just had to click refresh to show the subform info Only problem I got now, is when the Quote has been sent to the workorder, and the new workorderID has been created. And I want to do another Quote as a workorder, I get the SAME WorkorderID.. Always seems to be workorderID...
  11. C

    Call up Module Function

    again lol its ok, I found it I had forgot to add the WorkorderID to the Quotes form in design view Got it working now However, still have same problem about showing the Subform (Quote Materials) into the Workorder, Workorder Materials? ________ Blonde goddess
  12. C

    Call up Module Function

    Cool m8 cheers ok, Just copied the module to my DB and all the querys you done. I went to the Quotes page I have, created the button to execute, edited the code behind to accept the bound field - WorkorderID instead of the txtworkorder I click on Exxcute, and I get a Variable not define -...
  13. C

    Call up Module Function

    ah I see now, I see you have the append query running the Module itself so when the button is click it does it all. ________ UGGS
  14. C

    Call up Module Function

    Hiya m8 Just playing around with the sample you sent, and trying to add the forms as it looks with mine. Customers, etc I created a button on the Quotes page, called it Execute I assume I need to have the button run the append query First, then your execute code to get the code back...
  15. C

    Call up Module Function

    ok Will do Had a look through in design view and noticed that you had the new workorderID going to an unbound field.. The way I would want it, is to copy the new workorderID to the subform.WorkorderID Bound field.. Would this make a difference? or do I need it as unbound ________ SPICE WEED
  16. C

    Call up Module Function

    wow that looks so easy. Just need to attempt this on my own DB and see what resuilt I get.. I just the new Workorder to be copied into the Quote Subform, then that subform would link itself to the Workorder, using the new workorderID So yes, I think you hit it on the head there Can't thank...
  17. C

    Autonumber Next Increment

    If you look in the DB attachment It opens up with my mainform.. Click on DateofQuote linked in blue and it will take you to that Quote. Click on Create Workorder, and it copys the quote to the correct place but not the subform ________ MONTANA MEDICAL MARIJUANA DISPENSARIES
  18. C

    Autonumber Next Increment

    Hi Leigh My goal on this is - I create a Quote, click a button ( Create as workorder) and have the quote copied into the workorder with the Subform of materials So far, I have got the append working and it sends the quote to Workorders and creates a new WorkorderID for me. I need to find...
  19. C

    Call up Module Function

    ok m8 that woul dbe great Very much appreciated ________ Bong Reviews
  20. C

    Call up Module Function

    lol ok I'm lost I think I just might do a double entry lol and re-type the Workorder, It sounds easier As I said, I'm still a basic novice lol ________ Washington Medical Marijuana Dispensaries
Back
Top Bottom