Search results for query: *

Hi I am install MSDE 2000 using SQL authentication in windows XP. After that install SQL server client tools then Database will automatically open in that client tools without providing user name/ password. How can I stop it? thanks in advance maii

Hi there, I am using VC++ front-end and SQL 2000 Backend. Sometime I faced the following Error while executes SQL statement. “Communication Link Failure.” How can I solved the problem Thanks maii

Hi there, I am running few crystal reports through VB6 and Crystal report Control. Is there any way use Mouse wheel in those reports ? Thanks Maii

Hi there, following code had some problem while using Double data type if i use currency data type it OK Private Sub Command1_Click() Dim a As Double Dim b As Double a = 4911399.08 a = a + 446192.58 a = a + 73490.23 b = 5431081.89 If a <> b Then MsgBox...

Hi there, I am facing following runtime error while delete some rows from Table ABC Run-time error ‘-2147467259(80004005)’: [Microsoft][ODBC SQL Server Driver][SQL Server] I/O error (bad page ID) detected during read at offset 0x0000000077a000 in file ‘C:\Program Files\Microsoft SQL...

Hi, Is there any function to read registry Key in SQL 2K? Thanks Maii

The code shows assign, but should be not assign

But how can i validate it Private Sub Form_Load() Dim a As String * 10 If a = vbNullString Then MsgBox "Not Assign" Else MsgBox "Assign" End If End Sub Thanks maii

Hi there, What is the initial value of the following string? Dim strTemp as String * 10 Thanks maii

Hi there, I have developed a module for print continues sheet Printer.CurrentX = 100 Printer.CurrentY = 200 Printer.Print “Text1” Printer.CurrentX = 200 Printer.CurrentY = 300 Printer.Print “Text2” Printer.EndDoc But after print the doc all paper eject by printer. Is there way to stop it? I...

Thanks Alasdair its working fine maii

Hi, I am creating a login Dialog using ASP.NET and VB.NET. when login user for second time user name and password display in history list. How can I remove User Name and password history from a Login dialog? Thanks in Advance maii

Based on Bob Hints i wrote following function Private Function strcvtNumber(ByVal strNumber As String, ByVal lngTotalCount As Long) As String() Dim lngLoop As Long Dim strChar As String Dim lngLast As Long Dim strRight As String Dim strLeft As String Dim strNumeric As...

Hi there, I need a VB function like as below If user entered A-001 then next number will be generate like below A-002 A-003 A-004 A-005 If user entered 0001 then next number will be generate like below 0002 0003 0004 0005 If user entered X05P then next number will be generate like below...

Print #1, "put test.txt ftptest.txt" Change the source file name becuase that file open while tranfering and change the FTP argument like below ftp -v -n -i -g -s:test.txt myhost thanks maii

I have following sample table Item Qty Date Running Qty A 1 01-01-2005 1 A 2 01-02-2005 2 A -1 01-02-2005 2 A 3 01-03-2005 5 Need a trigger which update running Qty using sum of Qty based on Date and Item

I have build SQL query using OR operator Such as SELECT COMPNAYNAME FROM CUSTOMERS WHERE (CUSTOMERID = ‘AAAAA’) OR (CUSTOMERID = ‘BBBBB’)............. It has been fail when I add more then 180 OR operators. Are there any limitation and alternate solutions? Thanks in advance maii

Is there any way execute Linux process from windows machine using VB code. thanks in advance maii

Correct Code ========== Option Explicit Dim mcnAP As Connection Dim mrsVendors As Recordset Private Sub Form_Load() Set mcnAP = New Connection Set mrsVendors = New Recordset mcnAP.CursorLocation = adUseClient mcnAP.Open "Provider=Microsoft.Jet.OLEDB.3.51;" & _ "Data...

thanks J. Kusch If the database in machine A and I run the script or SQL-DMO code from machine B the backup file is copy in machine A rather then machine B. how can the backup file copy in machine B? Thanks maii