Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SonOfEmidec1100

    Lost In Joins...

    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
  2. SonOfEmidec1100

    How to detect when the child form been unload

    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...
  3. SonOfEmidec1100

    Stopping Parent Code while Child Form is Active

    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...
  4. SonOfEmidec1100

    SQL Server String Manipulation

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

    ODBC Default Database won't stick!! UGH!

    Can you post your connection string.
  6. SonOfEmidec1100

    Optional/Null stored procedure parameters

    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
  7. SonOfEmidec1100

    Time

    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...
  8. SonOfEmidec1100

    number of records in csv file

    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...
  9. SonOfEmidec1100

    How to Install SQL Enterprise Manager?

    Install Client tools from the SQL Server 7.0 install CD.
  10. SonOfEmidec1100

    Problem with error handler

    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
  11. SonOfEmidec1100

    Problem with error handler

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

    Are there issues with converting 2000 DB's to v7

    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.
  13. SonOfEmidec1100

    Access front-end: DAO Coding w/ SQL 7.0

    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.
  14. SonOfEmidec1100

    Can't see &quot;Drop down&quot; list

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

    Multiline textbox

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

    How set date field to NULL in code

    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 =...
  17. SonOfEmidec1100

    Resize event

    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.
  18. SonOfEmidec1100

    How to execute query which has more then 25 lines.. from vb

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

    vb6 listbox

    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...
  20. SonOfEmidec1100

    Retrieving cursor position in a textbox

    Whats wrong with using the SelStart property ?

Part and Inventory Search

Back
Top