How to Use the IsNumeric Function to Validate Data Entry in Microsoft Access

[@roberthutson2023]

I have a question, this is a more fun one to try and do and ill explain the situation in say the best I can. If you have 2 databases that are separate front ends but share the same back end. If for example, you work in a shop, and you work in the stockroom. If when you place an inventory stock request in the stockroom to say the companies warehouse, as you press the send button, how can you get a message box to show up on the other application in the warehouse saying new PO was submitted. This is one I have been working on and trying to figure out.

[@NimishP]

Can we add a spin control on Order form and then pass on value of that control when viewing / printing that invoice. We can pack all business rules in that control without any programming requirements. That will bypass InputBox dialog coupled with its limitations.

[@Shadow.Dragon]

Great video, Richard! I wonder why the ISNumeric function doesn't catch a Null or blank string. Hmmmmm!