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!

  • Congratulations SkipVought 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. peggasus88

    Microsoft VBScript runtime error '800a0046' Permission denied

    Is there a way to write to a file on a network share drive (like \\ServerName\ShareName\FileName.txt) without using MapNetworkDrive? Anonymous users will be accessing my site and I won't know the which letter drives they have used or not used. I don't want to re-map their already mapped drive...
  2. peggasus88

    Text Fade In WITHOUT Keyframes In MAIN TIMELINE?

    Hi. It's 4 AM but I am determined. :) How do you make text fade in WITHOUT adding keyframes to the MAIN TIMELINE (so that the main timeline has just one frame) ? Someone mentioned a two layer movie in another post, but did not explain how to do it. I tried the following to do a 20-frame...
  3. peggasus88

    A Way to Place Focus on a DTC Button So That...?

    Thank you Merlin! Changing the button to an Image works great. I misinterpreted your suggestion a couple months ago, but now that I'm more familiar with VI, I understand. :) Do you happen to know if it works for IE 6.0? (It works for IE 5.0.) My co-worker has IE 6.0 and hitting 'Enter' on...
  4. peggasus88

    Grid DTC Navbar / Vertical scroll

    Hey 'computergeek' Just letting you know that I still haven't found a solution, but I am going to try Merlin's suggestions later. :) -- Peggy --
  5. peggasus88

    Grid DTC Navbar / Vertical scroll

    Hi. Thanks for writing back. I was looking for something just like this! One question: Say I have a grid with hundreds of records and I scroll all the way down to select a row near the end...when I click on the anchor, a server round trip is made and the scrollbar jumps back to the...
  6. peggasus88

    Tricky SQL SELECT Statement...Please Help.

    Yeah, I'm getting: [Microsoft][ODBC SQL Servcer Driver][SQL Server]Column 'ForecastDemand.Qtr' is invalid in the select list because it is not contained in either an aggreagate function or the GROUP BY clause.
  7. peggasus88

    Tricky SQL SELECT Statement...Please Help.

    I'm so happy it's working! I tried all of your suggestions because I want to learn as much as possible. I'm not at the stage where I know which implementation is more effecient...I guess that comes with experience. :) I do have a question about using the view...SELECTing * FROM vToMakeQty...
  8. peggasus88

    Tricky SQL SELECT Statement...Please Help.

    Hi again. :) When I try to run Terry's query, I get the following error: [Microsoft][ODBC SQL Servcer Driver][SQL Server]Incorrect syntax near the keyword 'SET'. I feel kinda dumb because I can't find the keyword 'SET' anywhere! Also, I'm going to have to do some studying up on INNER JOINs...
  9. peggasus88

    Tricky SQL SELECT Statement...Please Help.

    Hi. Yeah! I'm getting the correct numbers for the 'Need'. The numbers for 'Useable' still aren't correct though. I forgot to mention that the two tables aren't related via their ProjectGroupIDs. I guess they're not really related at all. A test card belongs to a project group, but when...
  10. peggasus88

    Tricky SQL SELECT Statement...Please Help.

    Sorry, 'Quarter' in the *ForecastDemand* table should be 'Qtr'.
  11. peggasus88

    Tricky SQL SELECT Statement...Please Help.

    My database tables: * TestCardInfo * <- Table Name - BarcodeNumber (int) <- Primary Key ProjectGroupID (int) ProductName (nvarchar 10) BoardRevision (nvarchar 5) ReworkLevel (nvarchar 5) Status (nvarchar 20) Comments (nvarchar 255) * ForecastDemand * - ProjectGroupID (int) - Quarter (nvarchar...
  12. peggasus88

    Stored Procedure to Select AND Return a Value?

    Thanks for the help! Yeah, I was thinking about it incorrectly, and I have now gotten it to work.
  13. peggasus88

    Stored Procedure to Select AND Return a Value?

    Hi 'bperry', I'm not getting the error message anymore, but I am getting an unexpected return value of '0'. In my code, I am simply trying to set a variable value to the return value of the SP. I might be calling the SP wrong? Can you please show me some code snippets to call a SP that...
  14. peggasus88

    Stored Procedure to Select AND Return a Value?

    Hi, Newbie here. :) Can someone please show me how to SELECT a value and RETURN that value in the same stored procedure? My stored procedure: Alter PROCEDURE spGetQuarter_byDate @Date datetime, @Quarter varchar(20) Output AS Set @Quarter = (SELECT Quarter FROM Quarters WHERE @Date...
  15. peggasus88

    Hyperlink within grid

    Me again. :) I modified MerlinB's Delete hyperlink code to an Update hyperlink that basically updates a recordset (Read his FAQs! They are incredibly helpful and easy to follow!) This hyperlink is used in an editable grid. Is there way a way to do field validation after clicking on the...
  16. peggasus88

    A Way to Place Focus on a DTC Button So That...?

    Hi everyone, I have a simple page with one Textbox DTC, one Button DTC, and one Grid DTC. When I enter a value into the textbox and then click the button, the grid displays a record corresponding to the textbox value. This page will be used repeatedly and for the sake of user friendliness...
  17. peggasus88

    Submit &amp; Reset the Form Using Images?

    Hi 'Einstein47' Thank you so much! I really was going to go mad. =) I chose Method 2 because it looked interesting. =) Works great. Thanks again.
  18. peggasus88

    How to Write an Error Handler for a Specific Error?

    Hi everyone, Thanks for the helpful input. Can someone direct me to a resource that has a list of errors and their error numbers? Or maybe a way of determining the error number? I don't believe the error number would be '80004005' for my 'Violation of PRIMARY KEY contraint' since I always...
  19. peggasus88

    How to Write an Error Handler for a Specific Error?

    Hi, I purposely entered a primary key value that already existed in my database table and as expected, I received the error below. I would like to pop up an alert box to the User, rather than have them redirected to such a scary error page. =) I would like my alert box to be specific and pop...
  20. peggasus88

    Submit &amp; Reset the Form Using Images?

    Hi, I have a very simple form, consisitng of just a textbox for the user's ID number. I would like Submit and Reset images that have the same functionality that buttons of type=&quot;submit&quot; or type=&quot;reset&quot; have... The FORM tag: <form action=&quot;CheckLogin.asp&quot...

Part and Inventory Search

Back
Top