Recent content by rhoneyfi

MDE runs fine in Access. It is a secured MDE...I entered in the username/pw info in Crystal and pointed it to the security file....I still get an error though and Crystal shuts down. If I leave the username and p/w blank in Crystal, I can connect to the MDE (it shows the list of tables...

Hello, Does anyone know if Crystal Reports 11 can connect to an MDE datasource? When I try to connect to the MDE, Crystal gives me an error and shuts down. This is my first time connecting to an MDE. I am not sure if I get an error because of a bug in Crystal Reports or if you just can't connect...

I just tried connecting via ODBC...Crystal lets me connect OK..., but when I go to select a view or a table, it says I don't have permission to. I entered in the database password in the OBDC connection. I'm pretty new with ODBC...any ideas what I could be doing wrong.

Hi Ido! It's an error I get from Crystal designer. All I am doing is using the report wizard to create a new report. When I link to the secured MDE database, Crystal gives me the error and shuts down. P.S. I'm a big fan of Visual Cut! Great program

I just tried a differnt MDE file and it linked up with Crystal OK. It's strange...the MDE file I want to link up with is a secured database. If I don't enter in the username/password when linking Crystal up to it, I can view all the table names. When I go back and do enter in the username and...

I am trying connecting via Access/Excel (DAO). The error that comes up is'CRW32.exe encountered a problem and needs to close". I just don't know if closing because of a problem with MDE file or if because there is a bug in Crystal 11. Any ideas?

Hello, I am using Crystal XI and trying to link to an Access MDE database. I get a fatal error and Crystal shuts down when I try to establish a connection. I've used CRystal in the past to link to MBD and SQL databases....never and MDE though. Can I even link up to this type of database? Thanks

Hi, I have a crosstab report (CR 9.0) that shows me the number of times an exmployee logged into their computer each day. What I would like is for the crosstab to only show those employees that did not log onto their computer. Any ideas?

kskid, This works perfectly..Thanks! You post was very easy to follow and understand.

Hello, I am using CR 9.0. I have a main report that contains 2 subreport. Subreport1 shows me the total number of applications a client has given to us in the past 30 days. Subreport2 shows the total number of applications a client has given us in the past 60 days. In a nutshell, what I need to...

I'm a little new to Access and need a little help. I have created a crosstab query that looks like this Jan 2005 Feb 2005 Account #1 $10,000 $15,000 It basically shows an account balance for the past 2 months. What I would like is a formula that calculated the...

Hello, I am trying to create an interactive form. In one portion of it, it asks for the companies physical address and then the companies billing address. What I would like is for the user to be able to click a check box so that if the physical address is the same as the billing address, it...

Gerry, Wow, thanks for all the great info. I'll give it a try.

Hello, I am new to the world of User Forms. Here's what I want to do: 1)A user enters in a clients name/address in a text box 2) Then from a drop down list, they choose if the client's business is a Corporation, LLC, or Partnership 3) They then click a button that says "Generate Letter" There...

Cool...works perfectly. Thanks!