Search results for query: *

I am doing something wrong with my query string because I continuously get a message similar to: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','. /User_Info/processChanges.asp, line 15 When I hit...

I am receiving this error on my ASP pages: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E0C) Command text was not set for the command object. /admin/exceptions/voyg/report.asp, line 61 I only added one small thing so I don't understand why its freaking out on me. Any ideas?

I have an .asp page - when the user clicks the link to delete it brings them to yet another .asp page where at the end of the delete code I have a redirect statement. Yet it doesn't seem to be liked. This is the error I receive. Why? Response object error 'ASP 0156 : 80004005' Header Error...

I am getting this error when I try to run my ASP page: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /admin/tradeexecutions/lib/voyager.inc, line 26 So I go to this voyager.inc page, line 26 and here is the code: dim db ' Create and open...

I am reading in a file name and I want to extract a piece of the file name. So if the filename is C:\Test\Test2\1234_Jingle[1].2_Done.csv, I only want the portion between the "-" and the "[". I believe I've done this within VB before but I cannot remember how. What function can I use to extract...

Ok so .csv files are a little tricky. I find when I save a .csv file, I am prompted to save yet again before I close the window. Is there any way to prevent the second saving? The reason I ask is because I have written an application to perform some changes to a spreadsheet (.csv file) and then...

I've read that a macro is only good for the current project. Thus if I wanted to use a macro for another project/worksheet I'd need to re-create the macro. Is there ANY way to go around this? I have a macro that I'd like to use for MANY worksheets. Many worksheets have yet to be created. But...

I created a form with the following code: Dim FileToOpen As String Private Sub Form_Load() FileToOpen = Application.GetOpenFilename If FileToOpen = "False" Or FileToOpen = "" Then MsgBox "Ensure file is chosen correctly" Else...

I'm pretty new with creating macros and have only created the very simple macros at that. I have an excel spreadsheet that I will get each week (with different data) and I will need to focus on the data in the D$ column. I'll need to create a macro that I can run once I open up this spreadsheet...

Is this possible? It seems they automatically become nullable and I don't want it nullable (because otherwise the report won't work).

I noticed that since we upgraded to Crystal Enterprise that a checkbox appears in our parameters specifying that we can check the box for NULL. However not ALL of our reports have this. I have a report that I have 1 parameter for - and it is required. I don't want the null checkbox to appear. Is...

We just upgraded to Crystal Enterprise (previously were using Crystal 7 with the web component). It seems that all of the parameters that were once optional are no longer optional. If you do not supply a parameter the report bombs out. Is this a Crystal Enterprise thing? Can I create optional...

I just recently upgraded to Crystal Enterprise as we are now going with Crystal 8.5 (previously with version 7.0). I have several reports which accepted null values. If you did not specify a value for a parameter it would simply return all data. However this has all changed. In some reports...

Ok so I know I've done this before and so I don't know why it isn't working. I have a field on my report which ends up being 0. I know you can't divide by 0 so I'm trying to come up with a switch statement to take care of that and to yield 1. This is what I have...

I don't understand why my application works fine on my computer, works fine on one server, but when I copy all of the files (executable, report, etc) over to yet a third server, it doesn't run. The code is slightly different but I don't think thats it. Perhaps a missing dll?

I created a simple application that basically calls a crystal report to open, print and close. It works on one server. Yet when I transfer the code to a different server, I get the following error when trying to run: 11/03/2003, 09:31:00, 4, 0, :File Not Found. What does this mean? What file...

Run time error 5174: This file could not be found. Try one or more of the following: * Check the spelling of the name of the document * Try a different name. This error occurs when the macro finds a file that has the same 9 digit code sequence... I don't understand why my macro is doing...

What code do I need to access a directory on my PC and more specifically to look at the files within the directory?

Help. I have thousands of documents that I need to merge together to end up with about 50 documents. Basically each document starts with a 9 digit code. I need to open a document. If there are other documents that contain the same 9 digit code prefix, I need to add a section break at the end...

Help. I have thousands of documents that I need to merge together to end up with about 50 documents. Basically each document starts with a 9 digit code. I need to open a document. If there are other documents that contain the same 9 digit code prefix, I need to add a section break at the end...