Recent content by kel1981b

Sorry about late reply [purpleface] Here is code example You have to refer to Microsoft Shell Control and Automation Dim arrHeaders(34) As String Dim objShell As Shell Dim objFolder Dim I As Integer Dim strFileName Dim itmAdd As ListItem Dim strCreatedOn As String Dim strFileExt As String...

strongm thanks for your try. Actually I found easier way to do that [thumbsup] - Shell Object. If somebody is interested in code let me know. Thanks everybody. [thumbsup]

Thanks for your try cLFlaVA. Unfortunately, there is no way to get information about file creator using FSO. At least I was not able to find that way. [thumbsup]

I need to write VB 6.0 program to find out who creates particular file. B-) How can I do that? Is there some attributes, functions I can use? Tnanx in advance. [thumbsup]

Here is the problem. We are using Laptop-Dial-Up-RAS Server-IIS(xml)-SQL Server communication to pass data back and forward. It works but works extremly slow. Using Laptop - IIS (xml)-SQL Server works perfectly. Investigation showed that passing data through modem happens quicky enough. At the...

Here is the problem. We are using Laptop-Dial-Up-RAS Server-IIS(xml)-SQL Server communication to pass data back and forward. It works but works extremly slow. Using Laptop - IIS (xml)-SQL Server works perfectly. Investigation showed that passing data through modem happens quicky enough. At the...

I know it will sound a little bit strange or even vierd [sadeyes] but I need to know. Does somebody know is it possible to run msxml installer from VB application? I tried Shell functon but looks like it does not work with msi file ... May be there is some other way or API finction ... [thumbsup]

eramgarden Thanks for your reply 1. "Clean database". I need to drop unused indexes and stuff like that 2. Seem to me you think I am complete idiot or unexperienced person. That's not correct. I started to work as business programmer 10 years ago. So I do know the differences between...

Hi, I'm VB programmer with some VB - SQL server experience who has to start to do DBA job [sadeyes]. I've never done it before and do ot have time to attend some school/courses. So, question is what I can do to Database prove performance. I know I can clean Database but I do not know how. Can...

My question could be not that smart. I need to pass data from SQL Server to Ecel. Is there way to pass data from SQL Server to Excel without using programming languages just using T-SQL?

Thanks for your reply paulbent. Unfortunately, it did not fix problem.

Personaly I hate Excel. But my boss like it. So B-(... Here it is the problem. For some reason, I cannot open .xls file generated by my application till application running. Let me explain. I run the Application, it generates .xls file. So far so good. Now I want to open .xls file from Explorer...

Thax a bunch DrJavaJoe [thumbsup2][thumbsup2][thumbsup2] ! It does work!

I've already knew that. My question was may be somebody know API or ListBox structure which control it. For example using Private Const LB_SETSEL = &H185& SendMessage(ListBox.hwnd, LB_SETSEL, False/True, ByVal -1) you can unchecked/checked all CheckBoxes. So, I was thinking [ponder] about...

Question is about ListBox selected item. I am using ListBox with Check Boxes. Clicking/selecting CheckBox causes highlihting of Item, which is good. However, for some reason(s), Item remains highlighted even if CheckBox is unselected. Moreover, clicking Item itself cause the same effect like...