VB Forum / General / April 2008

This solution provided a few days ago has a hick-up.
       fConvertedNum = fOrigNum * 10 ^ (iOverride - (CInt(Log(fOrigNum) /
Log(10)) + 1))
If fOrigNum = 50030, and iOverride = 5, then 50030 should return unchanged

I've got a small Visual Basic 2005 application that creates an excel
file and I would like to get the date from a datetime picker on the
application into Excel.
I can get the date in but my problem is that in the Excel file I have

I know I'm going to be called a troll and told to leave and victimised as
usual for asking this but against my better judgement I really have to ask
this. Out of all the things that could be discussed here the one thing that
gets the most attention is (drum roll......) dot net. ...

Hi, all:
I'm changing my computer, and I have a set of local controls on the old
machine. Where can I find a list of all this controls which appear on the
Project/Component view (within the IDE).

I Googled this like crazy and can't find much.  There is a lot of code
claiming they do it, but they are using a new form and using it like a
PictureBox.  I could do it this way if I had to, but I'd prefer using just
PictureBoxes.  But maybe it's not possible?  I basically just want ...

To refresh controls (make them visible again) after resizing the form I do
resize the form again by calling Form_Resize routine.
That works, but I do not think that is the proper way.
Form.Refresh does not help.

ListView in Report mode:
How to prevent the highlighting of the text in first column when user clicks
on it?
Jack

OK,
Here is a really strange one.  Maybe someone has seen something like it.
I would like to convert a number to a char.  Not in the ascii terms.  65 =
a.

I have a VB6 program running under either client server or terminal services
with a SQL server backend.  Can the server or SQL server be set to logoff a
user after a period of inactivity or can this only be done with code in my
VB6 application?  If so would a timer need to be put ...

apologies in advance for (as always) too long of a post...and a too-general
OO question....design related rather than implementation i think.  let me
know if this is totally inappropriate.
per ralphs suggestion, thanks ralph, I've been reading(and re-reading <g>)

Ken, Rick...  etc...  It's been a while.  dnagel here...
I am in the process of trying to decide how to grow my team at a
company I joined about three months ago.
I have realized theres a weakness in our reporting system offerings so

I'm chaging my computer hardware, but I want to keep all my IDE
options(editor format, etc.).
So, Where is the configuration file?
Thank you.

I have a strange problem.
I am using the FileSystemObject to create a new directory.  Then try and
copy files into it.
The target folder location is in:

Prior to Office 97, I purchased VB 5 Learning Edition to prepare for
(ab)using VBA.
In Jan 1999, I purchased the upgrade edition of VB 6 Professional.
For whatever reason, I was not able to install VB 6 Pro, even after

How can I draw a cardinal spline smooth curve between four points in
VB 6, and then import the result to Crystal Report 8.5? Does anyone
know?