Search results for query: *

idehen , The users do not have Crystal installed on their machines.

That certainly seems like it would work. What are you using as your remove? A wireless Mouse or something else? How would I configure it to be read by both machines?

I'd like to use two separate screens during my presenation. I am familiar with Dual monitor capabilities in Windows and have 2 video cards in my machine. Does anyone know how I can show two different presenations at the same time so that I only need to click once to get both screens to...

I'm trying to program my macro to know whether a query is already open before it attempts to re-run the query. Anyone know the easiest way to do this?

Perfect...Thanks a lot guys!

I'm trying to set the default value for a control to be a value from a query. The query is filtered based on the key field therefore there will always be just one record. My coding currently is as follows: Default Value = [QrySel_User_Preferences]![Show_Rejected] Unfortunately this is not...

But how do I run a macro on Close?

I'd like to schedule Access to create a report and send to it a specific email address. Using the SendObject command I can get Access to create the email with the attachment but it doesn't populate the TO: field and it doesn't attempt to send. Does anyone have experience commanding Lotus note...

AutoExec....Figured it out.

How do I get Access to automatically execute a macro when the database is opened or closed?

I have a table [Categories] with a list of categories and their corresponding maximum income. CATEGORY MAX_INCOME Category 1 $20,000 Category 2 $30,000 Category 3 $40,000 I have another table [Incomes] with an Income value. I'd like to be able to go...

Fixed my problem. I was using the Workgroup Administrator in MSAccess and it was causing problems. I imported all the tables and queries into a blank Access Database to remove the security and that fixed it. Problem solved... -JP

From what I have read while researching my issue, there were some problems with the CRViewer in previous versions. Glad the upgrade helped. I'll keep that in mind. -JP

I'm trying to connect Crystal to an MS Access database. The Access DB has tables within it that are linked to a secured AS400 ODBC DSN. When attempting to connect to the Access database Crystal says that I do not have permissions for the linked AS400 table. Anybody know why Crystal isn't...

tektipdjango I'm going to give your idea a try. It sounds like what I was looking for. Thanks! synapsevampire you're definately right about the DB design. The data comes from an SAP B/W extraction pulled into an AS400 table. It holds the complete sales data for our fortune 500 company at...

synapsevampire, Your advice is good, and it's the first thing I tried (After trying to fire the DBA). The problem is that the DB is already over 1M records with the period fields combined into one record. When I separate them through a SQL Union query (Using the Crystal SQL designer) it...

Not sure if this will help with your issue. But I was recently having problems with my CRViewer. Installing this patch fixed my issue. Be sure that you have access to the original Crystal Installation files or disk if you decide to use these patches. After you install the patch the Crystal...

I have 24 fields in my database. One for each month for 2 yrs with numeric values. JAN03 FEB03 MAR03 .... NOV04 DEC04 It was necessary to setup the database this way to minimize the record volume. I'd like the report to display the last 12 months depending on a selection that the user makes...

Ken, Thanks a fine idea...I wasn't aware there were so many other viewers out there. Do you have experience with any of these viewer packages? Have you come to identify if any are better than another? How about HammerLaunch …Opinion? *Note – If you feel my question goes past what you...

Their Support technician pointed me to this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;191619 His formal conclusion was that the error was caused by a difference between v8.5 and v9.0 which could be remedied by following the steps recommended in the above article...