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 derfloh 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. Merlijn

    stepping through table rows

    It's VB6 Pro from the Visual Studio.
  2. Merlijn

    stepping through table rows

    I made a small example: Set rs_Recordset = New ADODB.Recordset str_Sql = "select * from tbl_MyTable" str_Sql = str_Sql & " where (selectData = '" & !MyDbField & "')" rs_Recordset.Open str_Sql, cn_MyDataBase, adOpenDynamic, adLockOptimistic If Not (rs_Recordset.BOF And rs_Recordset.EOF) Then...
  3. Merlijn

    stepping through table rows

    In human language, because I don't have an example at hand. Define a recordset and a "SQL select" command and open it. Check for the recordset NOT to be ".BOF AND .EOF", which would mean there are no records. Use movefirst to go to the first record of the recordset. Loop over the records in the...
  4. Merlijn

    Converting an old XP VB6 program to run on Windows 7 & Windows 10

    VB6 runs very well on a Windows 7 or 10 machine. So you could install the VB environment on the newer Windows if you want. I would suggest you do install it on your computer, be it a Windows 7 or 10, that doesn't matter. Just make sure you have all components you need in the right spot. I have...
  5. Merlijn

    connecting to mysql database

    Emily, I'm using a mySQL database too from within VB through ADO. This is the connectionstring I'm using: Provider=MSDASQL;Driver={MySQL ODBC 3.51 Driver};Server=localhost;Port=3306;Option=131072;Uid=MyID;Pwd=MyPWD;Database=myDB As you can see the option is quite different from what you are...
  6. Merlijn

    How to fill several comboboxes in a frame with Form_Load()

    Use errortrapping. Not all controls have the same properties and methods. There must be a contyrol on your form/frame that doesn't support the statement you're using. When you debug the code, you will be able to determine which control is generating the error by using a watch on ctl. I met with...
  7. Merlijn

    Send Email From VB

    BiggerBrother, the machine you are using vbSendMail on does not have to have an e-mail account set up. The mailserver does. You can use any account that is known on the mailserver from any machine that is connected to it. I use vbSendMail on a server where there is not one e-mail account...
  8. Merlijn

    Send Email From VB

    To TheVampire: vbSendMail does NOT use Outlook. It is a standalone dll for e-mailing. To Sophie19: You could use rtf-formatting in a richtextbox and then transfer the contents of the rtbox to Outlook's bodytext. Or, you could try using html-formatting. Outlook supports both rtf and html. The...
  9. Merlijn

    Send Email From VB

    Sorry, error in naming: Private Sub SendMail_... should of course be: Private Sub poSendMail_... Merlin is the name, and logic is my game...
  10. Merlijn

    Send Email From VB

    I see you declared the subs: Private Sub poSendMail_SendSuccesful() MsgBox ("Mail Sent OK!") End Sub Private Sub poSendMail_SendFailed(Explanation As String) MsgBox ("Mail Failed!" & vbCrLf & Explanation) End Sub Try declaring those as well: Private Sub...
  11. Merlijn

    Send Email From VB

    I agree with StuH. I also use the vbsendmail.dll and it works like a well oiled machine! You can send mails in ascii or html format, with or without attachments, to a single or to multiple addressees. Good stuff! Merlin is the name, and logic is my game...
  12. Merlijn

    How to read a text file like this with vb???

    Maybe the soft that creates the file also maintains a parameter file where it stores the width of each field. If you can find and read that parameter file, you can use the sample app replacing the fixed lengths with the ones found in the parameter file. Just a thought. I did the same trick with...
  13. Merlijn

    How would you set up a program to close itself at a specific time

    Oh yes, don't forget to set the batch-file properties to close the window when finished. Otherwise you end up with some instances of the batch-file, all ended, on your taskbar. Merlin is the name, and logic is my game...
  14. Merlijn

    How would you set up a program to close itself at a specific time

    I allso have my last version of the program on the server in a shared directory. But to prevent locking by any user, I don't let them run the program of the server, but I use a batch-file (remember DOS?) to copy the exe-file from the server IF a newer version than the current is found. That way...
  15. Merlijn

    uninstal vB

    Check if you have administrator rights. When installing, some registration activities need admin rights. Install for all users, so that all ocx's are availlable for every user. Hope this solves your problem.
  16. Merlijn

    DataGrid. Assign a different ToolTipText for each row

    You could do this with an array of tooltips. If you have some sort of id number in the grid starting from 0 or 1, you could add the full info into the corresponding array-element. When the pointer moves over the grid, get the id, copy the array-element into the tooltip property and the full info...
  17. Merlijn

    Email customers from database?

    Use following link to find vbSendMail http://www.freevbcode.com/ShowCode.Asp?ID=109 Merlijn is the name, and logic is my game...
  18. Merlijn

    Email customers from database?

    fatboy2, that is exactly the reason why I suggested vbSendMail. It is free, can send and receive mails with or without attachments. I use it in the administration program that I'm extending at work. Works quite well actually. Merlijn is the name, and logic is my game...
  19. Merlijn

    Email customers from database?

    You could use the vbSendMail.dll Search the internet for it. It comes with examples. Very handy if you do NOT use M$-Outlook. Because if you don't, you haven't got outlook.dll. Merlijn is the name, and logic is my game...
  20. Merlijn

    datagrid sorting...

    Try this one: Option Explicit ' Declarations ' ============ Private byt_ColSort As Byte ' Holds the number of the column that was last sorted ascending. ' byt_ColSort can have a value from zero to 255, ' so the sub can handle up to 255 columns. ' In case more are needed, change the type to...

Part and Inventory Search

Back
Top