Search results for query: *

I pasted your code into a vb form and could not find any error that jumps out at me. Perhaps it has to do with the way you set up the connection or called the query? What your doing seems simple enough, but I have never had this type of error before. I recommend posting this question to the VB...

I assume that strKnzFSDataSQLPath is part of the path and is in the form of "[Server].[Database].[Owner]" , and the "FSExtract_HCPCFG" is the [TableName]. If so, you will have to add a period after [Owner] to complete the entire name of the table. So the code should be : stsql = "SELECT...

If you don't mind using a stored procedure, you could try this code. I had to do this in a one of my applications for a different reason. You will need to change the table column types to match your fields. SET NOCOUNT ON DECLARE @MyTable table ( UniqueId [int] IDENTITY(1,1) NOT NULL...

Oh crap, I always forget to put the FROM after the set. Sorry about that, just ignore my previous post. This should work better: UPDATE tblPunchOriginDistilled SET tblPunchOriginDistilled.poDrv = tblBadgelist.drivernumber FROM tblPunchOriginDistilled,tblBadgelist WHERE...

Try this instead: UPDATE tblPunchOriginDistilled,tblBadgelist SET tblPunchOriginDistilled.poDrv = tblBadgelist.drivernumber WHERE tblPunchOriginDistilled.poEid = tblBadgelist.FileNum

I am not familiar with version 9 of CR. But, unless it has changed from 8.5 to 9, it should work. I would try what telescopi mentioned in his post. I think we tried that and had no luck.

I wanted to update everyone. I solved my problem. It still does not work programatically with VB. But, I found another solution. I had our server admin create a new printer that pointed to the same printer. We then modified the default properties, so that the new printer would always print in...

I wanted to update everyone. I solved my problem. It still does not work programatically with VB. But, I found another solution. I had our server admin create a new printer that pointed to the same printer. We then modified the default properties, so that the new printer would always print in...

SurfingGecko, I am already using the PrinterDuplex property as shown in my previous code posting. It does not seem to be working like it should be. Any more ideas? Maybe its a Crystal bug?. Thanks PCJock

I can not get my crystal 8.5 report to print in duplex mode programmatically. The printer is a duplex printer. I can step through and see the properties of the report object being modified by my code. I can print just fine if I use "Report.PrinterSetup Me.hWnd". But I have to manually...

I can not get my crystal 8.5 report to print in duplex mode programmatically. The printer is a duplex printer. I can step through and see the properties of the report object being modified by my code. I can print just fine if I use "Report.PrinterSetup Me.hWnd". But I have to manually...

I am using the SmartActiveX.asp to deliver my reports via the web. When a user clicks export, the export dialog opens with "Crystal Reports 8" file type selected by default. Is there a way to change this to select the "Excel" format as the default? The user can then change it...

I am using the SmartActiveX.asp to deliver my reports via the web. When a user clicks export, the export dialog opens with "Crystal Reports 8" file type selected by default. Is there a way to change this to select the "Excel" format as the default? The user can then change it...

Make sure you remove any shortcuts in the start menu for each user and in the "All Users" folder. Could be trying to run it from there.

Maybe you could add a new column of type int. Run a query that sets the new column data to equal the identity column. Then delete the identity column.

Why not pass it as a string? Use cast or convert to change the string to the smalltimedate type. If you want date and time separated then pass them separate as strings. Then concatenate the two strings together and convert to datetime. For example: set startdate= month + time. Use the startdate...