Search results

Spain played wonderful football so far, the one or two flashes of England's potential we saw last night are produced on every attack by Spain. The quality and skill of the modern players, such that it is, if any of them are given enough space and time on the ball they can show us real...

Is Football coming home?

@arnelgp Nope, Still changing back to currency in the table. In query is it changing for display purposes only?

Good Morning Good People, I have a simple make table query. In that query are two currency fields. In the field properties I have converted the field to a standard number with no decimal places. When I run the query the table format is back to currency with decimal. Why is my query formatting...

I have recently had a couple of similar but not identical problems, in the end it turned out to be either a join that needed changing or a date configuration, or data input clerk error.

what windows you on?

It doesnt sound like the right time to do the upgrade. Is it Imperative? If the upgrade goes pear shaped you will feel under enormous pressure to "sort it out". At least wait until your Dad is better.

Hi Docman, It will not be straightforward, my research has led me to consider that my windows is not the best at interpreting the necessary DOS commands. The backend is FP 9 and the earlier versions may not be compatible with either FP9 or Windows.

@Gasman Thanks for that info, if I recall correctly adding more layers, interfaces etc just increases demand of processor and memory. Those old simple instructions will be very fast on modern PC, without all the baggage attached to every instruction. Oh for the purity of *.* I will look into...

Your very defensive, abrasive and insulting Pat. You have not endeavored to inquire what my solution would be, and your telepathy is way off beam. Is this the free wine cooler?

Guns kill more people than plane crashes, This who I would prefer in charge of the gun plane. https://www.facebook.com/joebiden/videos/no-donald-we-dont-have-to-get-over-school-shootings-we-have-to-stop-them/775213131268910/

from an outsider looking in, It is all perfectly legal, ask Scotus. AND as Trump once said to everyone regarding Murdered children at a school shooting "you just gotta get over it"

Thank you all for advice on indexes Now running things at least 10x faster. :)

Thanks for trying Gasman. Keys and indexes are remaining through linked tables so that is one job less. will probably vanish tomorrow when I update tables. At least I have found the right place to put the code.

@Gasman It appears straight forward, the most important field are all labeled *********_ID I am going to re index every field that I intend to manipulate in case something has been lost in translation. I will do it manually for a bit to see if it improves things and then try to put in a VB...

Thank You Gasman that is very kind of you to offer. What are indices? And where will I find them? I am going to PK them where I need them. Indexing the new tables is my next job

Give me your old FoxPro. :) Thanks to all you guys input I have developed a better (?), what seems to me, more efficient strategy. There is a whole mass of data that I am not really interested in for this particular project. I have streamlined the data down to a half dozen tables with the...

You have to understand that my knowledge is limited, I am learning as I go. I update the files each day and they are stored DBF, FPT and Some CDX whatever that means. What I have learned is that it is lightening, 2 million records load 20 times faster than Access can scroll to the bottom of the...

I know, I had it about 30 years ago or more, when it first came out. It might still be buried in the loft somewhere.