Search results for query: *

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...

Thanks for your quick reply. I tried to use DTS and had some problems. For example. I need to migrate data to MyTable. This table realted with TheirTable. So I must update both tables. I could not find DTS options to do that. I am sure that I missed something but I do not know what.

I am not DBA Person [sadeyes] but need to do that :-(. How can I Copy/Move data from table in Production Data base to the same table in Test Database? Is there some tool/option in SQL Server 2000. Need help ASAP. Any help will be highly appritiated.

Thanks a lot! It dies work! You help me a lot! [thumbsup]

Thank you Hubajube. I'll try it.

Is there a way to export the layout definitions of each table of particular database to some type file that I could then import into an Excel sheet?