10,992 Topics
 | |
| | how can i enable or disable internet connection in registry using visual basic 6? pls help. tnx |
| | I need a macro that will search an excel spreadsheet for a specific text. If the text is found than I need it to store a value from a neighboring cell then procede to search the rest of the sheet and in the end sum all the values found and …  |
| | dear experts, I just want to wave the last digit of each cell's value like 20001 should like 2000 using ms excel 2007. please consider this table: 20001 2000 20011 2001 20021 2002 20041 2004 20042 ???? 20043 20044 20045 20046 20051 20052 20053 20061 20062 20063 20071 any help … |
| | hello all, I hope someone is there to help me out this. I am spliting a text file. and after splitting I want to concate the string 1 and string2 and string three and thereafter the normal string 4 ,5,6,7,8,9,10 etc. But when I debug the total string I got … |
| | Dear sir i want to know about how to print multi line code in rich tex box , because richtextbox.tex t=rscontact!companyname & rscontact@city it is display in a line , i want print one by one |
| | Hi there I want to search a records in course filed and find the names that repeated in records. For example if math repeated 3 times I want to show only the maximum of the grades in grades field for person and don't consider others. I do something like this, … |
| | When running this code --> [CODE]Private Sub cmdSquare_Click() Dim i i = InputBox("Please enter a number.", "Input Box") MsgBox "The square of " & i & " is " & (i ^ 2), vbOKOnly, "Result" MsgBox "The square root of " & i & " is " & Sqr(i), vbOKOnly, … |
| | I have an input box in my program and I want to be able to control the flow when the 'cancel' button is pushed. Any help would be appreciated. |
| | I got an excellent code for putting registry entry of my visual basic project in windows start up . Now my project runs automatically when windows starts, but the problem is i am unable to delete the registry entry fully at all. I mean to say in my vb project … |
| | hi every one , i developed a software in VB but i cant access the bar code reader in the s/w .so pls help me .... by Abin |
| | if an mp3 file is added to usb drive , it should be playable and it should not be copy able to the disk . |
| | |
| | Hi there I want to do something like this in formula field. I want to calculate average on specific records on my reports. This is for calculating average grades of students. I want to do like this: If {course.courseName}(i)={course.courseName}(i+1) then GradeMax=max{grades.grade} This code is for incorporating the max marks of … |
| | Is there a way to make a pen drive/usb drive read only , i mean to say u should not be able to copy its contents to any system or delete its contents or modify its contents, U SHOULD ONLY BE ABLE TO READ ITS CONTENTS Provide the means to …  |
| | hey everyone, i am doing a group project for varsity and we are trying to get an online help going using treeview. we have created it along with a separate panel with some labels. wat we would like to do once we have selected a child node is to set … |
 | [B]i enter text into a text box, when i move to the next textbox, the text i entered in the other text boxe disappears.....this started when i run form after linking my text boxes with the necessary database items.. i used an adodc for connection. before connecting the textboxes i …  |
| | Hello Everyone, I am having some problems with VB using MSComm. I have some hardware I developed and the firmware instructs the MCU to send data via serial port to a PC. The data stream must not stop, and for one reason or another I can't send data to the … |
| | Dear All I want to develop an application to compare 2 input text file and show the difference with highlighted text in the first file itself. Please assist how to do it Or any readymade software is there for effective file comparison. Regards Sasikumar |
| | dim hwnd as long I am using FindWindow function to find whether Internet Explorer is open or not . hwnd = FindWindow(vbnullstring,"Google - Microsoft Internet Explorer") the problem is it easily find most of the windows , but in few cases for example if i type something in google search … |
 | Here's possibly the single most useful function that I use. It simply takes an ADO record set and dumps the column names and row values into an Excel worksheet. To use it make sure you have Excel marked in your project references. |
