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!

Register Log in
  • Congratulations derfloh 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: virgo
  • Order by date
  1. virgo

    Legacy report (and file) problems

    Zim, What are sub cursors? Why did you make that statement about iif() and sql? Is there a special iif function? Also, after I get all this information out, then I need to append it to specific places in another database. Also, the 33 hours got involved with Access because people 'said that...
  2. virgo

    'Losing Data' in successive reports

    I actually put in several questions on this. You and Pete answered one of the other threads. I got some ideas from that and IT IS DONE. Thank you.
  3. virgo

    Deleting a Line if it is not present in an address label

    This is a duplexed membership card. On the same side of legal sized card stock is the address and the actual membership card. So, sort of like this address name picture add1 name add2...
  4. virgo

    Deleting a Line if it is not present in an address label

    Yes, There was an original 'label' written that would deal with all of the problems in the report. This does not work now. So, what I am doing is just setting up the membership cards. They read fine when there is an address1, address2, and an address3. I have not as yet 'ditched' that...
  5. virgo

    Deleting a Line if it is not present in an address label

    I also need to be able to delete just an address line if it is not present. When I try to do this, it deletes the entire address. I can't just delete a line.
  6. virgo

    'Losing Data' in successive reports

    I have to use the same report with a series of 4 datafiles. It worked fine with the first datafile. It can't 'find' the data from the second, third, and fourth datafiles. These are FoxPro dbf files. I have looked at them in FoxPro. They are fine. This report was set up in Crystal 5. (I...
  7. virgo

    Legacy report (and file) problems

    A little bit more on what the problem is. I separate the 4 files as to whether they are members or subscribers. I also separate both members and subscribers as to whether they are new (no accounting records for this last year) or whether they are renewed (everyone else). I then run a separate...
  8. virgo

    Getting data from a FPW2.6 Database and running report

    I have a large Foxpro Windows 2.6 database. I have to pull information from 4 files in the database. I then have to accurately place this in a fifth file so that I can run a report from this. The report was done in Access 97. It works so long as the fifth file is correct. I could get the...
  9. virgo

    Legacy report (and file) problems

    I need to be able to pull information out of a large database (FPW 2.6, 4 different files) and place it very accurately in a fifth file. This fifth file is then used to run Crystal Reports. I can get data out of the large database. I cannot get it to go accurately into the fifth file. I...
  10. virgo

    Add a counter to a report

    I 'inherited' a report that does membership cards. I need to add a counter to this. I don't know how. None of the documentation that I have says anything about it. And, as usual, I needed to do this yesterday. This report is in Crystal 5.
  11. virgo

    use foxpro 2.6 with ADO

    I have used both the ODBC drivers and the Visual FoxPro drivers. Both work fine. A faster way is to link the databases to an Access database and then use 3.51 drivers.
  12. virgo

    Visual Basic linked to a Database

    I use Access with a database that is presently about 7 Gig in size. The original database was written in Foxpro 2.5 and it is not normalized. By using Access, I can get a much more efficient arrangement of the data that I actually need to do a particular operation. The whole thing is on a...
  13. virgo

    Foxpro For Windows 2.5b Divide by Zero error

    Mattie, I agree with Rick. It is the speed of the computer. It is not Win2000. I have a Foxpro 2.6 app that runs fine on Win2000 (with the appropriate slow down patches).
  14. virgo

    Pulling Data from FoxPro files into Access

    You are so right. And, I know that and just didn't think about it. Is there any possibility of cutting these monsters, perhaps with Access queries into more managable size?
  15. virgo

    ODBC Error connecting Fox2.5 database on Network.....

    The VFP drivers do support FP 2.x according to the documentation. However, if the files are very big or if there are only a few fields that are wanted and there are a number of variables in the file, DB4 drivers work out a lot better.
  16. virgo

    Indexing a 'dynamic' database

    Thank you. You are right. I am not familiar with DSalvage. I did use Foxfix to attempt to fix some indices in a test system and I couldn't open anything after I was finished. I am not certain what happened. Also, I got some information on utilities from you about a year ago. They are...
  17. virgo

    Need Foxpro conversion program.

    Going along with Mike, I do a lot of imports. It works fine. I also have much more control over what I am doing.
  18. virgo

    Pulling Data from FoxPro files into Access

    A little more information. I have tried this on 2 workstations with the same results. Workstation 1 Access 97, FP 2.6a Win. ODBC drivers tried. General ODBC, FoxPro, VFP tables, and Dbase 4 98 SE, 196 Meg RAM Workstation 2 - differences from 1 Access 2000, 95 B, 64 Meg RAM I have 4 tables...
  19. virgo

    Pulling Data from FoxPro files into Access

    I 'inherited' a large Foxpro Win 2.6 database about a year ago. This runs peer to peer off NT 4 - SP 6. Many of the datafiles are very large. One is about 3.5 Gig. Many of the variables in the original datafiles are not being used in the system. However, as all paths, locations, etc. are...
  20. virgo

    Indexing a 'dynamic' database

    I 'inherited' a Foxpro 2.6 for Win database that runs on an NT network about a year ago. It is set up peer to peer. It has paths, font size, location of variable, screen resolution, etc. hard coded into it. Now for the problem. A user pulls some data to make a report. This ends up on...

Part and Inventory Search

Back
Top