passing data to application.
-
We have a ERP system that lets me write macros in Vb script and I use them to pass data to an access application. below is a sample: Dim objShell dim strLaunch Set objShell = CreateObject("WScript.Shell") If [ORDER_ID] <> "" Then strLaunch = """C:\Program Files\Microsoft Office\Office\Msaccess.exe"" ""C:\Allocation.mdb"" /cmd """ & [ORDER_ID] & """" objShell.Run strLaunch Else msgbox "Please enter a Customer Order ID" End if is it possible to pass data to a vb.net application instead of using access? Chris
-
We have a ERP system that lets me write macros in Vb script and I use them to pass data to an access application. below is a sample: Dim objShell dim strLaunch Set objShell = CreateObject("WScript.Shell") If [ORDER_ID] <> "" Then strLaunch = """C:\Program Files\Microsoft Office\Office\Msaccess.exe"" ""C:\Allocation.mdb"" /cmd """ & [ORDER_ID] & """" objShell.Run strLaunch Else msgbox "Please enter a Customer Order ID" End if is it possible to pass data to a vb.net application instead of using access? Chris
Sure. It all depends on how the VB.NET app is written. Is this an app that you wrote or something you don't have the source code for? Is it an idea for a future app? We'll need a few more details about exactly what your doing, the details about the application, and the type of data you want to pass in. RageInTheMachine9532
-
Sure. It all depends on how the VB.NET app is written. Is this an app that you wrote or something you don't have the source code for? Is it an idea for a future app? We'll need a few more details about exactly what your doing, the details about the application, and the type of data you want to pass in. RageInTheMachine9532
hmm yes that would help wouldn't it. Its a "in the idea stage app" but I am thinking something like this - We have a customer order in our erp system that uses a vb script macro that will pass the customer order id number to my future vb.net application. What I would like to happen is the data gets passed to the application and on the form load event it uses the passed data as a parameter in a sql query that will populate other data on the vb.net form. Hope this helps
-
hmm yes that would help wouldn't it. Its a "in the idea stage app" but I am thinking something like this - We have a customer order in our erp system that uses a vb script macro that will pass the customer order id number to my future vb.net application. What I would like to happen is the data gets passed to the application and on the form load event it uses the passed data as a parameter in a sql query that will populate other data on the vb.net form. Hope this helps
OK. In that case, your best bet is to have your app check the command line parameters, probably in the form load event. That way, you can have the greatest flexibility as far as interface with various scripting languages or other applications you may write for the front end of the project. Now, you might also want to consider writing your app as a component (aka control). That way, you still have the flexibility of using your component in other scripting and app projects and you also get the added bonus of return values and greater flexibility of error traping and control in your front end app/script. RageInTheMachine9532