Search results for query: *

Heres one way I think should work SELECT ISNULL(Table1.EmployID, Table2.EmployID) AS EmployID, Table1.CUD, Table2.EMM FROM Table1 FULL OUTER JOIN Table2 ON Table1.EmployID = Table2.EmployID ORDER BY Table1.EmployID

Heres one way Public Function fnCheckIfFormLoaded(myformname As String) As Boolean Dim frm As Form For Each frm In Forms If frm.Name = myformname Then fnCheckIfFormLoaded = True Exit Function End If Next fnCheckIfFormLoaded = False End Function 'sample use If...

You can show a form as modal style, the code will then wait on the show until the loaded form is closed. Note however you cannot display 'child' forms modally, if the child property is true you will need to set it false. This should not cause any problems. MyForm.Show vbModal, frm_main for...

One way --field1 numeric select right('00000000' + convert(varchar(8),field1),8) + '*01' --field1 varchar/char select right('00000000' + rtrim(field1),8) + '*01'

Can you post your connection string.

By null value I assume you are sending an empty string - not NULL. Passing NULL will work, although the code in the sp will need to allow for it. To make the parameter optional just supply a default value in the sp CREATE PROCEDURE dbo.test @number INT = 0 AS select @number GO

Look up VB help on the Time statement and it will tell you the following, and give an example. Time Statement Sets the system time. Syntax Time = time The required time argument is any numeric expression, string expression, or any combination, that can represent a time. Remarks If time is...

You are going about the wrong way, the code you are using is for a file of fixed record length (132 characters). A CSV file will almost certainly be variable length. The code is for the click event of the import button. The first (Private Sub...) and last (End Sub) lines will be there by...

Install Client tools from the SQL Server 7.0 install CD.

Another technique is to use ON ERROR RESUME NEXT , along the lines of this example On Error Resume Next Statement that can cause Error If Err.Number <> 0 Then 'error process if required End If 'reset error handler On Error GoTo ErrorHandler

You probably need a Resume statement somewhere, hard to tell without more info. So can you post the relevant code?

My view - there is no backwards compatibility from 2000 to 7. Anything you are going to do you need to do from sql2000. I would script the database objects, select only scrip 7.0 compatible features in the formatting options. Then use DTS or maybe BCP to transfer the data.

From memory no changes required for accessing your user data. As I recall there were a few field name changes in some system tables/SPs - bit vague now been a while.

Have you set the DBcombo1.ListField property to the relevent field ?

You also need to set the Multiline property to true in order to get the cr/lf to wrap, rather that showing two blots.

I would use something like this, untested but NULLs should work. Dim param As ADODB.Parameter Set mcommand = New ADODB.Command With mcommand .CommandType = adCmdStoredProc .CommandText = "nf_UpdateTermination_Import" .ActiveConnection = connSQL .Parameters.Refresh Set param =...

Dont know why but one of the display properties seems to effect this. Under XP goto screen properties, effects and check/uncheck - Show window contents while dragging.

Break the string into logical chunks,eg by day then concatnate them. string = "part1" string = string & _ "part2" string = string & _ "part3" ...

To keep it simple you could create a function to check by looping thru the list box items. A good source of info is the VB6 online help for ListBox - properties, methods and events. Public Function f_IsItemInList(sValueToCheck As String) As Boolean Dim x As Long For x = 0 To...

Whats wrong with using the SelStart property ?