Starfleet captains are like children. They want everything right now and they want it their way. But the secret is to give them only what they need, not what they want.
I have situations where there is no labor but there are materials involved and vice versa. When I try to make an invoice I get a runtime error 3021 "No Current Record" and the debug points to the rs.Movefirst command in the event Sub MakeInvoice_Click(). How can I correct these two situations?
Sounds like you just need to check to see if there are any records before looping. A quick DCOUNT should suffice.
I have to apologize, it's been TEN YEARS since I recorded that seminar, so if you want more in-depth help, I need to know which video you're on, and the time index that the problem occurs. I'll need to refresh my memory of exactly what I did. :)
Julius CunninghamOP 4 years ago
Ok. It's video 46 index 00:17. Once you completed the programming you tested it. It works perfectly, but try a work order with no labor cost but with material costs or vice versa. When I tried it the program stops when it reaches "rs.MoveFirst".
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
Work Order Lessons.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
