Recent content by AccessRobo

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

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

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

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

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

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

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

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

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

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. :-)

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

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