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 strongm 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: *

  1. 33216CLC

    Migration

    To tell u the truth, I do not have any version. I have decided to migrate, but have not as yet. According to what u said, it would be best to use 9. Thanks for rhe tips.
  2. 33216CLC

    Migration

    Thanks ddiamond, Excellent suggestions. My concern is mostly with rewriting or modifying the queries. I plan to do what u suggested, I just do not know the syntax. I have been researching for some tips and found some, but it's all still blurry for me...... I have always worked with Access in VB.
  3. 33216CLC

    Migration

    RamHardikar, I want to do the same thing. I am so frustrated with access. I just want to know if you have completed the migration and how long it took, before I try the link. Thanks.
  4. 33216CLC

    Program to distinguish changes in code

    Thank you all so much for you input. I've been a bit tied up with other matters, but I'll look into your suggestions and see which works out best. Thanks again
  5. 33216CLC

    Program to distinguish changes in code

    Thanks both of you. I was referred to Windiff, but when I checked the help to find out how to get to it it was disabled under the Vb documation which gave me the impression that it only worked with c++. So it does work with VB? How do I get to it? THanks
  6. 33216CLC

    Program to distinguish changes in code

    Is there a program that I can use to distinguish changes made to code or the difference in code between two of the same vb forms. Myself and another programmer are making changes to a program. Unfortunately the other programmer did not mark the changes that they made as was agreed and my...
  7. 33216CLC

    upgrading problems with crystal reports 9

    Actually there is a utility/fix that CrystalDecisions has, but I'm not certain if it will work for ver.9. Its called "Crystal Update", I used one version of it for 7.0 and a later version for 8.5. My thing is that I would prefer to do this using code in my VB 6 project. Still...
  8. 33216CLC

    Setting Database Location in report file

    Hi Ken, Believe it or not, I'm still having this problem. I have downloaded the crysal update utility to help with this problem and it works. My concern is that having to use the update utility would be to cumbersome for my users. Is there a way I can programmtically set the location of the...
  9. 33216CLC

    What is the best export?

    Ken, I am able to export to PDF on my development Computer, but on my Clients' Pcs pdf does not even appear as one of the export options. The vb app on their systems was installed with crystal 7 files. I copied the crxf_pdf.dll into the Winnt/System32 folder and copied the Craxdrt.dll for...
  10. 33216CLC

    Averaging

    Siggy19, I did not know you had responded. For some reason I did not receive a notification. So I sought help elsewhere. The response I got was similar to your last post: if not isnull({Rpt_Pension.AnnPay1}) then ( Total:=Total+{Rpt_Pension.AnnPay1}; Counter:=Counter+1; ); Thank you for your...
  11. 33216CLC

    Averaging

    Siggy19, I tried your suggestion (below) on a formula in crystal and I still get the average on 5 instead of on the actual amount of Annual Salaries. The only difference is that I did not use the End if - Crystal does not recognize it. numberVar Total:=0; numberVar Counter:=0; if not...
  12. 33216CLC

    Averaging

    Hi Siggy, Lisa, I am not very familiar with what you are suggesting. I have used formulas in Crystal, but not like those you wrote in your last response. Could you please expound? I would really appreciate it. Thanks
  13. 33216CLC

    Create Blank Access DB question

    I'm sorry if I was not clear with what I was said. In your first response to my thread you said that I should be able to change the field to AutoNumber if it had no values. Well the field had no values; so I tried to several times to change it to AutoNumber and it did not work. I then did...
  14. 33216CLC

    Create Blank Access DB question

    CCLINT, I tried several times to update the field attribute to dbAutoIncrField, but to know avail. Here is what I did (it works): 1. Delete the field in question 2. Append the new field using the code: Set fld = tbl.CreateField("dependent_id", dbLong)...
  15. 33216CLC

    Create Blank Access DB question

    CCLINT, What if I have a field in my database that I would like to change to autonumber (using dao code in Vb). It is already defined as Long Integer. Could I do this? or would I have to add another field to my table? Thanks for any help.
  16. 33216CLC

    Averaging

    Thanks, Siggy. Both you and Lisa are suggesting exactly what I was trying to avoid; using code outside of Crystal to get what I want. It seems as though I may have to resort to doing just that. Will see how it goes. Thanks. You were a great help.
  17. 33216CLC

    Averaging

    I thought of placing zeros in the blank fields and realized it would not help. What I need is for the formula to return the average according to the fields that are not blank. If one field is blank then 4 would be used for averaging. The 5 fields each represent a figure for a different year...
  18. 33216CLC

    Averaging

    Hi, I would like to obtain the average of several columns in my report. Each column contains a figure from a different field (but same table) of the datasource. I used a formula in this report to display the average but it comes up blank. This is a bit confusing because when I set up the...
  19. 33216CLC

    Verify Database Automatically?

    Hi, Steve, Ed, Ken, I got this file from Steve last year. However, someone at work deleted it by mistake, and my altavista address no longer exists. Could one of you please resend this file to me? cooleenclc@yahoo.com Thanks.
  20. 33216CLC

    Problem deploying VB6 with Crystal 8.5

    Hi, I have tried on several occasions to create an installed version of an upgrade version of my vb6 app. I use the vb6 package and deployment wizard (Enterprise Version). I go through all the steps, but when I click the finish button, it appears for a few seconds to be creating the cab file...

Part and Inventory Search

Back
Top