Search results for query: *

Got it Though a little surprised I somehow had a filter set, but I thought a replace all respected filters Anyway emergeny over and thanks to everyone who has helped me Richard Preston Lancs

mmerlinn I used to program in 2.6 as an IT contractor and regularly had my code assesed, SinceI started on vfp6 I have been a lone programmer or working from home. I havn't had my vfp code assesed ever, when you are self taught your thoughts and techniques tend to be limited. For instance...

Thanks everybody for your comments, I am a bit old fashioned & I like to have all the code in the exe as well as the problem of changing a dbc on a system that I will never have direct access to. (without a long drive). I am due to make a few table changes this week & I have been trying to...

I derived a cursor from this table _cursor so I scan _cursor for !deleted() and the records are put into a flagged record in the table I see what you mean Mike but it works without the transaction processing. I am not too worried but the code isn't as bomb proof as I would like, in this...

Yes the table is buffered and I am doing a Tableupdate during the transaction processing

By the way if you are going to use the index route use DTOS instead of dtoc YYYYMMDD Seeking an answer seek(dtos(date())

I have a tendancy to reuse records So a typical peice of code to amalgamate a cursor with the original table would be BEGIN TRANSACTION select <parent table> change flag field to 0 for matching records select <cursor> scan locate or seek the flagged field transfer the info endscan...

You won't believe this, the problem was in the report. Many thanks to everyone that made suggestions Richard

Hi so do I the cursor was created manually then had to be populated. The code to populate it is complex. I then selected the cursor and ran the report, the set skip was desperation. Regards Richard

I don't think this is a report problem but I have this bit of simple code SELECT _tmp2 SET SKIP TO _tmp2 REPORT FORM orderacks TO PRINTER PROMPT PREVIEW the report seemed to be skipping through the wrong table With the set skip in place we get "_tmp2 is not related to the current work...

I had a tidy up & decided to copy all the ocx files into the system32 directory where the should be anyway Because the .lic files were not in the same directory it was allowing the run time version to work but I couldn't open any of the forms. My own fault for trying to tidy up Rich

Now I have a problem I have a properly purchased and licensed copy of nav tools a faily old version but its not up to me to upgrade it When I modify form frmmainForm It has started throwing the error "ole error code 0x80040112" I have tried this on two seperate machines and recovered a backup...

Sorry I havn't replied earlier, but its been a bit busy. I am also trying to recover from an illness as well as keeping my contract. Thanks to jPadie, I will try out this technique as soon as I get half an hour to have a play Richard

lets see if i have this right. create the form in a variable $output the default action is Print $output and show the complete form. Then say by changing a variable say $action to 1 and rerunning the form it would say do some calculations instead. I already do something similar for my invoice...

thanks I have loads of simple forms with simple actions & its handy if they are all in the same file Richard

I had a problem with concept when I first started, In theory you don't need phpmyadmin at all, just the mysql control console. I have loaded a wamp server onto my portable which allows access to all the config files. Its quite difficult to request access to various files if you don't know of...

Hi Obviously I am not stuck as I could go back to my original method of calling a completely seperate file (updatefuel.php) It would be nice if I could encapsulate the code with the calling form as neither are very big. At the mo I get error 404 Richard <th height="206" scope="row"><form...

This is how I solved it I created a group Put the top part of the quote in the group header and the T&C's in the group footer. I had to be careful about "Floating" otherwise the fields in the group header would vanish. The T&C's will wrap onto the next page no problem. I still think a word...

Thanks everyone for your help The report is a quotation and they wanted to put 24 lines of text on the bottom. I overcame it by stretching the report and placing it in the footer. I couldn't just type the text in as the customer wanted the ability to change the t&c's. Personally I would have...

I have a stretchy line in a report which contains the terms & conditions. It is in the page footer area and contains 24 lines of text which should push it into page 2. Unfortunatly nothing is printed. Anyone have any ideas Richard