Search results for query: *

I am trying to see if a file is open and being used (written to) by another program before I try to read the file. And if it is I need to move to the next file. I am trying the code below but it seems to open the file and I do not want to open a file but just see if it is already open. Can...

I am needing a lot of help with this loop. What I am trying to do is find a mactch between stext and ltext by searching ghe grpts1 "seatex" that matches the grpts1 recordset and if it does not match the first recordset then it needs to move to the next recordset to do a search. Can someone...

When I run the GetRecordset Function I am getting "Invalid SQL statement; expected 'Delete', Insert, Procedue, select, orupdate in GetRecordset" I just trying to access data that will be used in another function in this Module. The strQuery opens the query but I can figure out what I have done...

How would convert to vb.net ?? It is probably simple but I' can't figure out EmpID = Val(Trim(Right(FEmpID, Len(FEmpID) - 1)))

I need help with a connection; I need to connect to a SQL table that is linked to an Access database. The database itself should be open using another connection but this code below needs to be modified as it is not working now. I am Inserting into the SQL table. I am using ADO for the...

I am getting an An unhandled exception of type 'System.NullReferenceException' occurred in test.exe Additional information: Object reference not set to an instance of an object. error on this line : g1.MoveFirst() That is below this line : g1 = GetRecordsetCmd(g1, strSQL, 2) Where do I...

I have the following code that is vb6 that I need to convert to vb.net vb6 MyFile= Freefile 'Open pathnfile For Input As MyFile 'Do Until EOF(MyFile) ' Line Input #MyFile, Linetext This is how I am trying in vb.net but not sure where to place myfile: FileOpen(1, pathnfile, OpenMode.Input)...

This is vb6 code - how would it be formated to use in vb.net to do the same??? strFJobN = Trim(Mid(strLinetext, 40, 10))

How do I changes this code for ado.net??? Public Sub OpenConDatabase(ByRef sFile As String) Dim ADODB As Object On Error Resume Next gConData = Nothing gConData = New ADODB.Connection Dim OleDb As Object On Error Resume Next gConData.ConnectionString =...

:o How do convert this to vb.net using ADO.net - it is inserting values into an SQL table? What Imports namespaces and how do I format and connect to the server and will I still use the same Insert Into statements?? ADOCn.Open("0567_SQL_750_REPORTS", "sa", "sa") ADOCmd.ActiveConnection =...

I have a status bar on a form and four labels above each panel. I need help with coding the labels to move (resize) with the statusbar panels. :confused: