Search results for query: *

Hi, I am using VB 6 and SQL Server. Why do i get this run time error. What does it mean? Run-Time Error '-2147467259 [80004005]': [DBNMPNTW] Specified SQL server not found. I am using WIN 2000 on my server as well as my m/c. No problems. Everthing works fine. But on the client side, they use...

Hi, Why do i get this run time error. What does it mean? Run-Time Error '-2147467259 [80004005]': [DBNMPNTW] Specified SQL server not found. I am using WIN 2000 on my server as well as my m/c. No problems. Everthing works fine. But on the client side, they use Win NT 4.0 server and win '98...

Hi, Am sorry, but i still get my record count to be zero.

Hi, I have this Query SQl = "Select * from IncidentReport Where ITime = '8:58:00 AM'" And i have a record to match the comparison. But i still get the record count to be Zero. How do i do time comparisons?

Hi, I need to print reports for my project. For this i am setting Datareport1.printreport true. But when it come to this statement it shows a dialog to to confirm the printing process. I don't want the user to select "Print" to begin, i want the report to just start printing...

Hi, I get this error in the design environment. With the degugger i see that the trace passes datareport1.show and at my next stmt is "end sub". This is where it throws me the error. I worked on this report about 2 weeks ago, when i was developing it. It waorked absolutely fine. I have...

Hi, I am trying to show a datareport. After i execute the command datareport1.show, why do i get this error "The instruction atc "0x1f326bic" referenced memory at "0x00000000". The memory could not be read". Some reports are shown without any problem and some show...

hi, Try this Dim cRS As New ADODB.Recordset Dim cSQL As String cRS.CursorLocation = adUseClient cSQL = "Select * From Customer_master Order By Customername " cRS.Open cSQL, DSN, adOpenDynamic, adLockOptimistic cbo.Clear Do While Not...

Hi, I am trying to show a datareport. After i execute the command datareport1.show, why do i get this error "The instruction atc "0x1f326bic" referenced memory at "0x00000000". The memory could not be read". Some reports are shown without any problem and some show...

hi, Thank you for the SQl, but i am using SQL server. Are there any other alternatives i can use.

Hi, I am trying to get this SQL. I have a table with the following fields ID, Date, day1, day2 Day3, day4, day5 The values of the fields day1, day2, day3, day4, day5 can be the following: "c", "e", "k", "o" If i have two records with values Rec 1...

Hi, What type of grid can then be used to edit fields?

Hi, Ya, i would love to see the project. Please send me the code at jyotiis@yahoo.com Thank you for the help.

Hi, I am trying to use MSFlaxGrid. I am through adding data to the grid. Now i want to be able to edit a single field in the grid. How do i do it? My grid is in a read only mode. I want it be in read/write mode.

Hi, Thank you so much. I missed out putting in the length of the field.

Hi, How do i use highlight the contents of the textbox, when on getfocus event? I tried using SelStart and SelLenght, but am unable to get the results. Thans for the time taken to help.

hi, thanx Elysium. I had reset my connection string as you said. Thank you for the help.

Hi, Yes i have my connection well instantiated. I am able to open other types of queries, like select or any type of joins. I have problem only with this query.

Hi, I have this code. At Rs.open stmt i get the error saying "Runtime - error Invalid SQL statement; expected 'Insert', 'delete', 'pprocedure', 'select' or 'update' " Dim RS As New ADODB.Recordset Dim sql As String RS.CursorLocation = adUseClient sql = "SHAPE {SELECT * FROM...

Hi, I want to be able to create and delete a database with some tables dynamically through my VB program. I am using this code to create a database Dim DataDir As String Dim ws As Object Dim db As Object DataDir = App.Path & "\Client.mdb" Set ws = DBEngine.Workspaces(0) Set db =...