Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: syscrash
  • Content: Threads
  • Order by date
  1. syscrash

    Crystal Database Login

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

    I need help re-constructting an SQL statement

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

    I need help constructting an SQL statement

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

    Error – 3085 DOA. Database – Undefined function ‘DSUM’ in expression.

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

    Looking for a VB 5 import Tool...

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

    Blank Report on Second Run...

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

    Blank Report...

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

    Failed to Open Document...

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

    Problem with CD...

    I have a strange problem going on with one of my XP Pro machines (running service pack 2). I can put a CD into the drive and it will read it just fine. But when I put a blank CD in, it doesn’t seem to see it as a CD-R. Normally you would be able to right click on something and hit send to and...
  10. syscrash

    Problem pulling company address...

    Hello, everyone. I have a problem with one of my crystal reports (version 7). I have a formula object that shows the company name and it looks like it pulls that from a different database because I don’t have a field by this name at all in the current database. That is working fine but on my...
  11. syscrash

    8.3 format in Crystal Reprots...

    Hello all, I have a user that when he opens his Crystal Reports, in the title bar at the top it is showing the report name in 8.3 format. Does anyone know how to change this back to show the long filename again? This is an issue because we have a lot of reports and then names are similar all but...
  12. syscrash

    EC=7

    We are running ArcServeIT 6.61 on an NT machine. Lately we have been getting a message at the end of the Job Log that says: Failed to insert detailed records.(EC=Error Code=7) Does anyone have any idea what this is or how to fix it? I think that it has something to do with the detailed records...
  13. syscrash

    command=0

    I am having a few pcs that are getting an error and not getting every thing backed up. The error that they are getting is "609 E8524 Received unrecognized command from the client agent. (COMMAND=0)". Has anyone seen this before? I can't seem to find out what is causing it.
  14. syscrash

    ipconfig problem

    I have a user that can't run the ipconfig command in dos. It say that it isn't an internal or external commmand. Has anyone ever seen this? Or does anyone know how to fix it? I have given him a static IP for now, but I would rather get him back on my DHCP server. Thanks in advance for the help...
  15. syscrash

    email alert

    I don't have an exchange mail server, but I do have a cube server running as a pop3. Is there any way to get ARCServe to send me an email alert on how the backup went?

Part and Inventory Search

Back
Top