Search:
Type: Posts; User: lok1234
Search:
Search took 0.07 seconds.
-
Many thanks. There would be around 5 to 6 products. I could not use database as it is just an desktop application for sales.
Actually, can I "pass" the enum from each product worksheet to...
-
Hi all,
I have been asked to enhance an existing Excel application by my boss. This existing Excel application has a module called mdlCalcFee. Inside this module, there is an enum declaration as ...
-
This also work, thank you.
-
Hi all,
i have a worksheet A, it has a button and a pull down menu there. The pull down menu stored a list of named range name. Also, I have worksheet B with lots of named range there.
When...
-
Many thanks, all guys! I got the solution
-
Many thanks for your help. May I know what the meaning of this code behind? CountIf(cel.Offset(-cel.Row + 1).Resize(cel.Row), cel)
-
Dear all,
I have the following data in a worksheet
Col A Col B
Country Total
UK 100
USA 200
HK 300
-
Dear all,
Background:
I have a Table as below:
133063
Basically, this table shows the status of the employees of a company from Dec-15 to Mar-16.
Pivot Table Result:
-
Dear all,
I am currently using Excel 2003. One of my worksheet has so many complex cell formulas which makes the excel response slow when i open/close/save the workbook, therefore, I place a...
-
Dear all,
I just have written a very simple Excel so that users can operate (update/insert data) it.
I don't want to put it in a "share driver". Instead, I want to put it in a web site so that...
-
Many thanks, Is there any code sample? :blush:
-
Dear all,
I am writing a lucky draw system.
when user presses the "Start" button, all the participant names will be looped and displayed fastly in a label until the user press "stop" button,...
-
thanks, this is what i want. :wave:
i dont know there is a cstr().
what is the difference between str() and cstr() :wave:
-
Dear all,
I have a function to handle a value parameter:
Function f_dec2str(p_Value)
Debug.Print p_Value
Debug.Print Len(p_Value)
Debug.Print...
-
Many thanks for your comment :thumb:
One of my concern is, it is possible for price_difference to have up to 7 d.p.
So, is there any other datatype that can support 7 d.p.?
-
Many thanks for all of your reply. :wave: Since I don't have the database on hand now, so, I can not show you the sample data at that moment :o
can I code it in this way to avoid the error (as I...
-
Dear all,
I have a table called "Price" in Access Database.
And I use the following codes to calculate the Price Difference.
(I extract part of the codes here)
Dim aRs As New...
-
thank for your information.
One question, in case the six OCX files are placed in common share folder, will the exe "read" the six OCX files in this common folder instead of users' local PC...
-
Dear all,
Is there any function that i can use to random generate date and time?
Say, I pass "23-June-2010" and "09:00 to 18:00" as the parameters, the function will ouput a datetime within...
-
Dear all,
I have six OCX files need to be used in my project, they are:
MSCOMCT2.OCX
MSDATGRD.OCX
MSFLXGRD.OCX
tabctl32.ocx
MSHFLXGD.OCX
MSCOMCTL.OCX
-
prefect solution. thanks a lot
-
Dear all,
I have a Listview. There are 5 columns in this Listview. How can I know which column in the listview is being right click?
For example, the user click the right button of mouse...
-
i see, many thanks. That means, i should restrict the content in the combo box instead of using coding. :)
-
this is great, many thanks :thumb:
but, in case, i have an item in the combo box, say "David Beckham". If user enter "Beck", how to make the "instr" can search this item?
:wave:
-
Dear all,
I want to code a textbox which behave like "google" searching (as in the graph below). When user input a keyword in a textbox, say, "visual bas", it will display all relavant records in...
-
hey, guys, thank you so much, without ur help, i cannot say in programmer position, thanks:wave::thumb:
-
thank you again. :wave:
a side track question:
Open App.Path & "\test.txt" For Input As #FF
strFile = Input(LOF(FF), FF)
Close #FF
can I start the reading of the test.txt file in the...
-
thank you :wave:
is the disadvantage related to "consume memory" and "slow performance" if the file is large in size?
-
Dear all,
I use the code below to append text to a text file:
Open "c:\abc.txt" for Append as #1
If I want the appending to be "last in, but on the top of the text file", how?
...
-
thank you a lot for all of your input. I have learned from you all. :)
-
Hi, i suppose your "inside timer1" means "Private Sub Timer1_Timer()"
If this is what you mean, then, your code could not make the label refresh the time every second. It will permanently display...
-
Timer1.Interval = 1000 '~~~> 1 second
Timer1.Enabled = True
Private Sub Timer1_Timer()
lblTimer.Caption = Time '~~~> Display the time in Labelbox
End Sub
The above code make the...
-
Hi, many thanks for your reply :wave:
Your suggestion is working fine, but in case,
the command prompt is waiting for user's response (e.g. prompt options for user to choose), but the user...
-
hi,
i tried to implement the shellpipe user control into my project. What I have found is, there is "cmd.exe" in the task manager which cannot be killed when i terminate the project. This happens...
-
is it possible to select rows in mshflexgrid using the ctrl key and is there any function returning the selected rows?
ie.
user can select
row1
row3
row7
function return which rows are...
-
Thank you for the comment from both of you. It really helped me a lot. :wave:
-
thank you:wave:
in case the dept_id is string, how to deal with it?
-
Dear all,
I have the following "type" defined and when form is loaded, datas are loaded into the types:
Public Type typDept
Dept_ID As String
Dept_Name As String
...
-
haha, yes, the spCMD is picturebox after I move the form to my project. Therefore, it is just copy and paste error. Many thanks for your kind help :wave:
-
hi,
I have added the user controls (shellpipe.ctl) and smartbuffer.cls into my project, and also, copy the file shellpipe.ctx into my project folder. When I compile the program, it says:
"Method...
|
Click Here to Expand Forum to Full Width
|