I'll get it nevermind

does any know how to read a data in a an excel cell then display it in a text box..please help me

hi, i'm follwoing code for sorting data after clicking on a fixed row's columnif grid.mouserow=0 then grid.row=1 grid.rowsel=grid.rows-1 grid.colsel=grid.cols-1 grid.sort=1endifthis works perfectly well except on columns containing dates. Pls help me why it is not working o...

hi,how to map hard disk serial number and or motherboard serial number through vb ?how and where to use it in such a way that once the appln is installed on a particular system, it sholud check for hard disk serial number and or mother board serial number if the same CD is put to installation for th...

hello all,<br/>what is the procedure of knowing how many controls are placed in the PictureBox and what type of controls are place inside it.<br/>Thank You

I open a browser from my program like this:strUrl = " http://www............ ""lngScanDocPId = Shell("C:\Program\Internet Explorer\iexplore.exe " & strUrl, vbMaximizedFocus) 'I can close that window, but if the user close it this code result in an error:If lngScanDocPId <> 0 Then AppA...

Hi all,I have a list box and the items list as in the attachment http://img43.imagevenue.com/img.php?image=00276_ask_122_1181lo.JPGProblem:How should i prevent the list item called "No"(Under display column) from being removed by double clicking it?any help or suggestion is appreciated thanks....

i want somewbody to tell me how to make a program start immediately windows startup and how to make the frm topmost

I am able to set the backcolor of selected text using EM_SETCHARFORMAT and CHARFORMAT2 with SCF_SELECTION, CFM_BACKCOLOR, including being able to set the backcolor back to transparent. However, I am NOT able to READ the backcolor of selected text if its TRANSPARENT, the returned result is 0, which i...

How will i know if the file has been successfully copied?Im having a bit of trouble when im trying to copy a large file because the other files is being skipped.Example:File1 = 700MBFile2 = 1MBFile3 = 2MBDim filx as FileDim foldx as FolderFor each filx in foldx.Files filx.copy(sDest)Next...

Hello Pals,I've written the program to open the number of specific MSWord files from the different folders. All files are commonly names as NEW.doc, but unfortunately one folder got no file such like that, but still I don't want to create a new file on that , instead of that I need to avoi...

I need to find the text in the MS Word..." Commencing on 23rd October 2004 "I need to find the above complete sentence to get that specific date, how can I do that ? because "Commencing on" will remain in the other documents , but the date will be vary in other documents. I need to get the date ....

I want to know if it is possible to develop software in VB6.0 to be used in touch screen kiosks? If yes, then what are the extra things one has to keep in mind as compared to writing VB applications for Windows desktops? For Windows desktops, we handle events like click, MouseDown, KeyDown, KeyPress...

