Type: Posts; User: gibra
Search took 0.05 seconds.
Private Sub Command1_Click()
Form2.Show , Me
Remember that, in this case:
You should use a launcher.exe which:
1 - update your application.exe
2 - launch application.exe
The should be post on VB.NET forum, not here.
What to do with Visual Basic 6.0?
SQL Server connection strings - ConnectionStrings.com
there are many sample for Express version.
If NumFiles = 0 then
'// message not found
In your code, you 'force' the user to remember the complete filename and path.
A good practice suggest to use a CommondDialog component with ShowOpen method that allows the user to search and...
"C:\users\...\destkop\archive (23-06-2015 11:32:00).bck"
isn't a valid filename.
should use something like this:
"C:\users\...\destkop\archive (23-06-2015 11_32_00).bck"
It is a very old and well-known issue.
The topic has been discussed many times on the forum.
You have seen how the error handling is important, and that is not an error of the...
Then Whats is your problem?
I did not understand if you do not use error handling only in this form, or if you do not use it ever.
Maybe can be useful insert it into form, maybe it could give you some help.
Who knows ...
First you have to set the correct parameter of MyRecSetF48 recordset.
MyRecSetF48.CursorLocation = adUseClient
MyRecSetF48.LockType = adLockPessimistic...
In your code, you wrote:
'/ prev code
cmd.CommandType = adCmdText
Set MyRecSetF48 = cmd.Execute
'/ other code
Probably the query is wrong.
Yes, I agree.
This is because I've ask the TYPE of DIM <name> AS ...
x1Id = FlexReport.TextMatrix(fRow, 0)
What Type is x1Id ?
Dim x1Id As .... ???
In the form you have added error handling?
Why you close MyCon if is open?
Doesn't close MyCon, it should still open.
In Private Sub CrossTab_Click() event you should use MyRecset, instead of MyCon.
WOW!!! You are the best about copy & paste:p
It seems that the ssdw3b32.ocx component suffers from many problems, at least reading this forum:
Data Widgets Forum
but there are some...
In your code I don't see any LoadPicture() statement. :confused:
So I wonder what it means for you:
- open the file
- get the current line
- append the new into line
I have shown you the code structure.
You do not see the statement Debug.Print?
New to this statement?
You do not expect me to write all the complete code ?
Set the FileName property of CommonDialog before to open it.
I think the code should be like this:
Private Sub cmdNext_Click()
Dim i As Long
For i = 0 To List1.ListCount - 1
If GetAttr(List1.List(i)) = vbDirectory Then
Then remember to mark the topic as RESOLVED (on Thread Tools link)
SELECT SUM(CountByGroup) AS SumOfGroups FROM
select count(*) AS CountByGroup from #ZZ_MIDSALES
where WGROUP_strDescription ='TICKET BOX'
You can use ADOX (Ado Extensions) :
- Download ADO 2.8 SDK for a complete guide.
Download Microsoft Data Access Components (MDAC) 2.8 Software Development Kit from Official Microsoft Download...
To choose a directory you can do with this:
' BROWSEFORFOLDER: a simple way with no extra capabilities.
Dim sMyDir As String
Const ssfPERSONAL = 5
On Error Resume Next
SQL: INSERT Statement
You need do download and install the appropriate ACE driver (for each computer).
Since the improvements are mainly for MS Access environment, and have no influence on the use 'outside' of the...
Read better the initial post.
He don't get error 438, get a blank page.
In addition, the ShellExecute API function can be used even if not using Adobe Acrobat, but with any...
The problem you are referring to is completely different, has nothing to do with this discussion.
Your query contains a lot of errors.
SQL engine doesn't support:
- double quote (only single quote),
- & char (use +, instead)
So your Duration should be like this:
We don't know as you are coded your project.
You can download my source code here:
PDF in VBForm with no OCX/DLL (late binding) both VB6/VB.NET...
1. Uninstall vb6/vs6
2. Remove all vb6/vs6 folders in Program Files
3. Remove all Registry entry related to vb6/vs6
4. Restart pc
5. Re-install vb6/vs6
You can also use my tool VS6...
of course isn't a problem of my web site, otherwise they would not have 36,953 downloads.
I use KIS 2015 (Kaspersky) with no problem.
Try to disable your antivirus, first.
Windows 8.x and Windows 10 too.
You can try my tool (need original CD's, of course):
Click Here to Expand Forum to Full Width