Recent content by syscrash

Thanks for the reply, I tried that but it didn't work. I even copied the file to a different location and pointed the report to look there and it still failed.

I am working with VB.Net 2005 looking at an Access 2003 database. When I run my Crystal Report (version 10.0.5.1279) I get a Database Login screen even though I don’t have passwords set at all in this datatbase. Can anyone tell me of a way to stop this from coming up? Thanks in advance for all...

Thanks Bob, I did get it but I had to post on a different site than Tek Tips. And I did do exactly what you suggested, I posted it in the other forum for Access (in Tek Tips). But either way I was able to get some help with it and was able to get moving. Thanks again!

Thanks Bob. I am just having a hard time with the syntax and finding anyone to help me figure it out. I have never had this hard of a time getting help with an issue.

Ok, so maybe I was asking too much before. I am now trying to do this a section at a time. So I have stripped it down andI am just working on the Having statement. Can someone please help me work through this? I just can't seem to get the syntax right. This is what I have so far and when I try...

I can get this to work in Access but I can't use the DMax and DSum statements in VB6 because of DAO, so I was told to use a subquery. Can anyone help me convert this over to use a subquery (using Max and Sum instead) instead? Recap of what is happening...My joined tables have multiple...

Alright thanks Bob, I will give that a try.

Hey Bob, thanks for the reply. I can get this to work in Access but I can't use the DMax and DSum statements in VB6 because of DAO, so I was told to use a subquery. Can you (or anyone) help me convert this over to use a subquery instead? SELECT JCDrHdr.DrawHdrID, JCDrHdr.ReqNo AS Request...

I am working with VB6 looking at an Access database and I am trying to setup an SQL statement with a sub-query. My joined tables have multiple lines/rows for an item (DrawHdrID), and I need to collapse them all into one single line, and show the highest number of one column (Request number) and...

Thanks for your replies StrongM and Joe...I am sorry I do not understanding what I am doing wrong. Here are the steps I am taking when I get to this routine... 1. I delete the query if it is already there. 2. I recreate the query using the SQL that I gave earlier. 3. I assign my record source...

Thanks for your replies StrongM and Joe...I am sorry I do not understanding what I am doing wrong. Here are the steps I am taking when I get to this routine... 1. I delete the query if it is already there. 2. I recreate the query using the SQL that I gave earlier. 3. I assign my record source...

Thanks for your reply. Maybe it would help if I posted the query that is being used to build the query in VB.... strSQLtmpDrawLookup = "SELECT JCDrHdr.DrawHdrID, JCDrHdr.ReqNo AS Request, JCDrHdr.PrjNo AS Project, JCDrHdr.JobNo AS Job, JCDES.DesName AS JobName, JCDES.DesLoNo AS LotNo...

Thanks for your response Andy. Yes the VB runs that query, and the App does know about it because I create the query on the fly. I do this in other areas too but in this case it is having a problem with the DSum command in the Query. However I can run the query that was created by looking at the...

I am working with VB6 looking at an Access 97 database. I have come across a problem where the code creates a Query in the Access file, then assigns that query to a Recordset (I know the query is fine because when I run open it in Access it shows the desired results). The problem is with some...

Thanks strongm, I found that same KB a few hours after I posted this and so far it is exactly what we needed.