Pls help me ,I am in the final stage of my project. In my application i have around 2500 .doc files in different folders.the file name i have given is like t:\528750\1.doc,528750\2.doc etc. I would like the user to Open one of the .doc file,update it & save. i tried with Document.open("filename",,f...

I am created a ADO control on my form which retrieves records from two tables that are JOIN through the common field .I want to insert the values only in one table using AddNew Method and then using update method.I have used addnew method and receives values from the user in text boxes on the form a...

dear friends, i have created 2 tables one is for "Owner ship"and the other "House"the relation between 2 tables in the owner ID and the relation is one to many!!!!!!but i want to make a relation ship between then that :1 owner can own max of 2 housesand 1 house can be owned by 1 person onlybut m...

Hi all i need urgent help from all u experts here...I am displaying records in my listbox control from my person_Master...While excuting my project runs properly but after some time it gives error invalid array index property ..it is due to inserting records more than 32768...but i hve to show more...

I am using a MSBDC and have some textfields and checkboxes bound to it. When i changed the database from access to mySQL the textfields still work fine but the checkboxes dont react . If i switch it to a textfield it reads 1 or 0 as expected. So, datatypes you say, well right now its a TINYINT(1) an...

I'm sure that this must be a simple one, but I can't seem to resolve it.I have written a procedure which involves a loop. A bit of code within the loop may return an error, and so I have included an error trap.The first time that the error occurs in the loop, the error trap is triggered a...

I am a transcriptionist, and my client requires the patient name to be in the file properties Title field of each file I create. I have some code that will copy the patient name from the report and open the correct dialog box, but I can't figure out how to get it to paste the name in the title...

Heres my problem in my program i have datagrid and adodc and in the form load events i want to filter all records that Pay_Date was less than or equal to todays date, it was working fine before when the connection of adodc was with the adodc object but when i change it to this Adodc1.ConnectionStrin...

Hi all,<br/>I am trying to extract messages from outlook express on a server and file them in a folder. - contact, subject and text<br/>Does anyone know if this is possible or can direct me to a place where I can get help on this.<br/>Many thanks in advance

hi,<br/>i have image data in a variable type Dim imgData() As Byte, how can convert into image file and set up the picture box and also convert picture into Byte() (vice versa) using VB 6.0<br/>any one help!<br/>thanks in advance.

Hi, I want to have a loop and, within that loop, read one line of text at a time. What am I doing wrong?Dim counter As Integercounter = 1For eee = 1 To weekinf(do something)(open txt file #2 for input)Line Input #2, linetext(counter)dateinf = linetext(counter)(close txt file) Print #1, datein...

Hi, I would like to create a program that01 Searches through my emails (in my gmail account.)02 Checks for more than one email from a sender (e.g. 2 emails with the same address.)03 - Deletes any extra emails (thus creating a list of emails each with a unique address.)04 Gives me the total number...

Hi,Im trying to access an MS Access 2003 database within VB6 Enterprise edition. I believe I have got all the code correct to simply edit, add and delete items within the table. However I cant seem to get the VB application to connect to the Database. Someone told me I needed to add the component &#...

Hi, All Guru member,I have problem to print my data.All record in database i show at DBGrid.That say, my option, to show the record only selected item by name.and the record show in DBGrid.so, i have problem to print record (data) from DBGrid.I've already make the data environment and data rep...

Hello gurus and friends, I'm encountering a problem: I need to have some controls of a form being only conditionally part of the final compilation. To clarify:To make some code part of the final program or not you will use #If Condition Then 'Special code going here #End Ifwhere Cond...

Hello,I try to do an authentication with a Bluetooth device using the MS API.I can find the device with BluetoothFindFirstDevice and BluetoothFindNextDevice.Then I call BluetoothAuthenticateDevicee.g. BluetoothAuthenticateDevice(0, hRadio, btdi, pin, Len(pin))This always returns 87: ERROR_INVALID_...

I want a pop-up box/form to get two values from the user. I imagine a behaviour similar to the InputBox() function, but instead of returning just one value, I want it to return two values. That is, the pop up box has two fields.I may have to create my own form. if i do that, how do i make it pop-...

Hi.I have created the FTP program and having a problem with it.I have command button that executes downloading a file (text file) from FTP site, and run Module to convert this text file to .csv file.I'm having a problem when I'm running this program.Sometime the error say "permission denie...

Hi,<br/>Anyone has a ADO Connection String for XML. I want to access a XML file as a database using SQL statements. (select)...<br/>If any one can reply with a sample, greatly appriciated...<br/>- Thankx in advnce

I want to copy info from a textbox on a form to a specific cell in a word table on a word document, how is this done please?is it something like .cell(1,1).text = txt16.txt.cell(2,1).text = txt17.txt.cell(1,3).text = txt18.txt????but the above doesn't work!...

Dear friends, i am doing a project using adodc along with datagrid and i am using different kind of Queries but i also wanted to show how records r selected based on that query(like if the query is Select * from AUH_HOUSE where Gender= "F") so it will select all the femals in the list so i wanted...

I know you can open a file and read it line by line of course but I was trying to find out if it's possible to open a folder and then read each individual file so that you could get the date it was created or possibly just once you open the folder just read each file.

Dear friends, i have anew problame where i am using text1.text to enter a tuple in a row but it's not working and telling syntex error i tried all kind of possibleties to do that but faint at last i am using ADODC+datagrid so, i should right the code here and please if you also tell me if the...

I wish to have a timer for the first time one is to 'mark' time in the windows startup routine to a finish time in windows.It's always said this time increases with more and more programs loaded.This may or not be a VB6 but could some point to something to measure these timesThanks...

Good DayI am writing to ask if microsoft visual basic 6 can be used to create a "drag and drop icon gui" and if it could also be used to create icons.The icons that would eventually be dragged and dropped on to a screen must eventually be joined by lines to form a diagram.For example can i use VB6 t...

It is easy to create a timer in Visual Basic.<br/>But I am unable to set the interval value in the<br/>propertys to more than 65000 milliseconds<br/>Is it a way to increase that value?

my problem is that i have to resize a label on my form by dragging its corner. please help me on this.<br/>like if i'm going to move the cursor on the corner of the label, the cursor will change and it will allow me to drag its size.

hi there. i would want to create a new control array of picture box and a label.but the label should be inside the pic box. the problem is that when i create a new control array both, the label won't appear inside the pic box. the example is attached here.

Hi all, Need to find help about DLL. I have used VB 6 for some simple application, but only the .EXE one, not DLL. However, the company that i worked for now, using DLL for the development. Anybody know how to get good info about this ? or maybe can try to explain to me what is the difference betwee...

hi. how can i determine the path of the my documents folder? if i will make a txtfile on the folder of mydocuments, how can i know the right path?

Hello, Can anyone help me with the following please?I want to print images from a recordset using an Access Database on the datareport. I can load and display the images on the form and also navigate through the records by using the path of the location of the images. But what I can't do is pri...

on the attached zip file, label1 is draggable on the form. but the problem is that there are some instances that the dragged control won't be placed on the accurate position. for example if i'm gonna drag it one centimeter away then i won't drag. why is that? is there a solution for t...

How to check table in database exists or not in vb6?<br/>I have use "select * from table" query but it gave me error that table does not exists.<br/>(Actually I am creating tempory table and deleting it after form unloads)

I want to display picture of customers in crystal reports. For that purpose I have created table customer.When new custiomer comes to me I take their picture using PC camera and save that picture in one of the folders.At the same time I am sending path of that picture to database.Now when I display...

I have a VB6 Application.My Application sends commands to instrument after every 10 seconds.and communication through the serial port This is workin fine since last 4 years.suddenly,I am facing a problem.Randomly,the <STX>,<ETX> and checksum is missing in one of the command.Hence leads t...

Hi I have created an activex exe in vb6 that uses the shells function to execute an exe that converts a tiff file to a pdf. This works perfectly fine if I use the activex exe functionality in a test vb application.The problem that I am having is that the activex exe emits an error sound (no error me...

HiI'm a relative newbie to VB and doing some vb programming in excel 2003 (vb6.3). I've created a form with numerous textboxes and written code to copy the contents into an Excel worksheet with a command_click event:Private Sub cmdTfrData2Excel_Click()Dim iRow As Long Dim ws As Workshee...