Search results for query: *

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

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.

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

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

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.

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

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

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

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

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.

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.

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

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

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?

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.

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

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

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

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

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