Dear All,<br/>have any SQL query to Retrive/show the structure of a perticular table. (SQL Server200). <br/>Regards<br/>Vahid

Ok, so I am rewriting the macros for my job, and I am stuck.This is what they are suppose to do.1) Open a work doc2) Copy the text3) Close word4) Post text in the Email it was executed fromI am running in to an issue with I believe activewindow. Here is my script:Sub Test2()' We need an easy p...

Hi everyone,I have a weired situation right here. My module was working perfectly all along. This morning I tried to run and got a run-time error: 1004 Application-defined or Object-defined error on this line of code. With xlWksht.Range(Cells(ii + 1, 1), Cells(ii + 1, 5))Below is my entire module:...

I need to automate a start up procedure and I need to enhance a VB 6.0 application.I need it to Automatically click a radio button and then an OK button on a seperate .exe. I do not have source code for this 2nd app....just the.exe .The application pops up on startup and my server will not continue...

VB 6.0 - Drawing an underline at the end of each recordHello members,I am trying to underline the end of every record in my spreadsheet. but it's not working. I am using the codes below and it has no effect on the spreadsheet whatsoever. Could anyone tell me what I'm doing wrong?ii = 5...

I want to create a thread for a SUB (procedure) which will open a connection & recordset based on the parameters passed to the SUB. I had created a thread which works fine, but without any paramter. But now I want to create a thread which will pass the parameter to the SUB & then it executes.Declare...

greetings<br/>is it possible to create table from vb6...<br/>the fld that i have to use is stored in a table..which is being updated..<br/>thanks<br/>cyrus

Hi guysI have create the forms with the images on it but I want to know if there is possible to change the skin on both forms at the same time and save into the registry so on the next software start the skin stay the same where it was, if I wish to change it then I have to click the button to excha...

hi all, i have a problem.Suppose: you have an image (jpg, gif) of OPEN Dialogue Box. How to come to know about the parts of this image when i click on the image different parts like When i click on the OPEN button prog tell me by a msgbox you clicked "Open button of the image" And when i click on th...

I am trying to measure the exact time it takes to get a solution in my program. I have used timeStart = gettickcountprocesstimeEnd=gettickcounttimeTaken = timeEnd -timeStartThe problem is that its like the time takes is in factors of 10's. Its like time is not being registered every milli secon...

greetings,<br/>I was able to create ADO table thru VB6, using another table to create the fldnames, my problem now is making a report out of it,<br/>is it possible to insert labels to datareport, this labels will be extracted from a table.<br/>thanks<br/>cyrus

HiI don't have problem with doing such application, but I have it completed, and I'm not sure whether it works good.My program browses EAT list of a loaded library, and shows:- name of all APIs (including 'empty' ones)- their addresses (calculated from library)- addresses retreiv...

hello all,i have a project in which i have to save all images needed for the project at run time. In a saperate file also i have to store some string in that file. MEaNS: i have to store both images and string in one saperate file. The problem i can not do it with Resource at run time. But i found t...

hello all,i have a table "Employee"Table fields are:-1) ID int type2) Date1 date type3) Reason varchar typei have made a application in VB, in which this three text field i have taken.in VB, those fields names are: 1) IDname 2)DateDisplay 3)ReasonDisplayNow if user enter any data on the form, this s...

