 - Home
- Activity Stream
Activity Stream
New Activity ()
Please reload this page to view the 200+ new activity items that have been created.
-
Older Activity
-
Today, 12:58 PM
my test code:
...
Dim cCont As Control, name as string
For Each cCont In Me.Controls.Frame1
If TypeName(cCont) = "COMBOBOX" Then...
0 replies | 2 view(s)
-
Today, 12:54 PM
It's amusing to see anyone recommend the obsolete Chr$() function. It was long ago replaced by ChrW$() when 16-bit VB was left behind in 1995.
4 replies | 55 view(s)
-
Today, 12:38 PM
Hello,
uffffff is very complicate, I've been this morning and there's no way.
I have modified the 'LoadFile' function with the following code,...
6 replies | 2024 view(s)
-
Today, 12:36 PM
First of all, take it easy, we're just talking.
These are the accurate Greek stats, also it's not lies because here they also have spread the...
1990 replies | 125243 view(s)
-
Today, 12:30 PM
From what I saw there were not any other viable alternatives. Some people are saying he should have shot her in the leg or trying to shoot the...
48 replies | 655 view(s)
-
Today, 12:28 PM
Yeah or a trip to India wouldn't be much fun.
I'm with you, I don't understand what post like that are all about. Are they trying to say that all...
1990 replies | 125243 view(s)
-
Today, 12:21 PM
Here's a link in the FAQ on installing VB6 on Windows 10 64-bit
...
3 replies | 39 view(s)
-
Today, 12:10 PM
Yeah, tasers aren't all that great at much distance. Sometimes both prongs don't stick. Pepper spray and tasers are good in a lot of situations but...
48 replies | 655 view(s)
-
Today, 12:08 PM
There are multiple threads on this forum about installing VB6 on W10 also on 64bit.
No need to use custom installers
3 replies | 39 view(s)
-
Today, 12:02 PM
Hello Krool, excellent grid control, what I would suggest is to add very important functions such as:
1.- That you have the option of sorting in...
471 replies | 140051 view(s)
-
Today, 12:00 PM
I get it. Now its working fine.
12 replies | 107 view(s)
-
Today, 11:58 AM
Take a look at https://web.archive.org/web/20210225081003/http://nuke.vbcorner.net/
Hopefully what you are looking for can be downloaded from...
3 replies | 39 view(s)
-
Today, 11:52 AM
Depends on what the lesson of the day is... Most of the time I've seen this kind of exercise, it's in dealing with multiple loops. It's often...
4 replies | 55 view(s)
-
Today, 11:47 AM
Hi,
I found lots of info that doesn't work on my PC (64 bit) and current version of Win 10.
There a series of links to 'Giorgio Brausi Visual...
3 replies | 39 view(s)
-
Today, 11:38 AM
Another option could be to use a string and the Left$() function
above the loop
MyString="ABCDEFGH"
in the loop
Print Left$(MyString,i)
no need...
4 replies | 55 view(s)
-
Today, 11:37 AM
The suggestion to use "In" wasn't intended for you to then keep the rest of your SQL statement exactly as it was in your first post.
If you use...
12 replies | 107 view(s)
-
Today, 11:23 AM
The danger though is if your code depends on fields being in a particular position. By using * you can't be guaranteed that fields will always be in...
12 replies | 107 view(s)
-
Today, 11:21 AM
MS Access
SELECT * FROM Archief WHERE Id=1 Or Id=2 Or Id=3 Or Id=4 Or Id=5 Or Id=6 Or Id=7 Or Id=8 Or Id=9 Or Id=10 Or Id=11 Or Id=12 Or Id=13 Or...
12 replies | 107 view(s)
-
Today, 11:15 AM
What is in the variable sql when it happens?
What database system are you running this against?
12 replies | 107 view(s)
-
Today, 11:06 AM
Still returned the same error:
sSQLMissing = "SELECT * FROM Archief WHERE Id In (" & sql & ") ORDER BY ;"
12 replies | 107 view(s)
-
Today, 11:00 AM
I never really tested it, I just write out the fields I need
12 replies | 107 view(s)
-
Today, 10:59 AM
Yeah, that's a good point. Still, I've always felt that the Italians can swear better than we can.
24 replies | 480 view(s)
-
Today, 10:58 AM
Slightly different approach
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
'test
Static...
7 replies | 217 view(s)
-
Today, 10:55 AM
I did a bit of testing on that, and it isn't always going to be true. If you are getting a bunch of fields that you don't need, then that is a waste,...
12 replies | 107 view(s)
-
Today, 10:54 AM
Use IN:
https://www.w3schools.com/Sql/sql_in.asp
Build up your array of values rather than concatenating a bunch of OR statements together. It...
12 replies | 107 view(s)
-
Today, 10:54 AM
well using "Select *" is never a good idea, you are selecting all the field in the Table
but here you go,
see if this works, I didn't test it
...
12 replies | 107 view(s)
-
Today, 10:44 AM
sp_executesql is all lower-case. Don’t get bitten by case-sensitive MSSQL instances because of wrong system names casing (like sysname data-type is...
10 replies | 121 view(s)
-
Today, 10:35 AM
That's not possible in my case since the records are selected based on some criteria:
If Not File.Exists(sArchive & sDoc) = True Then
...
12 replies | 107 view(s)
-
Today, 10:33 AM
You need a Collection of AddressOf pfns keyed on procedure name as string and DispCallFunc which might be more expensive than a giant Select Case...
3 replies | 104 view(s)
-
Today, 10:32 AM
I would use a BETWEEN clause ( WHERE ID BETWEEN (X and Y) )
12 replies | 107 view(s)
|
Click Here to Expand Forum to Full Width
|
