Thank you for all your videos. My programing skills have improved exponentially thanks to you. In D23, L04 Order Entry 2 (60:16) Bonus, there was a problem in the OrderF. At 52:32 you noticed that the AutoNumber was still New since the user immediately starting adding products in the OrderDetailF when they selected a new record. At 53:00, you fixed it by adding code to the AddBtn on the OrderDetailF which set OrderDate again. However, lets say a customer comes in & wants to buy the Star Trek Captain Picard Poster hanging on your wall. If the user immediately starts typing in the OrderDetailF, the AutoNumber wont update. I think you need this code in the OrderDetailF On Enter Event only:
Private Sub OrderDetailF_Enter()
With Me ' OrderF If .NewRecord Then .OrderDate = Date .Dirty = False End If End With
End Sub
You could eliminate updating the OrderDate from the AddBtn as well. (Note: You notice the problem at 52:37 in the TechHelp Invoicing Video Extended Cut.) Thanks again for all you do for all your minions.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 23.