Search results for query: *

There is a difference in my top and bottom margins when I print a report directly from vfp9.0 and when I create a pdf from XFRX. Does anyone know a way to correct this difference? It causes the line and page counts to be different between the two.

I'm using the APPEND FROM command to append all the records that match my index.

Is it bad design to have more than 1 memo field in a table?

I am trying to do a restore of data where I backed records from a table into a storage table. This particular table has 6 memo fields with data. Just 15 records into the restore and my FPT is 20M in size and I have over 3000 to restore. Any ideas how to reduce the size of the FPT table. I...

Thank you all for your input. Wbstrider's comment was on the money! All I had to do was move the GO command to after the setfocus. This is why I come here for answers. Thanks Again Ralph

OK I must be doing something wrong because I put the code below in my header: nrec = RECNO() MESSAGEBOX("recno = "+STR(nRec)) SET ORDER TO TAG tagInpDate GO nRec this.Parent.Parent.SetFocus MESSAGEBOX("recno = "+STR(RECNO())) The first message is 670. The second message is 62. It appears that...

I have an application where I want to allow the user to change the display order of a table in the grid by clicking on the appropriate column header. I have tried using the code below. The order changes but the cursor does not stay with the current record. When I click on the header a second...

Mike, sorry for the lack of feedback. I have read all of the suggestions but, due to schedule, I have not had opportunity to act on any of them. Thank you all for the suggestions. We have used the SET FILTER command quite extensively and this is a very large application so it will take a...

I have a foxpro application that opens 200 tables. About 1/3 of the tables are read and all of the records are written out to a report. The other 2/3 of the tables are referenced only for certain match conditions. Processes that run in 20 sec on a standalone machine are taking 3 minutes over...

I have a modal form that processes a design. From that form I launch a modeless form (do form) that contains an ole control that displays an autocad drawing of the design. I have 2 monitors so I would like to keep both forms up and move the modeless form to the "other" monitor and work on the...

Mike, Thanks. We had already tried your suggestion but unknown to us the bitmap another version of the bitmap we were trying to load was imbedded in to the project and it was always pointing to that copy so it didn't seem to work. When we removed the imbedded bitmap everything worked...

We have a retail application created in VFP 9.0 and we are creating VFP reports for it. We need a way for the customer to EASILY add their own logo into the header of the report. In other languages this is possible with an external reference to a bitmap (ie VB load picture "companylogo.bmp")...

We actually have a trap in the code to exit with message if no data is selected. Data was being selected but, we can only assume because of the date format conflict, the active reports module was somehow generating the error. Any other insight is welcome. I will continue to monitor this...

Thanks for all the help. We actually discovered that the date format was incorrect. The computers where the program worked had the short date format set to mm/dd/yyyy. The computers where the program didn't work had the short date format set to dd-mmm-yy. Once we discovered this we were able...

The above error is generated on both XP and W2K machines. The application works on development our machines but when we try distributing and running it on another machine we get the above error. This app is a VB 6.0 app that uses ADO to read VFP 9.0 tables to create a PDF from Active...

This is the same app as my previous post. We have it working on development machines but when we try distributing and running it on another machine we get the above error. This app is a VB 6.0 app that uses ADO to read VFP 9.0 tables to create a PDF from Active reports. I have looked at...

Thanks everyone but we have the problem solved. The problem was in the CONNECT string. We were using "DSN = VISUAL FOXPRO DATABASE" when we should have ben using "DSN = MICROSOFT VISUAL FOXPRO DRIVER". Thanks again for the help Ralph

We are developing a VB app and are trying to create a recordset from a VFP table by filtering on a field with a DATE datatype. We continue to get the following errors. [ODBC VISUAL FOXPRO DRIVER]MISSING OPERAND or OPERATOR/OPERAND TYPE MISMATCH Below is an example of the code we are using...

I'm using VFP7.0 any chance it was fixed by 9?

I'm sorry I left out part of the description. The combobox is in a column of a grid. The only way to really display the values like this is to set the column sparse property to false. I didn't expect it to be a pageframe problem either. Just added it because of my research.