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!

Recent content by dannyh

  1. dannyh

    This is an easy one, adding a list to a combobox

    The combobox has an AddItem method, you can do something like - combobox1.AddItem "Jan" - for each, or make an array containing the month names and loop through it for adding the array elements. Hope this helps, Dan.
  2. dannyh

    SQL2000 Stopping when viewing properties

    Thanks for the reply. The server actually freezes, all the users get a 'cannot connect to server message'. Dan.
  3. dannyh

    SQL2000 Stopping when viewing properties

    Hi All, I have a SQL2000 Server, running on windows 2000. About once every couple of weeks it will stop when you select 'view properties' through enterprise manager. I have tried accessing it with a Windows98 box and a Windows2000 box and have the same effect. As this causes the server to stop...
  4. dannyh

    Remote Control

    Not in VB. There is a product called VNC that you can download that comes with source code, but it is in C++. Dan.
  5. dannyh

    MTS : Capacity Planning

    It is not quite as simple as that (things never are with MTS). There is not a limit on how many users you can have connected to MTS, but after a point you will notice that performance will start to degrade. The point where performance drops off is also not a set point, but depends on what your...
  6. dannyh

    Error handler not handling errors

    It is happening becaust you program is still in an error state. You need to come out of the procedur to the calling procedure then go back in, perhaps using a parameter to control the version of the search that you pass in. Hope this helps, Dan
  7. dannyh

    KeyUp Event never executes

    You might be better putting it on the KeyPress event. As far as I can remember not all keys (function keys etc) dont fire the keyDown and KeyUp events. Dan.
  8. dannyh

    VB activex and visual fox pro 7.0

    Hi, If you define your method in VB, something like ... public sub mySub(byRef myArray() as integer) ... or whatever it should be, you can dimension your array in VFP and then pass the VFP array as an argument to the VB DLL, where you can manipulate it as usuall. Hope this helps, Dan.
  9. dannyh

    New to DLL world

    Okay, When you have built a DLL in VB and compiled it, you dont need to do call it in that way. Instead do this... 1)Goto the project menu and select 'references'. 2)Find the DLL in the list and put a tick by it. 3)in your code use... dim myObject as Test.Test set myObject = new Test.Test...
  10. dannyh

    Random records from Access

    Oh yeah, you will need to put the command RANDOMIZE in first, so ... RANDOMIZE MyValue = Int((RS.RecordCount * Rnd) + 1) RS.Move MyValue,1 '1 means the start of the recordset Dan.
  11. dannyh

    Random records from Access

    First get your recordset, then generate a random number between 1 and the size of your record set, for example : MyValue = Int((RS.RecordCount * Rnd) + 1) RS.Move MyValue,1 '1 means the start of the recordset You will now be pointing at a random record in your set, so display as normal...
  12. dannyh

    Stored Procedure Inquiry... Pls. Help...

    How are you calling the stored procedure in the first place ? Dan.
  13. dannyh

    COMMAND TEXT NOT SET

    Okay I have just checked and I admit the click event is definately better for this !
  14. dannyh

    COMMAND TEXT NOT SET

    Thinking about it, perhaps this code should be in combo1_change and not click. This would show the list, but it would fire if you type in the combo, so it depends what functionality you are after. Dan.
  15. dannyh

    COMMAND TEXT NOT SET

    what about the line : sMyCriteria = DBCombo1.Text this should still be the line direcly above the line : sSQL = "SELECT * FROM EMPLOYEES WHERE [name]='" & sMyCriteria & "'" so what you should have is : Private Sub DBCombo1_Click(Area As Integer) Dim sMyCriteria As...
See more

Part and Inventory Search

Back
Top