Recent content by bpratl

Unfortunately they are using Publisher 98 so Tamar's suggestion of oPub = CREATEOBJECT("Publisher.Application") Did not work. I have not tried it with a later version. Mike Lewis ShellExecute() API works great and solved the problem. Thanks for quick response.

How would I go about running MS Publisher from a VFP application? I can run EXCEL and WORD without any problems but Publisher won't work for me.

Hi, Thanks for all that replayed. I will take your sugestions and post results. Bob

Hi, We have a small network,with 4 workstations,using a POS system with VFP 9.0. The problem is at closing and doing the nightly reports and updates everything goes well providing all workstations are log off VFP. If any stations are left on the progran crashes and files are not updated...

Mike, The History form (modeless) is displayed when clicking on one of the three last invoice numbers,which show up on the order entry form (modeless). The labor edit box is a Chado Spelltext Active X edit window. After reviewing sales history(read only) and releasing the history form, the Edit...

Scott, There is nothing abnormal in the Active X Spellchecker properties. Bob

We have a order entry form with a Active X spellchecker control, for a note field, which works fine until we added a Sales Histroy form to display past order data. The form pops up when Icon is clicked. The problem is if the History forms Windowtype is set to Modeless the spellchecker field is...

Mike, Thanks again for your reply. Yes we are using a laser printer. The old dos POS system is using 8.5 x 5.5 forms on perforated plain paper. Thw invoice is delevered with the order, signed and them seperated. The customer is left with their copy. The system is now using VFP 9.0 SP1 and the...

Hi again, Info for mgagnon: 1. Does it work on any machine? 2. Are we talking dev machine vs user machine? No - same results on three different machines. 3. Have you save your report with the custome size as a default setting for your printer driver? Yes - Saved in the reports...

Mike, I am testing and running the application from my MAIN.prg in the project manager. I have tried two different laser printers, HP1020 & Lexmark R232. Is the report sending a page eject when it see's the page footer? If I send a single form to the printer with a "nopageeject" nothing is...

Mike, Thanks for your reply. I set up the custom form size as you suggested,in the SERVER PROPERTIES and on the invoice form in the report\printer properties\page setup. The invoice prints out the proper size; but on two seperate sheets. How can I surpress the first page EJECT - ("nopageeject"...

Hi, In the process of upgrading FP2.5 to VFP9.0 and am having problem in trying to print two short (8.5 x 5.5) POS invoices,with laser, on one perforated 8x11 paper.One is customer and other is store copy. Setting up short 5.5" form is no problem. The problem is we keep getting two invoices,on...

The form in question is for selling & quoting on part sales. It uses three tables: Customer, Order & Inventory. Parts are displayed in a grid. All works well when selling a stock part from inventory. When trying to sell a non-stock part we use append blank, update customer # , quantity & sell...

When appending the first record, to a grid, on a form we get a error 2072 - "Cursor cannot be modified" during a replacement. Buffering 5 is being used. Adding tableupdates and moving record pointer has no effect on this error. This only happens when the grid is unpopulated.

Thanks to all who responded. QueryUpload plus a SAVE methode did the trick. Bob