Recent content by COII

Dear all, Thank you for your solution. I just tried to all of your suggestions. That's great! Thank you very much. Actually, I used it for calcuation of dimension (M3). ie. carton size is 60x30x30cm, and I must calculate its cubic metre... But carton size must also shown worksheet.

Thank you. But it seems that it is complicated for me.

Dear all, I have a question for using Excel. I would like to show formula in A1,e.g. 1+2+3 but its result shown is B1, e.g. 6. Anyone can help me to solve it? Thanks.

Dear all, I have a form include two subforms. Tab order will be sorted by : 1. enter all fields in Mainform 2. then shift to "A" Subform to continue enter field 3. Finally, shift to "B" Subform after finish input for "A" Subform It got a problem on "B" Subform. When I finished input in last...

It works now! Thank you for help. COII

Dear all, A few year ago, I used an method to hide the menubar when open the database, it shows as follows: Menubar [FILE] [EDIT] [INSERT] [RECORDS] [WINDOW] [HELP] No edit/design command involved in these menubar. I remember that click "shift" when open this database, all menubar, toolbar...

The formula is: B2 =COUNTIF(month!J:J,"STUDENT"), something like that. COII

Actuallly, I copied data from Access file to Excel every month. I will paste them to "Month" sheet. Before it, I must delete old data in "Month". Select the data range and press delete. Formula in "Summary" cannot work immediately. Display as #REF!. How can I do? COII

Dear all, I have a question about cell reference. I have two spreadsheets in Excel File. One sheet named "Month", and the other named "Summary". "Summary" have formula for counting data of "Month". I should get updated data for each month. Like this...

Dear all, I just got a problem in Excel 2002. I have 3 worksheets in workbook. I inputed a formula to a cell for calculation in one of worksheets. It appear a formula only not result. I try to use the method which provide by Microsoft Help, press Crtl + ` to show the result. But cannot work. I...

Dear all, I have a Table called "Staff" and I would like to create a query for this table. The condition is : [Last Name] field must contain "Jackson" word and count the number of these data. just like as below: Last Name Count Jackson 18 William...

Dear All, I would like to create a gif file to place to Html file in XP if only used XP Pro. How can I do? Manda

Thank you for your advice. But, Is there no other method can improve it?

Dear all, I have a word file and transfer it to HTML file. That is everything alright when I view it by IE. But by Netscape, all bullets & paragraph setting is changed. Can someone help to solve this problem? Netscape is my main browser. Thank You

Hello, I have some question. If [ID] is text Field, this VBA cannot work. Any method can help me?