| | How to write any Fingerprint Scanner Driver ? please guide me. |
| | Help me pls.... |
| | Hi there I have a database in access for using from VB6. In my access file I use many relationships. I use something for doing back up of my database frequently for preventing data loss. Every year many data added to this database (app50000). For maintaining the program at the … |
| | Good day.. Can everyone help me pls.. i have created a code to create nodes in treeview and i am done with this. my problem is how can i view children's text on the treeview as well as the image when i click the parent? here is my code. Private … |
| | My project is Internet Explorer Blocker which blocks all websites apart from what i have mentioned . Its working fine, now as the user should not be able to close the vb application For that to happen the application should not be visible . So for the what is the … |
| | hi i want to use web cam utilityin vb6.0 can iget some info on it |
| | hi everyone!! im ren, im in my 4sem. and i required to make a project in my major. using VB6.. and that was supposed to be cafe client/server. can someone help me how to make a cafe client/server? im just a newbie in VB6 so i don't have any idea … |
| | here's my connection string for database over network.. for security purposes i put a password on my database... then for additional security i put a password on the shared folder... but i dont know the code to how open it... [CODE]"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\warehouse-encod\Database\WI.mdb;Persist Security Info=False;Jet OLEDB:Database Password=thankyou"[/CODE] please help.. badly needed.. … |
| | The macro below works, however I do not know how to make the removal of the paragraph marks (second portion of this macro) apply only to text it pastes, rather than to all existing text in the document. As it is right now, this macro pastes and then removes all … |
| | [CODE]Sub QryReport() On Error Resume Next Dim QryDef As QueryDef Dim str As String Set QryDef = dbase.QueryDefs("balancesheet") dbase.QueryDefs.Refresh If Err.Number = 3265 Then Set QryDef = dbase.CreateQueryDef("balancesheet") dbase.QueryDefs.Refresh End If str = "select * from [balancesheet]" & _ " where Date ='" & Dtpicker.Value & "'" QryDef.SQL = str … |
| | If I have a form that is to resemble a standard dialog box that prompts for a name and I need to display the name on the main form when the main form is first run, how do I do that? |
| | Greetings, I have a workbook that has 600+ rows of information. I want to iterate through all the rows and copy sections from that sheet to a new workbook that is created on the fly. The following code is what I am using to attempt this, but the .Range line …  |
| | hello guys im just doing a pos project and i wanted to ask how to print a receipt. im so far that i can sell items and display the change money...but after that i need a receipt to be printed. Can u maybe give me an idea how to do … |
| | hello I send to items to Microsof t word with this code: [code] Dim wdApp As Word.Application Dim oDoc As Word.Document Dim oRange As Word.Range 'Create new hidden instance of Word. Set wdApp = New Word.Application With wdApp ' Show this instance of Word. .Visible = True .ScreenUpdating = False … |
| | How can one update automatically the tables in Ms Access such that once you input an item it is automatically viewed to other tables that are related to that particular table in relationship and the methods used to link Ms Access contents to Visual Basic Interfaces created according to the … |
| | Anyone please give an idea on how to create text box & label control during run time... Anyone pls.. |
| | Hello, when i input to database show error cannot convert type varchar to type numeric.. I' m using convert(numeric, quantity). Where my quantity is empty. Please help me. Thanks  |
| | I needing a program increase/decrease a day every 5 second or 1 min for clock system I use date function to set day but I so weak in timer function :) and 1 loop fuction to when it to day 30 it will return 1 thk:) |
| | The InputBox function needs to be used in a command button to prompt the user for a number. I know that the syntax is ([I]prompt, title[/I]), where[I]prompt[/I] is the message you want displayed inside the dialog box [in this case - "Enter a number"], and [I]title[/I] is the next you … |
| | I am having this MS Word macro which works well, but not fine. It replaces word [COLOR="Green"]Street[/COLOR] to [COLOR="Green"]St[/COLOR] which is the way I want, but it changes STREET TO ST (I need St), etc. However, I need them changed as follows: Street or STREET to St Avenue or AVENUE … |
| | Excel 2007: Within a Macro I did the following: 1: an autofilter on a specific column w/specific criteria Question/Request: I want to do a do loop starting with the 1st row of the filter and ending with the last row of the filter. Example: 'Set Filter Range("AF1").Select Selection.AutoFilter ActiveSheet.Range("$A$1:$1X$44489").AutoFilter Field:=32, … |
| | I am using command object in for loop on first time execution it inserts the record but the next time it gives an error Multible OLEDB error following is the code I use Set rssave = New ADODB.Recordset Set cmd = New ADODB.Command 'cmd.ActiveConnection = GCon 'cmd.CommandText = "prc_Invoice_Insert" With … |
| | Good day everyone!!! Pls dont kill me when a forum like this already exist but i was not able to find one through the search function. The purpose of this forum is, that skilled programmers will tell beginners how they managed it to become a programmer. Like what book was … |
| | I have a function and I want it to output one word in the current cell and one in the cell to the right (i.e., the next column). Is there a way to write this in VB? So, something along these lines (though this doesn't work): [code] Function test(word1 As … |
| | Hi, This is my coding......... Private Sub Command1_Click() Dim xlApp As Excel.Application Dim Wb As Excel.Workbook Dim ws As Excel.Worksheet Dim name As String Set xlApp = New Excel.Application Set Wb = xlApp.Workbooks.Open("E:\Projects\VB Excel to textfile\crse.xls") Set ws = Wb.Sheets(1) Open "C:\rolllist.xls" For Output As #1 For i = 1 … |
| | hi I am in deep trouble to loose my job please help me I am working on a website where a user comes and login when it enters a pop up screen appears where it is written continue or remind me later now i am unable to handle this functionality … |
| | If anybody has some idea to make antivirus in VB6 then please reply with your ideas. well, i m thinking it is possible by Controlling the windows services but i m not sure. Pl. help me...... |
| | Hi, I'm a bit of a numpty when it comes to programming so please excuse the silly question and I'm not even sure this is the correct forum to post it on but here goes... I'm trying to upgrade some VB6 to Visual Basic 2008. I'm trying to create a … |
| | good day.. i have a problem in accessing my Access database in network.. I made an inventory system... i couldn't run the program simultaneously in two PC. i got this error >>> "could not use.. file already in used"... i thought it can use in network? is my coding have … |
| | I am doing an Attendance monitoring with PAyroll program... I have difficulty in doing the data report and data environment in order for me to print the table from the database.. Will someone help me out with it..? I think I need a tutorial. =) |
The End.