Search results for query: *

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.

I am looking for a VB 5 tool that will allow me to import text files into Access 97. Does anyone have anything like that or know of anything? I would rather not use the Access Import wizard API because it has too many options. Thanks in advance for any help you can give.

I have a few PCs that when they run a Crystal Report the second time it comes up blank. When they run it the first time it is fine. However if they try to run it again it is blank no header just a blank form. If they close out of the program and then open it again and run it again it comes up...

I have a few PCs that when they run a Crystal Report the second time it comes up blank. When they run it the first time it is fine. However if they try to run it again it is blank no header just a blank form. If they close out of the program and then open it again and run it again it comes up...

You are right I did upgrade (sorry). I upgraded to version 7.x. When I did the upgarde it has put the current version in a different location than the older one. When I did the Open With in Windows I told it to open with the most current version but it still goes back to the older one. I am...

I have rebuild one of our PCs and installed Crystal Reports and then updated to a higer version. When I go to an RPT file and double click to open it tries to open with the older version and I get the message "Failed to Open Documemnt" and "Invaild Report Version". But if I open the most current...