Search results for query: *

Did you check your tempdb and templog files? I used to have these files size setup too small and when users would run queries or Crystal reports it would grow bigger than the original size and that expanding every time (because it only grows at certain size blocks) used to slow down the whole...

It gives me a no SSPI context error message.

I wrote a program that dettaches our month end database on Friday night and should attach it back again on Saturday morning. The dettaching works just fine but attaching does not work. Any ideas? Dim oSQLSrv As New SQLDMO.SQLServer FileName1 = .mdf filename FileName2 = .ldf filename...

I have a VB program that opens up an Excel sheet and prints it out. It was working fine until we acquired a printer that has multiple bins. How can I access the printing preferences, options properties from VB so I can change them accordingly?

Using CRPE I wrote a VB6.0 program that inputs parameter values to a Crystal report and then prints it out with CRReport.Printout method. It was printing labels to a printer just fine. The printer broke down and it was replaced with a Genicom printer. I changed the Crystal report to the new...

The user has the printer driver. The weird thing is that if she runs the Crystal report by itself it prints just fine (really fast). When printing it from VBA is very very very slow. The Crystal report has the printer defined as the printer to use and the VBA program does not change it. If I...

How can I do that? Thanks.

I run a Crystal report from a VBA program to print labels via 'crreport.printout true' so the little printer window shows up and the user can change # of copies. After replacing the printer it used to go to which is specified in the report with another printer of the same kind the labels now...

I run a Crystal report from a VBA program to print labels via 'crreport.printout true' so the little printer window shows up and the user can change # of copies. After replacing the printer it used to go to which is specified in the report with another printer of the same kind the labels now...

It worked! Thanks.

When running a report on the server, the export options don't keep. The user has to re-enter them (file format , file path) everytime he runs the report. How can I save the export options with the report so the user only has to select Export the Report and Print it. Thanks.

If you use a shared variable you will be able to control that variable's value in the main report. Search for 'variables,scopes' under Crystal Help.

When using PrintOut from a vb program a little window displays that says Printing Report and allows user to cancel. How can I hide this window so the user cannot accidentally click on Cancel? Thanks.