Recent content by ggreen61

I would suggest making a copy of your report first. Then hack the report by opening via USE reportname.frx. Then manually set the hpos value to the same value for the objects that you want to be all aligned.

In order to prevent a user from being able to browse to a share that contains the tables, I have used the following strategy: //sharename/protectedfolder/sharedfolder The protected folder user rights are not granted to the business users. The sharedfolder user rights is granted to the...

I am not sure why you are posting this. What is the point? Are you just show casing your work? It does not seem that you are asking for any solutions to a coding problem and are just showing screen shots of your application. Without access to your code for anyone to evaluate it is no use to...

Try for your select statement: SELECT * FROM PLANPROD WHERE ALLTRIM(UPPER(PSTAT))=="PENDENTE" INTO CURSOR curPedProd

You might be able to speed up the VFP version by increasing the BLOCK size value. Instead of 8192, you might try sizes greater than 10 megabytes... This would be less reads performed. I believe that when comparing two string values, VFP will stop comparing when a byte is different between the...

What is your Windows printer driver -- I think you have to use a Raw printer driver.

Create the following index on your field that contains the grade value (where grade is the field name): INDEX ON PADL(ALLTRIM(grade), 10, '0') TAG grade Now use this index to set the order for display. If you want to select the records then use the same PADL() expression in the ORDER BY clause.

When the machine is rebooted that is running VFP IDE, the VFP running process is terminated by the OS. This is not an orderly shutdown that would allow the command history to be saved. You would need to use a method as described above that the user can trigger to save the contents to a file...

What if you select the two tables separately in a UNION clause? Use place holders in the missing fields for the first table.

Instead of using a textbox to determine the image, you could provide a lower section of the form that provides the images that are available. This image list could be scrollable and a user would select an image and then drag to the location desired. I ditto the use of a table to manage the...

My solution to the problem of RLOCK of a record by one user that another user needs access to, is to not use RLOCK. Instead, I have a table for managing the locks - tablelock.dbf. When a user selects a customer, supplier, etc. record to be edited, I add the record Id to the tablelock record...

I use the following code to do a similar select. I use NVL() function when the values are to be displayed. SELECT inv.invoicedate, inv.duedate, inv.billto, inv.stataxes, inv.loctaxes, inv.cittaxes, inv.shipping, inv.totaldue, inv.amtpaid, inv.memberid, mbr.membername, ; itm.price...

I have a similar application with a tab interface for selecting between forms: The first row allows the user to select between different tab groups. The second row allows a user to open a form into the group's tab interface. When the user selects a command button to open a popup child...

The only suggestion I have is to use the RemoveObject() method of the VSPE's parent control to first remove the control before you close the form.

To everyone's point that you have to have a table/cursor that drives the page output. Using variables would cause every page printed to have the same value -- no point to print more than one page. If each page is supposed to have different values, you could create two cursors that contain 150...