Search results for query: *

Hi Guys I hope there is someone out there that can point me in the right direction to clear up a bit of an issue I'm experiencing. I have a select case statement that is based on a value in a combobox but it doesn't appear to be working as I'd expect Here is the code: dim selectedtext as...

Hi Guys, I hope someone here can point me in the right direction. I need to be able to sort a list of filenames in a directory by date and time. I know I can use ADIR to get a list of the files into an array and I can use ASORT to sort by the date the file was last modified or the time the file...

Hi Guys, I wonder if anybody has any ideas on an odd issue I am experiencing. I'm importing a list of product codes from an excel 2007 spreadsheet using Automation. One of the codes is 111.00206 and my VFP 8 program is interpreting this a numeric value. I am not bothered by the fact that the...

Hi Folks Bit of a weird one this. I've got two access databases same version of access, exactly the same structure (just store info for two websites) I go into one and do a simple query and I get back the expected results. Go into the other copy, and paste the exact same sql statement and I...

Hi Guys wonder if anyone can help. I have two databases. structure is exactly the same (just link to different websites). I run a query on one database and get the expected results. Run the exact same query on the other database and i get errors. Either data type mismatch errors or driver...

Hi folks I wonder if anone can help us with something. I have a table with 86216 records 202 fields and it is 397meg in size. If I query the table and select just one numeric 8 byte field and 3000 of those records over the network into a cursor it appears to be transfering over 17 meg of...

Hi Folks Am I correct in thinking that if you have expressions in the page footer of your report then the report file will always account for the amount of space assigned to the footer even if you use print whens to display the expressions on the last page only ie if there are more details...

Hi folks Is it possible to issue the 'copy to filename type xls' command to a worksheet rather than a workbook? ie can I open an existing workbook and copy the data to a particular sheet without automation? Automation is OK but can be a bit slow for some purposes. Thanks

Hi folks I've created a report using VFP8 that uses a calculated field in the detail section of a report. I copied the calculated field and placed in in the footer of the report and selected SUM to total it. It seems to work fine up to about 34400 records but after that the result is that the...

Hi folks I've created a form with a few combo boxes that a user can select from and then run a report based on the values selected. It seems to work pretty well but I'd like the form to remember the values selected the last time the user ran the report. Is this possible?

Hi folks. My VFP 8 reports are doing some weird things with the page totals. Sometimes the final page prints "Page 10 of 10" (correct) Sometimes it's "Page 9 0f 10" sometimes it's "page 10 of 11" Has anybody ever come across this before?

I have a problem whereby I have sent one of our users an excel spreadsheet which uses MS query to extract data from a VFP database. When refreshing the data the query returns nothing. I have checked the ODBC link and it is fine and there are no parameters in the query that would stop the data...

Hi folks Hope you all have had a good christmas. Now back to work......zzzz Is it possible to display a list of available fields that a user can display in their reports if the report is based on a cursor? The problem I have is that our customers always phone up and say what is the...

Hi folks Is it possible to count/record the number of times a workbook has been opened?

Hi folks I'm having a bit of a problem trying to left Justify a numeric field on a report. I have tried all the usual stuff in the report expression boxes. Weird thing is if it is previewed in Acrobat, everything looks fine but come to print either from Acrobat or from our program the field...

I have managed to export into excel a list of all tables and fields from a VFP6 Database (with a lot of help from this community) I would also like to export the field comments. Is this possible? I have managed table comments but not the actual field comments. Any ideas would be appreciated.

Does anybody know a way of scanning an excel workbook for a text string and if the string is found, then making the cell(s) in which the text string resides bold or coloured. Can this be done in code? Any help much appreciated. Thanks

Is there a way to export table and field names from a VFP6 database along with any comments from the field comments box or a way to show that a field from one table is related to a field in another? I hope that makes sense, I am new to all this stuff! Any help is much appreciated. Thanks