Search results

  1. A

    Change Check Box when stock value is 0

    Dear Privateer Thank you, I changed your formula to suit my needs. I learnt some things from what you said, about changing the control source and the IIf formula. Thank you for your time. Craig
  2. A

    Change Check Box when stock value is 0

    Thank you for the reply. I will go and work on what you suggest. :-)
  3. A

    Change Check Box when stock value is 0

    Please help. When the stock in my sales database is 0 I want a check box to get automatically ticked. I use the check box results to create a list of in stock products, but also just want to know how to do this. I have put the code in my after update event, in the stock control on my form. Forms...
  4. A

    Combo filtering Report

    Thank you for saying you will look later. Paul I could not get things to work, but came across another place where you helped someone. And by looking at both places I believe it is now right. Here is my code for those who might be interested. Please if you see anything in my code that needs...
  5. A

    Combo filtering Report

    Thank you Paul I will study your code later and see if it helps me. Cheers, Craig
  6. A

    Combo filtering Report

    Hope this is where I ask a question? I want to filter a report using a combo box in a form. I have a PriceList table, that has the PriceListID, PriceListName etc. It is linked to the PriceListDetail table where the ProductID, MarkUp & Prices are. I have three places I sell my goods at the...
  7. A

    Please review code

    Ken after Michael reminded me of what fires first, if I can put it that way. I believe I understand. Thank you for checking my code Michael. Thank you to both of you for being so helpful. Craig
  8. A

    Please review code

    I have changed my code after reading Michael's comment. And I stepped through the code as Ken suggested, it just kept on going until it got to exit sub, the yellow disappeared and just the code was left. Private Sub Form_AfterInsert() On Error GoTo ErrorHandler Dim db As...
  9. A

    Please review code

    Thank you Ken. I will do that. :-)
  10. A

    Please review code

    Thank you Michael for your response. I still don't comprehend things properly. But I will ponder things a bit more and look at my other code in my tutorials. I will read your notes a few more times also. One day I am hoping things will click. :-)
  11. A

    Please review code

    I have very basic skills and am trying to learn VBA. I just added some error handling code to code I took out of my tutorial book. Please would some of the members have a look and tell me if I have made a mistake. I understand you have to close things and then resume them, but I don't really...
  12. A

    Introduction

    Hi everyone My name is Craig. I live in the UK now, but was originally from South Africa. I use access to help us keep records for our self employed business etc. I love access but it does not sink in very easily. I have been reading books and doing exercises for years and I still only know...
Back
Top Bottom