Search results for query: *

Hi Randy, Thanks for the tip, however, I run many queries on the fly. Make them up as I go depending on the condition of the client's files. I process so many files during the day that imbedding them in a code would take time. If the code you are suggesting, is like turning off the warning on...

Hi Leslie, Sometimes I just run the query by itself, other times it will be with a macro. The warning comes up using either. As for the warning . . . I confess that I'm ignorant as to why they come up. Often in the past I would check the results of the query and everything looks as expected...

That's correct Leslie. I don't want to know that some records failed to update. The files I work with are address database files submitted by numerous clients. The file sizes vary, fields vary, and content varies. Many clients provide records with fields that are blank or contain garbage...

Hi, I run many small update queries when working on various customer files. Numerous times I get the following message asking for continuance of the query. In all cases I select Yes. ----------------------------------------------------------------------------------- Microsoft Access can't...

Thanks fdcusa . . . I will give your idea a try. Appreciate the feedback . . . Peter

Hi gang . . . I have one table that contains a field with various Dealer names. In total I have 62 Dealers with each having various number of records. What I am looking for is a way to create unique individual tables based on each unique Dealer name. Currently I need to enter each Dealer name...

Thanks for all the responses . . .

Once again - it's not fair to characterize it as a "problem". " ? - I can take the exact same .dbf file and import it into Access. That exact file will at times import in the original order and at other times import with the order completely messed up. So . . . how is that not a problem with...

Hi PB . . . Yes, I do run queries on the files once imported. I also add some additional fields and populate them with other information. So linking to the dbase files will not help me. I have used dbase converting programs to change the dbase to text or tab delimited files > then import the...

Nah, not buying a copy of dbase II . . . lol I still like Access for all the other things it does . . . just frustrated with the way it sometimes likes Dbase and sometimes not . . . Then again it may be just my ignorance on understanding dbase and/or Access when it comes to importing. Thanks...

Thanks Geoff . . . not much chance of the software supplier adding a new field for me. But I will ask. The software specializes in sortation of addresses by delivery mode. It is quite complex and the order of the records output conforms with Postal regulations. No extra fields are supplied such...

Thanks PH . . . but I don't have a field that I can rely on for a sort. The program that created the DBF gives it a very specific order which does not allow for any specific fields to be used for sorting in Access. Thanks Geoff . . . there is no index file in the DBF file, so yes, I am...

Hi gang . . . I use Access 2000 for importing Dbase files created from another program. These Dbase files can have different fields and have records anywhere from 500 to 150,000. The program that creates the Dbase file sorts the records in a very specific order. I then import the Dbase file...

Thanks DeZiner I have exported some text from Corel. Need to find something that will give me a sharper text image though. Anyways I was wondering if the problem with large text being jagged goes for all HTML writing programs. If so you would think there is a small program for just creating...

I have created a number of pages using Arial font in Frontpage 2002. I have some headers over text blocks where I have set the font size to 5(18pt) and bold. The text is dark blue on a white background. When the pages are viewed on the browser ( and other browsers on different computers ) the...

I have a database which contains a field with a numeric value for indicating how many tags need to printed. I have setup a report using the database. Is there a way that I can use the value, i.e. 3, to print the report 3 times. In other words can I use the qty required and somehow tell Access...

Hey thanks guys. I will give these a try and see what the results are. I find that there is a lot to digest using FoxPro. Wish there was software that gave straight forward samples of practical use of expressions and functions. But I will continue reading and testing. Thanks again. Peter

Thanks Diederik, I have tried your suggestion in conjunction with the UPDATE function. When I apply the update the first record in the Firstname field is split properly. However all the following records are not split by the space but rather by the same number of charcters that the first...

Thanks John: But I'm still lost. I use foxpro only for working on dbf files containing names and addresses. I do high volumed data processing for address verification and sorting. I get some customer files that have a field containing both the lastname and firstname. When I was using Access I...

I am new to Foxpro(v5). I have been using Access for about 5 years. In Access I use an update query to split a 'Name' field into two other fields by looking for a comma or space between words in the 'Name' field. For example I will have Smith, John in the 'Name' field and I split the words into...