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 derfloh 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. sharonc

    Search for acronym

    Using ASP and SQL Server. Is it possible to search a field using an acronym such as BFP and find Boiler Feed Pump without hardcoding BFP into the table?
  2. sharonc

    Command text was not set for the command object.

    I found out what the problem was. I was trying to you a variable in my select statment that didn't exist. Thank you for your help.
  3. sharonc

    Command text was not set for the command object.

    Yes, it gives me an error when I try to write out the value of rs.Source.
  4. sharonc

    Command text was not set for the command object.

    Hi Sheco, When I put the Response.Write in, it gives me the error: Command text was not set for the command object for the rs.Open() line. Thank you for replying so quickly.
  5. sharonc

    Command text was not set for the command object.

    Hi, I am getting this error: Command text was not set for the command object. /projects/Maintenance/search_results.asp, line 42 <b>Can someone tell what is wrong</b> <b>Here is my code:</b> <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include file="../Connections/rs.asp" --> <% Dim...
  6. sharonc

    how do I create this report

    I need to create a report that looks like the following: It has a header section and then two identical forms follow it: Header section labid: AZ0515 Form1 storet: 00094 sampling date1 9-13-2003 results1 sampling date2 10-13-2003 results2 sampling date3 11-13-2003 results3 Form2 storet...
  7. sharonc

    reports won't print using viewer

    I am using Visual Basic 6 front end with SQL server 2000 backend. I'm using Crystal Reports 10 for my external reports. When I run my report, there is either minimal data or no data in the report. If I get out of the vb program and double click on the external report, the data is there. Can...
  8. sharonc

    template screwed up

    Thank you for your help. I will give this a try. Thanks so much you just saved my fingers from retyping the entire template.
  9. sharonc

    template screwed up

    I created a website using a template. Everything has been working good, but now my template is screwed up. My webpages that use the template are fine because I haven't updated the webpages. Is it possible to take one of the pages that are ok and create a new template?
  10. sharonc

    #Name?

    Thank you
  11. sharonc

    #Name?

    I want to print every row in the table. There are 14 rows. How do I print all rows?
  12. sharonc

    #Name?

    Can someone tell me what is wrong with this code? I get #name? on the report instead of the data. 'Load File Header Record 10 to the report strSQL = "Select * from tbl_Rec10;" Set rs = db.OpenRecordset(strSQL) rs.MoveLast rs.MoveFirst For Cntr = 1 To rs.RecordCount...
  13. sharonc

    assign table data to unbound report field

    Thank you, I'll give that a try.
  14. sharonc

    assign table data to unbound report field

    I have a table in my database that I want to read and then write the data of a field from the table to an unbound field on the report. Can this be done?
  15. sharonc

    force new lines for dates

    Thank you, I will give this a try.
  16. sharonc

    force new lines for dates

    Question: Is there any way below to make 09/10/03, 12/05/03, 04/15/04 start on new lines. I have a MS Access database as the front end, SQL Server as the backend. I have a popup action field created using 'go to Detail Page' that displays as follows: 08/05/03 - A team consisting of Safety...
  17. sharonc

    popup message on index page open

    The body tag is part of the template used for all pages, so if I put the onload on the body tag, it will open on every page. Any suggestions?
  18. sharonc

    popup message on index page open

    I have a message that I want to popup anytime someone opens my home page. Can someone tell me how to do this.
  19. sharonc

    not all requested data displayed

    No I don't have On Error Resume Next
  20. sharonc

    not all requested data displayed

    I see no difference in the fields that are printing and the fields that aren't printing. If I place 6 of the above fields on the page, they display. If I add a 7th field, it doesn't display. If I remove the 6 fields and place the last two fields on the page, they display the data. any ideas? Is...

Part and Inventory Search

Back
Top