An example will do it.
This is a sp with only one parameter (integer) but is easily extended.
Dim lCmd As New ADODB.Command
Dim lP1 As New ADODB.Parameter
lCmd.CommandText = "sp_BorrarRecibosVenta"
lCmd.CommandType = adCmdStoredProc
lP1.Type = adInteger...
This is a question every vb programmer asks some time :-)
Add this line to a module:
Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long)
And then use the function enywere in your program
ex:
Sleep(10000) ' This will make app sleep for...
Hi. I have this in my program:
Public Declare Function CopyFile Lib "kernel32" Alias "CopyFileA" (ByVal lpExistingFileName As String, ByVal lpNewFileName As String, ByVal bFailIfExists As Long) As Long
Public Declare Function GetLastError Lib "kernel32" () As Long...
Hi, I've made this to make it more easy. You just send the report, the name of the parameter (it is key sensitive), the value you want to set and the type of the parameter.
It cycles through the parameters collection untill it finds the one you are passing.
Claudia
Sub...
Hi, to do that I think the best is to create a temporary table with the results of the query and then display data in the dbgrid. To update the table, you must set the property allowupdate to true. If you want one field to be modified, just lock the others like this:
DbGrid.Columns(1).Locked =...
Hi, I'm working with VB6 and Crystal Reports 8.5. I need to know how can I tell the printer something like "condensed mode now" to print reports with printer-condensed-fonts. The reports where made with printer fonts.
Thank you
Hi....
If you are using win9X or winME machine, this may be caused cause because of a lack of memory.
It used to happen to me when I had the vb running, the query analyzer, the sql server control manager, Edit pad....
Try rebooting and shutting down appps you are not using.
Hope this helps.
Daniel
Hi.
I need to know if my vb6 program is running from the vb environment (using the run command or the F5 key) or if it is running from the exe file.
Is there any way to know it?
Thank you very much
Daniel
Hello!
I want to write an activeX control, which would be used in a vb6 environment.
What I want is to quit the complete program execution when a certain condition happens.
Is this posible? I think the guys from dev-soft did it when their control is shareware and you press a button in their...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.