Recent content by jpalmer150

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...