Search results for query: *

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

I have some sort of security build into my app. It uses a user table where each user has been assigned a security level from zero (nothing allowed) to 9 (everything allowed). I also have a value for userrights (add, edit, delete, ...) but you say you don't need that. In the menu-table I assign...

A small example to do this. Suppose your listview is called lvwDetail. You use the event click of the listview to trigger the detail editing: Private Sub lvwDetail_Click() '-------------------------------------------------------------- ' Listview 'Detail' clicked...

Maybe you could take a look at the code on this link: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=31479&lngWId=1 It's from the Planet-Source-Code site by a programmer called LaVolpe. I use it in my apps and I'm very satisfied with it. You don't have to use it but you...

You can use the Round Function. It returns a number rounded to a specified number of decimal places. Syntax Round(expression [,numdecimalplaces]) If no decimal places are specified, the function returns an integer. So you could do: Num = Round(Num, 2) which would turn 94,0073844 into...