Thanks Choke
I found that there is many dlls or ocx in Win98 which need to update or register in order to run the VB6 Exes, I face one time the other system can't be run after I had deployu the whole CAB into that client.
For your idea it was centerlise at server but how about the Exe just for...
Hi Friends! I might interested to know the reason why during install at client PC it crash the system files like dll from the client.
I might have Windows 98 or XP but I really worried of this the other system in client PC cant be open, how to prevent this?
What is the only neccesary files we...
Hi George,
Sorry for my mistake it actually works just I place a wrong part in my statement.
But any how is ther any possible way to insert this single quote ' into my sql statement and I can insert into my database? instead of I replace it to another quote?
Thanks
Vincent
Hi George,
There still same without any changing! and I try to replace with * or space but it seems like not working too.
By the way where you found this code? Thanks
Vincent
Hi All,
I face the same problem where my record show for example ANNUAR BIN SA'AD
For the test include the ' sign it will generate an erro while insert into statement, how to handle this problem?
textbox1.text = "ANNUAR BIN SA'AD"
ConSql.Execute "INSERT INTO TABLES(NAME) VALUES('" &...
Hi all!
I'm using Crystal 4.6 and VB6, the first record always missing when it come to prview or print, why?
Private Sub CmdPROCEED_Click()
CR1.SQLQuery = "Select * from CUSTOMER_FILE"
CR1.Action = 0
End Sub
Hi there, I'm currently using Macola. I'm facing below error in my server:
Severe COM/ADO error occured in MacMss.dll
DB Provider Error:Native Error number:0
Error number:0x80004005
Connection failure
COM Error:Error
Code =Ox80004005
Code meaning = Unspecified error
Source =Microsoft OLE DB...
HI I still facing the same problem on it and Matt can u explain in detail how to do this? I have Crystal 8 with VB6 and facing same problem during prin or view.
Hi 1100
thanks for your help but it's look dosent help my app, but i feel there is something form_deactivated function can be call where fire at the even handler, do you have any idea on this?
As every application should havea search procedure where most of people create it as class and just call it when its needs.
I try to create a form with search feature and it contains datagrid and text box, the user will need to input the text and the grid will show the record which similar with...
Great Expertise!
I have mainform and childform and I have datagrid in my mainform where adodb in childform for update, I need to refresh my mainform datagrid when child form been upload.
How do i detect in mainform when my childform been unload? and I will fire some function in my mainform...
...in some control or even where it helps to show up the record which using statement LIKE in sql, someting like when user type in C it goes to LIKE "C*" and if CA then come to LIKE "CA*" and etc..
When this state capture it will show all the records which is LIKE "C*" in the listbox, I beleave...
...Case 97 To 122: KeyAscii = KeyAscii - 32
End Select
Char = Chr(KeyAscii)
Set RSSQL = New ADODB.Recordset
RSSQL.Open "Select * from Table_FILE where itemcode like '" & Char & "*'", , adOpenDynamic, adLockOptimistic
Set DataGrid.DataSource = RSSQL
DataGrid.HoldFields...
Hi All, I have a question here and need your advice, I have a textbox which enable multi-line, I have key key few line of the text but I want to program it maybe just capture the first line to field 1 and second line to field 2.
Thanks
Hi CCLINT & ANDY, your are great.. and thanks for your help, as Andy mention for Tabbed Dialog control, is this actually is a component which need to be add in? or is just need program coding?
How ever, I would like to try SSTab control and may any one kindly please teach me how to add in this...
Hi CCLINT, is that mean we only able to change the property of the second tab in property pages?
So this will be as Andy what he mention for to use is the Microsoft Tabbed Dialog Control which allows me to place controls on each Tab at design time but how to use Microsoft Tabbed Dialog Control...
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.