Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. simran1

    Run-Time Error '-2147467259 [80004005]'

    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...
  2. simran1

    Explain this run-time error

    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...
  3. simran1

    SQL - Time Query

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

    SQL - Time Query

    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?
  5. simran1

    Print Reports

    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...
  6. simran1

    Why does this error come up?

    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...
  7. simran1

    Why does this error come up?

    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...
  8. simran1

    How to display data in combo box ?

    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...
  9. simran1

    Why does this eooer occur?

    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...
  10. simran1

    SQL Help

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

    SQL Help

    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...
  12. simran1

    MSFlexGrid?

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

    MSFlexGrid?

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

    MSFlexGrid?

    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.
  15. simran1

    Highlight Text Box on GotFocus Event

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

    Highlight Text Box on GotFocus Event

    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.
  17. simran1

    Hi, I have this code. At Rs.open

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

    Hi, I have this code. At Rs.open

    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.
  19. simran1

    Hi, I have this code. At Rs.open

    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...
  20. simran1

    Create and delete database

    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 =...

Part and Inventory Search

Back
Top