Search results for query: *

Hi all, I try to run a sample.mdb program and get an error message compile error, can't find project or library ? in the VBA editor Please explain what went wrong ? Thanks in advance,

Hi all, This is my codes in Visual Foxpro, can someone who had knowledge of VFP and VB, helps me to convert to VB. Thanks in advance, CREATE CURSOR crsResult (account C(10),amount N(15,2), percentage N(6,2), ClassCode C(5)) SELECT MyTable INDEX ON Account+ClassCode TAG MyTable && With proper...

Hi all, I started my coding to calculate : account amount classcode percentage 11111 100 AAAAA 0.16 11111 200 AAAAA 0.34 11111 300 AAAAA 0.50 --------------- subtotal 600 11111 100 BBBBB 0.16 11111 200 BBBBB 0.34 11111 300 BBBBB 0.50 --------------- subtotal 600 here is the...

Hi all, How to create the formula to calculate the percentage out of the total in general format can be used all along ? from myExcel.xls account amount classcode percentage 11111 100 AAAAA 0.16 11111 200 AAAAA 0.34 11111 300 AAAAA 0.50 --------------- subtotal 600 11111 100 BBBBB...

Hi PHV, I appreciate that solution in the thread 707-1057331 but I have to copy one by one that formula to each cell, it's taking more times. That's why I need someone to help me to create the codes in VBA in a loop. Thanks again,

Hi all, How to create the formula to calculate the percentage out of the total in general format can be used all along ? from myExcel.xls account amount classcode percentage 11111 100 AAAAA 0.16 11111 200 AAAAA 0.34 11111 300 AAAAA 0.50 --------------- subtotal 600 11111 100 BBBBB...

Hi all, How to create the formula to calculate the percentage out of the total in general format can be used all along ? from mytable.dbf account amount percentage 11111 100 0.16 11111 200 0.34 11111 300 0.50 --------------- subtotal 600 22222 200 0.25 22222 200 0.25 22222 400 0.50...

Hi all, I created a macro16() to copy and paste as you can see below but always copied to the same row means the first row How to correct this macro to copy to second row and so on...? row1 john doe row1 brian die to get : row1 john doe row2 brian die Thanks in advance, the codes by...

Thanks Tony, It works great.

Hi all, How to create the formula to calculate the percentage out of the total in general format can be used all along ? account amount percentage 11111 100 0.16 11111 200 0.34 11111 300 0.50 --------------- 600 22222 200 0.25 22222...

Hi Skip, Perfect to built combo box, I can select 11111 from combo box and how to past that to the new cell ? TIA

In the Excel workbook

Hi all, How to use combo box in the Excel workboot ? empno: 11111 22222 33333 44444 in order to select empno from combo box Thanks in advance

Hi Frederico Fonseca, Here is the first sheet1 need to be fill from sheet2 and sheet3 in the same workbook. sheet1: Bulk Issue Name Coupon Mat Date 1 FORD CREDIT CDA 2 3 4 sheet2 : ISSUE_NAME COUPON MAT_DATE FORD CREDIT CDA 5.96 3-Dec-35 GM US CIE 6.05 27-Jul-09 SHEET3: ACCOUNT...

Hi Frederico Fonseca, I would like to achieve the input cells from one sheet to other sheets for example : sheet 1 has : cell1 to fill in from sheet2 that contains acctnum# as primary key with custname,address,tel . like in the combobox refers as arrays to be built. When the user picks the...

Hi all, I am very new to VBA and Excel workbook, someone told me to use an array would be very advantage instead of using macro. Please give me some advices and tips to start with an array. TIA

Hi all, I have several vfp programs that needed to redo the complete test for each module. I need advices how to create test data from scratch, either from an existing tables or from the sources codes for each module OR both ? means to have the maximum scenarios possible during the test of...

Hi all, I always have this error : Alias 'oApp' is not found error in my code here: If oApp.lQuit Return ENDIF Please help to explain. TIA

Thanks a million for all to guide me to the right spot.

Hi all, I know we can save myreport.frx as myreport.html while opening it. How to do it inside the program and to call the browser to view immmediately ? Any help or advice would be reallly appreciated ? Tia