Dear friendis it posible to check weather our own application system tray icon is loaded or not in to the tray? coz some time i see when xp starts, my app is running but the icon is not shown/loaded in to the tray.May be i have called the system tray icon code after some critical startup routins (os...

Hi :We need to send fax using visual basic 6.0. Fax numbers are stored in database. We are using canon fax printer (canon IR4570). We have installed Microsoft Fax service on windows 2003 server. We are able to connect to Microsoft Fax Server using Fxscomex.dll from visual basic but unable to connect...

How to Determine that Currently running VB project or Exe <br/>I tried <br/> If Command() <> "FromVB" Then<br/> RptPath = App.Path & "\Reports"<br/> End If<br/>but not working properly

When I attempt to copy a Shortcut file from one location to another using the FileCopy command, I receive the following error: Run-time Error 53 File Not FoundNote: when I copy other file types such as excel, or access etc. from and to the same directories, there is no problem. Heres a snippet of t...

I understand that VB6.0 is no longer available through retail. Any suggestions on where to purchase a slightly used product?<br/>Thank You,<br/>Hank

how can i do formatting with a part of a label caption?<br/>consider <br/>label1.caption="This is Some TeXt"<br/>when i click on button then label caption should be like<br/>This is Some TeXt

suppose i declare an Array <br/>Dim MyArr[100] As Integer<br/>when memory of the above declared array will be allocated? suppose i use only 10 indexes of the Array and leave remaining 90 Indexes.<br/>will remaining 90 indexes will grab memory or not if they are not in use?

Dear All,<br/>While going through the Vb code , i saw a code like below.<br/>ACounter = ACounter + 1: FldNameVal(ACounter) = UCase(Trim(!FieldName) & "")<br/>Why they are using Colon( : ) after Acounter+1<br/>Expecting your Valuable reply ASAP<br/>Regards<br/>Vahid

Hi,I need to retrieve some data from a text file. Below is what I did but how could I retrieve student's name & result on history paper?Results.txtEnglish PaperNames ResultsChris 98Jenny 66Mark 73Josh 64Ella 70Zinky 64Stanley 55Resttiey 30Mathew 82...

this code does not clear the picture :(<br/>Picture1.Cls<br/>please tell me what is the method of clearing the picture if i have loaded a picture in the picture box?

1- is there any way to use VB 6 to search HDD very fast for a file or folder ? ( like installers )<br/>2- how can i get the CPU/GPU temperature ?! <br/>3 - tell me something about savesttings and getsettings .<br/>4- thanks<br/>6- ...

Hello Friends,i have to write a logic in VB, in that when i hit submit button on the form, there is one database field "ID", it will icrement and store in database always + 1.when i hit first time, it will store like that L0001, then L0002Datatype of this ID = varchar(5)please help me.thanksabhi...

I am using a hardware which has UART pin shared with some other serial protocol pin. So when the hardware is handling data with the other protocol, I get garbage on the UART.Now I have written an application in VB 6.0, which reads this data from the hardware. But I never get the data reliably with t...

I have build a macro in word 2003 and started from word it works perfectlynow I am taking the next step and I want to open the word document from a VB6 application and start the macro.Opening the word file worksStarting the macro works also.But here it comes: Halfway through the macro I get an error...

We have an in house application developed using VB6. Everyone whoneeds to use the program are not allowed to be local admins on theirPCs. I was wondering if there was a way to code the application tonot require admin rights (for modifying/creating excel and text filesas well as modifying the regist...

I have an app that is being tested at different locations. On my machine, things worked fine for about a week. Elsewhere, I sent it last Friday, and it worked fine across town.Saturday after noon, I started getting TIME OUT error every time that I run it.( not SERVER NOT FOUND, which happens when...

I have made an application that receives data from a server using windows socket component. It's already running for almost 3-month ago. Just last 2 days until today, I receive a wrong data instead of something like... "120203 0745 2004 0011...", now my application receives this information "...

i've searched and searched and can't find how to do this. i need to detect if the Classic start menu is being used, as opposed to the XP Style one. note that this is separate from whether or not the XP Visual Style is being used.all i can find info on is a registry key in the Policies sect...

hello all,i have got a very big problem of my life now :( please solve this out. i got fever when i came to know i can not do it myself. i searched approx 4 hours last night but could not find any solution :(the problem is related to my project about which i have been bothering you all.The Problem I...

good morning to all.<br/>i have a problem and no solution.<br/>how can i save/read the input of, for ex. 4 textboxes with the commondialog.<br/>many thanks in advance and greetings

Hello all, I am writing a VB6 app to complete work orders as the forms are turned in. I want to have the app scan the work order (8.5 X 11) duplex and save to a work order file number . The scanner is a docketport 485. Is there a free twain driver out there , I want to scan duplex , pdf and sea...

I someone can help. I have a VB6 ocx which sets a DWORD value in the registry which enables and disables a USB card swipe reader. My problem is that the registry settings only take effect after the card swipe reader is unplugged from the USB port and then re attached. Do u know of a way how I can ge...

how can i do it ? i want to place an icon and a menu in notification area just like other programs ?

Hello everyone.I need to format how a row in my spreadsheet prints. Please see attachment for clarity.Each record is split into two lines, first line prints on the first row and the second prints on the second row. The second line that prints on the second row contains the field "comments". This "...

Please tell me what is the meaning of Simulated Desktop?<br/>thanks for any help

if i have a Form under MDI Form. it has too much controls which can not be adjust in the available size of the form.<br/>so how can i adjust them using scroll bar? what could be the solution of it?<br/>thanks

I am writing a program. I have a list box on the left that will load only the section names from the ini file. so say this is my ini file:[APP1]location=c:\xxx[App2]location=c:\xxx[prog]location=c:\xxx[something]location=c:\xxxI need, on Form Load, to open the ini file and grab everything between th...

After using that wizard, when I install it back, The program cannot detect the database. Can anyone guide me properly how to use it?

hi,<br/>can anyone tell me how to get coordinates in pdf document using VB or .NET, suppose if some text is written in pdf document then how can i get coordinates of that text. Its very Urgent.<br/>thanks in advance.

Hello all, I have Created My ActiveX control and it works fine on my PC in Internet Explorer. I have to use it on web page. so i create a internet package and the html file works great on my PC but when i install it on Client PC it shows the Install option but actually nothing is ins...

Hello Friends,i have made login Form, in that three fields are there, 1) LoginID(Varchar) 2)Password(varchar) 3) EnableUser(Bit)when i press submit, Its access data from database, and validate the information and move to next page, else it will display error msg.(Its working).Now iam get stuck in th...

i want to made an application in VB, in which when i press submit button the form details will sent to particular mail id.For ex:- i have form, in which two fields are there 1) ID 2)Descriptionwhen i press submit button on this form, the details of this form, will mail to "abc@yahoo.com".how to do t...

how to update records rollno,name in a stud_info table, using update query . <br/> code:<br/> "update stud_info set name=" & text2.text "where rollno=" & text1.text<br/>but for this i am getting error

Hey<br/>I can get the processes with a snapshot with enumprocesses api... but seems like a waste with a timer... is there a system wide process hook that is triggered everytime a new process is started?

Hello everyone,I am having a display problem within my spreadsheet. The data in the spreadsheet row is hidden. Looking at the spreadsheet, you will see that the row that contains the "comments" is hidden, but when you manually expand the cells, you see the data. I have a code within my module where...

Hello. Im wondering what would be the best free VB IDE? Any suggestions?