Search results for query: *

Using OleControl (Microsoft Forms 2.0 Text Box) in Form OS = Windows Server 2012 R2 Run command Prompt with Run As Administrator Locate Fm20.dll in windows\system32 folder Copy it to SysWoW64 Folder RegSvr32 Fm20.dll in both folder get the message of dll registered successfully Restart...

Q. Focusing Grid through Mouse which event of Grid Execute 1st When Event is not executing on Mouse

Calling from Parent Form from one of the command button click event method LOCAL o_Child_Form As Form DO FORM Child_Form NOSHOW NAME o_Child_Form LINKED ; WITH ; Var1 , Var2 , Var3 , Var4 o_Child_Form.Show(1) && 1-Modal How can return the value from Child Form to Parent form of Var1 , Var3

Select Item_Code , Item_Name , Item_on_Hand_Qty where CC = 'USA' INTO Cursor Cursor1 thisform.List1.RowSourceType = 6 thisform.List1.RowSource = 'Cursor1.Item_Code,Item_Name,Item_on_Hand_Qty' thisform.List1.BoundTo = .T. thisform.List1.BoundColumn = 1 Now WITH thisform.List1 As ListBox...

To set Fore Color of Cells using the following command which is Okay oXs.Range('A1' + ':' + 'W2').Font.Color = '-4165632' && BLUE Q. What will be the command for Excel to fill Cells Back color of selected range

Win 7 Pro 64 bits Using Remote Desktop Connection to connect the Server Server Screen resolution set to 1366 * 768 As It is on Network Pc in Remote Desktop Connection Screen resolution set to 1366 * 768 BUT When Run Program.Exe through RDC fonts vision on Screen is not okay some are...

Select SQL Cursor is the best option of Joining Multiple tables in One Cursor especially for Creating Reports There is a Limit of 256 Fields in Curosr or Table IF joining tables for making report on( Group By ) Exceed 256 Fields Limit What is the solution ?

Designing Invoice report on a Thermal printer name Bixolon SRP-F310 Q. There is no page break in thermal printer how can bound page header controls to print once only

Yes worried about optimising SQL Query for this , Choice of List box or Grid is next

Thanks All Using Free table Stock.DBF with Compound CDX all required indexes of stock table created in CDX In Invoice all items required no filter will apply e.g. ON Brand , Make , Available Stock etc. because all stock table required in Invoice because any item required for Invoice from...

Multi user environment There are 15000 or more records in stock table In Sale invoice whole stock table required for this use SQL- Query in form init method to get a stock cursor which contain more than 15000 records When run this form From the Workstation this Sql-Query takes long time...

Locking counter table before getting Counter No with Flock() and then unlock after getting and updating the counter table but still sometime counter no duplicate tested this by running Form and Form showing value from counter table e.g. 101 From command window use counter table and change...

Currently using the following setting of Refresh command in multi user environment SET REFRESH TO 5,3 SET REPROCESS TO 30 SECONDS But facing problem of duplication in getting counter no for sale invoices because many user saving invoice at same time on the network From VFP Help come to know...

I have to apply this on whole column of a table on Alltrim() column will Left Align and i want to Right Align the whole column ALLTRIM(TRANSFORM(XY ,[@Z 99,99,999.99]) ) As ZB_XY,; 1,05,261.00 12,230.00 9754.00 834.50 67.25 9.20 0 showing as blank 34,223.00 210.00

With the help of this showing Zero value to Blank in Numeric column XY = 8542 By Adding @Z in Transform TRANSFORM(XY ,[@Z 99,99,999.99]) As ZB_XY By Adding @ZB in Transform Numeric value Left Justify TRANSFORM(XY ,[@ZB 99,99,999.99]) As ZB_XY Q. How can a Numeric value ( which is...

Creating PDF file of Sale invoices with the help of FoxyPreviewer.App REPORT FORM Sls_Report1 OBJECT TYPE 10 TO FILE 'Sls_Rpt1.PDF' PREVIEW Sometime user select more then 1 invoice How create or what technique use to create separate PDF of every Invoice

How can focus text box with the help of following command ON Key Label Alt+z

How calculate time between 2 given times in Hour minute seconds e.g. a = time() b = time() ? b - a

Select Accna As Grp_Name , MAX(Acccd) As Grp_Code,; SUM(Qty) AS Item_Qty,SUM(Amt) AS Item_Amt,; CAST(0 As N(6,2)) As Pctg_Qty,CAST(0 As N(6,2)) As Pctg_Amt ; GROUP BY 1 ; ORDER BY 1 ; INTO CURSOR Grp_AcWs ; READWRITE Q. What is the way of getting Quantity and Amount Percentages of every Line...

What are the reasons of the following error and how to avoid this error Record is out of range Working in multi user environment