Search results for query: *

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

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

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

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

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 ?

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 ?

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

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

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 ?

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 !

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

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

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

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

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

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

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

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

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

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 ?