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: *

  • Users: levinll
  • Content: Threads
  • Order by date
  1. levinll

    Calculating business days between two dates

    I'm trying to get the below formula to work but I keep getting an error message(A loop was evaluated more than the maximum number of times allowed. ). Any help would be greatly appreciated. Local DateTimeVar d1 := {HoursOverDueNoNationalLogistics.DUE_DATE}; Local DateTimeVar d2 :=...
  2. levinll

    Crystal Report Viewer

    I'm trying to upgrade the way I call Crystal from within my VB application, so I can use the Crystal Report Viewer. However, I'm unsure which components/references I need to choose. When I try to run my application I get an error on the following lines of code. Public CrystalApplication As New...
  3. levinll

    Crystal Report and VB

    I'm trying to upgrade the way I call Crystal from within my VB application, so I can use the Crystal Report Viewer. However, I'm unsure which components/references I need to choose. When I try to run my application I get an error on the following lines of code. Public CrystalApplication As New...
  4. levinll

    Searching for a carriage return in a text field

    Somehow a user was able to enter a CR/LF into a text field in one of my tables. I'd like to be able to search the rest of the records to see if this has happened before, but I'm not sure of the syntax I'd have to use. Can anyone enlighten me ? Also does anyone have any idea on how to prevent a...
  5. levinll

    FTPPutFile

    According to the documentation that I can find about FTPPutFile, a return value of 1 indicates that the operation was successful. I was curious whether this means that the correct # of bytes were transferred or that just a file was created based on the passed parameter ?
  6. levinll

    Crystal Reports 8.5 Record Export Limitation

    It appears that I can only export 65,535 records out of Crystal when I choose to export in Excel format. Is this a limitation of Crystal 8.5 or of Excel ?
  7. levinll

    Stored procedure fails when called from VB

    I have a real mystery here. I have a stored procedure that works when I call it from SQL Server Query Analyzer, but returns EOF when I call it from my VB code. I even took the code that makes up the stored procedure and try running that from VB with the same results. Here's the SQL code I'm...
  8. levinll

    Problems with xp_startmail

    I get the following error message when I try to use xp_startmail: Server: Msg 17952, Level 18, State 1, Line 0 Failed to start SQL Mail session. Check the errorlog file in the SQL Server directory for details. What's interesting is that I can successfully send emails when a scheduled jobs...
  9. levinll

    Run-Time Error 430

    Class does not support Automation or does not support expected interface. I have a VB application that's hitting a SQL Server and some of my users are getting this error message. Does anyone have any idea why this is happening ?
  10. levinll

    Trim function in a view

    Is it possible to have the Trim function in a view ? I'd like to remove all leading and trailing spaces in a field prior to it being transferred. I can't use a stored procedure because I'm having the data read directly into an Excel Template using Microsoft Query. Thanks !
  11. levinll

    What does this error mean ?

    All of a sudden I can't connect to my local SQL server database. When I try I get the following error message: Run-time error '-2147467259(8004005)': [Microsft][ODBC SQL server Driver]Cannot generate SSPI context
  12. levinll

    System Temp Folder

    Is there some API call to find out the location of a computers Temp folder ?
  13. levinll

    Formatting a date field in a stored procedure

    I'm trying to compare a date range against a date/time field in one of my tables. The field contains both a date and a time (ie 10/06/2002 8:25pm). However I only want to compare against the date portion of the field. Is there a way to format the field in a stored procedure so I only compare the...
  14. levinll

    Tough SQL statement

    I'm using the below data and I'm trying to write some SQL code so for each uniqueHeader_ID in the table, I only get those records that have the latest date in the EditDate field. For example, for Header_ID #66963 I'd want to get back rows 6,7,8,9, and 10. For Header_ID #66964 I'd want to get...
  15. levinll

    SQL statement help

    I would greatly appreciate it if someone could help me formate the SQL code I need to return only the records I want. Here's the scenario. I have a table that consists of records that contain a integer and a date/time. There can be a one to many relationship between the integer field and the...
  16. levinll

    FTP a file from VB

    I have a VB application that I want to be want to modify to allow it to automatically FTP a file to a remote machine. I know there is the Internet Transfer Control, but the documentation I have on it is sparce. Does anyone have a simple "how-to" description on how to use this control...
  17. levinll

    Kicking off scheduled tasks

    Is there a way to launch a VB application so that only specific code gets run as part of a nightly scheduled job ? I'm coming from a MS Access world where Access had macros that you could launch by making the macro name an argument when you ran Access. Thanks
  18. levinll

    Inserting multiple records in a stored procedure

    I am wondering if there is a way to copy multiple records from one table to another using a stored procedure. Here's an example of what I'd like to do: select * from Table1 insert into Table2 (using records retrieved from above select statement) Table2 has many of the same fields as Table1...
  19. levinll

    Detecting no activity

    I'd like to be able to detect when there's an extended period of no activity when certain forms are being displayed. I know that VB has a timer control that I can set up (though it's max is a minute), but I'm not sure how to determine whether or not any activity has taken place during that...
  20. levinll

    Painless way to convert to SQL Server

    I have a database that at one time was an Access97 database. Ran fairly well in a multi-user environment. However, since switching over to a Access2000 front end, Access97 back end scenario it's slow and unstable. I was wondering if there is a painless way to convert the database to SQL Server ?

Part and Inventory Search

Back
Top