Call A VBA Module From Command Line Script?
Dec 23, 2011Is it possible to call a VBA module (found within a MS Access database) from a command line script?
View 3 RepliesIs it possible to call a VBA module (found within a MS Access database) from a command line script?
View 3 RepliesI have a GUI VB application, and a seperate command line module. How can i run the command line module through the gui app, without binding / installing?
View 5 Replieshow we can declare a connectionstring in a module and call that module
View 1 RepliesI have beginner skills using VB (am using the Express edition to learn). I would like to know how to set up a conditional statement in a Windows Form (WF) app that would check if a specific command line has been passed by another separate app that launchesthe Windows Form app using command lines, and if not passed, then the Windows Form app would shut down (exit, close).So far, I can use:
For Each s As String In My.Application.CommandLineArgs
If s <> "xyz" Then
Me.Close()
[code]....
I have a VB.Net interface that communicates with an Access 2k3 Database using this module:
Module MOD_ENGINE
'Declare Database connections controls
Dim con As New OleDb.OleDbConnection
Dim dbProvider, dbSource As String
[code]....
I want to call EngineConnect procedure from MOD_ENGINE module into popCboBox module so I can ignate the engine!
First let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.
I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _
[Code].....
I am using the following code to run defrag and to analyze if the C: drive requires defragmentation:
Dim analyze As Process = System.Diagnostics.Process.Start("C:WindowsSystem32defrag.exe", "C: /a /h /u /v")
This process runs through analyzing, runs it in normal mode & prints the progress to the command window.
My problem is that as soon as the process is complete the command window closes. I need it to stay open so that I can read the results.
I am trying to send a command to the external command line (cmd.exe) from the Windows form application that I'm writing in VB.NET (using VS2008).
I can only access the external program thru the command line (its not my program) and I must do so from a form app.
I am trying to use the following code. I am able to call a cmd.exe window, but I can't pass the command line my command.
Using mp As New Process
With mp.StartInfo
.FileName = "cmd.exe"
[Code].....
I am using a CheckedListBox that is populated with Filenames (full path, i.e. C:TestTest.jpg)When I have the files that I want in the CheckedListBox I wish to click a Start Button which will process the list one at a time using an exe program that runs on the Command Line. There are arguments that need to pass to the command line as well as the file location in order for the program to process.I currently have it working but the issue is the loop finishes quickly and it is left up to the CMD.exe to finish the process. What I would like is for the LOOP to wait until each file completes processing before passing the command for the next file in the CheckedListBox.There some reasons I wish for it to work this way.
1) I would like to have a button that can Pause/Restart the Loop.
2) I would like to have a button that can Stop the Loop so the whole process can end.
3) I would like to have the Loop remove each file one by one from the CheckedListBox after it has been processed.
4) I would like to display a Message once all the files have been processed.
5) And if it were possible I would like to report the status either by text or a progress bar showing where it is at in the process.
6) And the ability to add some error handling if possible.
Since the Loop finishes so quickly as it just passes the command to the command line using the & as a seperator it is the command line that is handling the rest of the process. Because of this there is not control over it in the GUI.The code I am using allows the Command Line text to display in the Form so it won't open up a seperate window to run CMD.exe. This is the desired affect as I would like everything to appear to run from within the Form itself.
[Code]...
I have a problem regarding calling the function in form to the module..i have 2 module which is User Login Module and the other Module is Update the Fields of Student..my problem is the Update Module when i call the function in form i cant call the function that i used..this my code in udpate module and this is my code in form The UpdateExeQuery that i use in module.when i call in the form its error..
View 11 Repliesi've created a Sub in a Form.
I've created another Sub in a module.
I call the Sub in the module from the form, passing the form into the Sub defined in the module.
Then i add an Handler to an istance of a control (for example mousemove) and i want to give to this handler the execution of the Sub defined in the form.
Example.
Class form1
Sub Form1Sub()
ModuleSub(me)
[Code]....
The problem is that i don't know hot to call the Sub defined in the form, in the Sub handler using the istance of the form passed in the Sub paramenter in the module...
I have a Util module in my VB.NET program that has project-wide methods such as logging and property parsing. The general practice where I work seems to be to call these methods directly without prefixing them with Util. When I was new to VB, it took me a while to figure out where these methods/functions were coming from. As I use my own Util methods now, I can't help thinking that it's a lot clearer and more understandable to add Util. before each method call (you know immediately that it's user-defined but not within the current class, and where to find it), and is hardly even longer. What's the general practice when calling procedures/functions of VB modules? Should we prefix them with the module name or not?
View 3 RepliesI have a main form (frmPos) and through a module (modTransaction) I open and close several other forms. This works flawlessly. However, when the function on the module is finalized, I want to clear the main (open) form. Therefore, I made a public sub (clearForm) on the main form and when I call this from the main form it works.
View 2 Repliesim trying to do something like this
Module module1
public sub()
dim a as string[code]....
Im new in this forum. I just recently upgraded my Visual Studio 2003 to Visual Studio 2008.I have a web project which is working very well in Visual Studio 2003. But when Im trying to run the same project in Visual Studio 2008, Im getting a runtime error message.The error message is about a public function which is defined in a public module. When Im trying to call that function from different web pages of my project, the web pages are not recognising the public functions and asking me to
View 3 RepliesThe company I work for has a VB6 project that is using an ACCESS database.The project consists of seperate modules such as Accounts Payable, Payroll, General Ledger, and Inventory.At the current time each module is a seperate project in VB6 and the EXE files are called when needed.In total there are about 1300 forms in the project.We are moving from ACCESS to Sql Server and from VB6 to VB2008.The question that I (we) have is as follows; Should we continue to keep each module seperate and call the EXE's or should we create one large project?What are the pros and cons for each way?Is there something written that explains the advantages of either?
View 5 RepliesThis is my vb6 programme for creating recordset in a module. and call it in class
and form
[Code]...
I am struggling to pass a parameter to a VB.NET application via a Windows scheduled task. It works perfectly in Visual Studio (passing a command line arguement via project properties).If I am calling a VB6 application, then I will supply the following parameters and it works:
Run: c:progra~1TestTest.exe TestParameter Start In: c:progra~1Test However, if I supply the same parameters in VB.NET, the program throws an exception when it tries to create an instance of a class in the Form.Load: System.NullReferenceException cannot create instance of object.
I have also tried the following:Run: c:program filesTestTest.exe TestParameter Start In: "c:program filesTest" This time the status of the scheduled task changes to "cannot start".What is the correct way to specify command line parameters in a scheduled task for a VB.NET program?UPDATE I found the solution on this web page:[URL}.. I am still confused as to why the program would not create an instance of an object when I used the 8 bit paths (i.e. progra~1)
I have a function in a module that returns a datatable.I need to call that function asynchronously and get the results in the Main thread (Main Form) in vb.net.
View 2 RepliesI have a form set up where I want to run the function PopulateGrid on it's Form_Load event. I have initialized the DB connection as follows:
Private Sub Main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
LoadConfigFile()
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & config("DatabasePath") & ";")
cn.Open()
End Sub
Now, I want to run the PopulateGrid function directly after I connect to the database as shown above. I'm confused as to how I'd use a database query in a module when the database is initialized in my main form. Would simple setting the variable cn to public work?
I am try to learn to use Mysql / MySql.Data.MySqlClientI did find sample how to connect to Mysql but I want to have it in Class or Module so I only call open database when I open the form
How can I fix this Name 'connStr' is not declared
CODE:
I have not used a module in a long time. I am get an error when i try to call my sub openDatabaseConnection that is in a module called dataaccess. i amtring to call this method in my ui form code but i get the error as so: The type initializer for 'bsoDetailsDB.dataAccess' threw an exception.
My code:
Public Class Form1
Private Sub btnOpen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOpen.Click
OpenDatabaseConnction()
[CODE]........................
I have to calculate y = a + Bx or y = mx + b in non engineering form. Anyways I have to calculate the y intercept first and am having trouble calling the function from a module. Here is the module and the second window will be the code from my main form
[code]...
Public Function GetFilledTable(ByVal query As String, ByVal connection As OleDbConnection) As DataTable
Dim command As New OleDbCommand(query, connection)
[Code].....
I'd like to have a macro in Visual Studio 2005 that calls a DOS command and redirects the output (stdout and stderr) to a file. Just calling the command and ">" redirecting it will not capture stderr, so there are two parts to this:
calling a DOS command capturing both stderr and stdout to a file during that call
I'd then like to open this file in Visual Studio after the command completes.
I have a classic ADO command which execs a sproc and returns a RecordSet. This is being executed from a VB.NET using the PIA.However when I .Execute the command, the result returned is not an ADODB.Recordset but a System.__ComObject.
View 1 Replieslet's say I have a btnX_click event calling each time when I click btnX:[code] I have menuX menu item and click event for it:[code]I just want every time when menuX item clicked on to do the same thing as btnX control does when clicked.I haven't been programming in VB for ages;Actually haven't been programming at all for a while..But definitely remember writing (calling command event without explicitly clicking on it) this in Delphi; but cannot remember how;
View 4 RepliesI want to run the following command line program from VB.NET: rotor95.exe -d -k "password" -i "C:FileLocation" -o "C:FileLocation" The reason for this is that I don't want my users to have to drop out to a command line prompt in order to run a tiny program for 3 seconds. Typing in a 50 - 75 character file path twice isn't any fun either.
I tried using tooltask as discussed in the MSDN2 help but it appears to work with switches (/d etc.) but not parameters (-k "password"). I couldn't get the thing to work. See the following for the tooltask example:[URL]..light now I'm just using Shell("rotor95.exe -d -k "password" -i "C:FileLocation" -o "C:FileLocation") which works just fine but I'd like to use the .NET 2.0 super-whammy version of handling this problem if there is a better way to do it.
how to use basic FTP functions straight from the command line tool. and I started using Visual Studio to create "macros" for the command line tool (i.e. writing down specific functions to perform, write them to a txt file and then run Shell() to execute.)But what I want to know is if I can open a command prompt window and then interact with it. Say for example I'm writing an FTP class/object, I'd want to be able to keep a window up for my program to send commands to (And wishfully read data back from it.)Because it seems to me that whenever I use the Shell() command it just opens a prompt window and then closes it after my line of code has been executed. Is there way to interact with a command line window from Visual Studio? And maybe even scrape data from the terminal like with terminal emulator scripts?
View 1 RepliesI have a console application which reads .txt files. I want to be able to drag a txt file over my app and it would automatically open my app and show the text files contents. I think I have to use command line arguments like this:
Sub Main(ByVal cmdArgs() As String)
End Sub
Sub ReadFile(FilePath as String)
End Sub
But how can I pass the text files path to my ReadFile sub?