Search results for query: *

I checked the jumpers. Both were set on "Cable Select" and connected to the appropriate ultra ATA cable connectors. Since this was not working, I jumpered the boot drive to "master with slave present" and jumpered my second drive as "slave". This configuration booted up without a problem...

I have a Compaq Presario 6000T running XP SP2 that came with a 120GB hard drive. I bought a Seagate 250GB hard drive to add as the slave drive. I installed the second drive using the "Cable Select" jumper setting and attached to the gray connector in the middle of the cable. I was able to see...

I believe dgillz meant to say: In the report footer: WhilePrintingRecords; Numbervar MyTotal; An alternative would be to create a regular running total formula referencing the GF2 formula.

When assigning a value to a variable you must use ":=" operator not "=". "=" by itself is performing a logical comparison that the variable on the left equals the value on the right. ":=" actually sets the variable on the left to the value on the right. numbervar x:=0...

Thanks for the link to Jamie's Software - Access Proprty Editor. I downloaded it and it does exactly what I wanted!

I'm also interested in having a separate application to enable/disable the bypass key in another database. I would appreciate getting a copy of sumoalex's .mdb to do this. Thanks.

I found the problem. There was some code that replaced the default record source with another query. That query did not have the new fields, thus the failure. After updating that query the form works fine. Thanks for your offer to help.

Rolliee, Thanks for the offer, but I'm not sure what you could do since the backend is a SQL server database. Wouldn't you need to link to the tables to test the form?

I still get the error when I add the fields from the field list. If I put "=[field name]" in the control source of the text box the #NAME? error goes away. But when I run the form and try to update the text box in VBA code fired by an event on another control I get the Access error dialog with...

I am using Access 2000 with linked tables to a SQL Server 2000 backend database. I have a form whose record source is based on a simple query on a single table. Due to design changes two fields needed to be added to the table and then to bound text boxes on the form. I added the fields to the...

Thanks for the explanation.

I have an Access application which has split the database between a SQL Server backend and an Access GUI front-end. A number of public variables have been declared in a public module which are used as a way of passing data from one form to another. In a multiuser environment, particularly one...

I have written a report in CR9 using the new SQL Command feature. It works great. However, now I need to change the way I connect to the database from a DSN to a DSN-less connection string. Crystal associates the SQL command with the DSN connection so when I change the connection type it does...

Does anyone know if Crystal Dictionaries are being phased out? Crystal Reports for .NET does not support them and Crystal Reports 9.0 does not come with the dictionary tool. I know Crystal Reports 9.0 can read 8.5 dictionaries, but the tool has not been updated for 9.0. You can download the...

I have published a report based on a Crystal dictionary in CE 8.0. It runs fine on-demand, but when I schedule it, it fails with a "cannot open SQL server" message. Both the page server and job server accounts run under the same domain-wide user. Any ideas why this is happening would...

I want to query CE and send email notifications when I find new report instances. When I try to send a message with CDO it fails with a "permissions denied" error. The account CE is running under has full domain access. How can I get CDO to run in a CSP page?

The Crystal Decisions support site has a technical brief named "scr_oracle_stored_procedures.pdf" that you can donwload. It contains very important information about which versions of the database drivers work with which version of CR and how to set up the DSN. It also gives you some...

CR cannot create embedded select statements from the selection formula builder. In order to get this to work with a parameter, I think you will have to go with a stored procedure. What database are you using? I can give you some pointers if you are using Microsoft SQL Server or Oracle. One...

Make your SQL into a stored procedure that accepts a parameter, then base your report on it. Crystal automatically creates a parameter field matching the one in the stored procedure and will prompt the user. Crystal passes the user's response to the stored procedure without needing a selection...