In the click event for your command button you need the code
'clear combobox1
ComboBox1.Clear
'add blank item
ComboBox1.AddItem ""
hope this helps
Stephen
There is a VB function called StrConv which will convert your string to proper case.
Try
StrConv("hello world", vbProperCase)
This however will not do abbreviations like NE of EST, however you could add these custom requirments to your own function. e.g.
Function...
Just relised the answer myself...
a LIKE b is looking for pattern b inside string a
where as
b LIKE a is looking for pattern a inside string b
Sorry for opsting a question and then answering it five minutes later...
Stephen
In a SELECT statement I have a condition along the lines of columnName LIKE '%'.
I have noticed that this gives different results to '%' LIKE columnName.
Why is this? I would have thought that the LIKE operator would behave as the = operator, as in a=b is equivalent to saying b=a.
Does anyone...
The following will terminate the process in which Excel.exe is running
strComputer = "."
Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
Set colProcessList = objWMIService.ExecQuery("SELECT * FROM...
Jay,
Thanks I'll give it a go
---------------------------
pgtek,
I need to to refer to the tempory table later so I need it to have the same name regardless of where the data comes from. I didn't make that clear. Thanks anyway
Stephen
I have an IF statement whereby a tempory table is created by a SELECT INTO command. If the IF statement evaluates to true then the data for the temporary table comes from one source and if the IF statement is FALSE then the data comes from a second source. The name of the temporary table is the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.