Recent content by heico

What you are doing trying to add a record with the name of the variables as the value for the fields. So right now you are saying that NameID=val1. What you want is NameID=value of val1. So replace you code with : mysql = "Insert into mail(NameID,Description,SubscriptionID,DateReceived)...

I don't know if this is exactly what you wanted, but I think it will give you some ideas: Dim arrColor(3) As OLE_COLOR Dim intCurrent As Integer Private Sub Form_Load() arrColor(0) = vbBlue arrColor(1) = vbRed arrColor(2) = vbGreen arrColor(3) = &H8080FF End Sub Private Sub...

For the first problem, use an array. Something like this dim arrFiles(1) as string arrFiles(0)="Portfolio0.txt" arrFiles(1)="Portfolio1.txt" For i=0 to ubound(arrFiles) Open arrFiles(i) For Input as #1 Close #1 Next I don't think you can start procedures using a...

I can't find your previous post (haven't looked very hard), but I presume this is what you wanted : Dim intHandle As Long Dim strLine As String intHandle = FreeFile Open "textfilename and path" For Input As intHandle Do Line Input #intHandle...

If you use client side, you have to replace the applications for every user if you want to change a query. With serverside you can avoid that problem. Otherwise it doesn't make much of a difference, but I would go with server-side, because it makes your code easier to read, and it's a cleaner...