Search:

i wanna remove errors from attached project, plz help

Thnaks Shuja,
i am using MSSQL2005 but i want this in VB6. Following is the method i am using for excel handling.

Public Function Proc_G3U_Prefix(FileName As String)

Dim oXLApp As...

hi all,
I am again strucked in my project, i have an excel sheet in following format.

Destination |Codes
Pakistan |92,9242,9251,9221
Pakistan-Mobile |92300,92321,92345

I...

is any one who worked on SIP or VOIP softphone project?

Hi Guru's

i have strucked while developing my project and need your help.

I want to show the real time processing result of any DOS command. Forexample if I run copy command over 200 files ...

what about following:

[CODE]
text1.text = "chapter-1/rukoo-1/verse-1"
chlen = InStr(Text1.Text, "/rukoo") - (InStr(Text1.Text, "chapter-") + 8)
rklen = InStr(Text1.Text, "/verse") -...

Hi,



I have a string in a text box (text1.text = “chapter-12/heading-321/verse-41”).

I want to extract the values of chapter, heading and verse as 12,321 and 41 respectively.

Dear Mr Shiekh,

kindly explain, if any example. plz.

Hi All,

Once again i am in a problem. Is there any method to execute heavy sql queries without helding the application. I explain:

Frontend = VB6
Backend = MS SQL Server2000
I have lot of sql...

not wroking with combination of \r \n

Dear Krzemo,

I have installed MSSQL Server 2000 with SP4, but still I am receving following error.

Server: Msg 4866, Level 17, State 66, Line 1
Bulk Insert fails. Column is too long in the...

Can't use "\n\n" because row terminator = "\n" only. also I am confirm (and you will too if you see the attached image) that last row contains extra \n.

If it is not possible in SQL, kindly give...

Hi DB Gurus,

I am using SQL server 2000 and VB6 for my project. In its one module I have to import a raw data from a text file having row terminator = \n and field terminator = TAB. I am using...

Hi DB Gurus,

I am using SQL server 2000 and VB6 for my project. In its one module I have to import a raw data from a text file having row terminator = \n and field terminator = TAB. I am using...

Create a module with folowing code:


Function FileText(ByVal filename As String) As String
Dim handle As Integer

If Len(Dir$(filename)) = 0 Then
Err.Raise 53 ' File not...

Is this possible to send any information /command from mobile to pc using vb and blutooth port. i can connect to my nokia 6600 through a blutooth port and can send at commands to mobile using vb...

working, u r gr8
can we do the same for select quries.

left(text1.text,1) 'Show "T"
right(text1.text,len(text1.text)-1) ' Show text without first "T"

Hi again,

Dear all, I am again in trouble with my project of billing solution.
In my project I have used some update and insert queries which modifies the raw data to calculate some billing...

round(333.6333,0)

You can use instr() and instrrev(), check attached project.

Umar

check this, credit goes to zeem

check the control on http://icxr.com/acmenuex.html

Umar

I have a easiest solution:
If your crystal report is working fine independently (as you said), add these designed report again in your project.
Right click on Project window goto Add>Crystal Report...

Concatenate your 3 text into 1 with any seperator (e.g ',-.) and do the reverse at the server side.

Example:
text3.text = oldpwd.text+","newpwd.text","newpwd2.text"
send text3.text to server and...