10,930 Discussion / Question Topics

Remove Filter
Member Avatar for
Member Avatar for manjupapu2006

hi, im doin a project in visual basic 6.0,. pleae help me in constructing a inbox in vb 6.0. mail: [email]manjupapu2006@gmail.com[/email] -manjunath

Member Avatar for mathet
0
699
Member Avatar for TOROOOLOLOOLO

Hi I have problem with packaging and transferring VB6 and MS Access database from one computer where it is designed to another computer. I need some help. thank you.

Member Avatar for tsorewilly
0
98
Member Avatar for newwin

When button is pressed from Forms of MS-Access, a file open dialogue box is displayed. I need the VB code.

Member Avatar for ntuthuzelojames
0
171
Member Avatar for badbloodyeyez

Hi, I would like to know how can I stop windows from logging off, restart or shutdown. I want to automatically pause these operations and then send a signal to USB port and then resume the shutdown, log off or restart operation. Is it possible you can help me write …

Member Avatar for Satishsr
0
122
Member Avatar for Ghost34

Private Sub cmdgo_Click() //txtsearch.text is where you going to input student number and the StudentNo is database field name or should i say it is table name the one that contains student number If txtsearch.Text = StudentNo Then Data1.Recordset.OpenRecordset //hmm... i made this cause it looks like its going to …

Member Avatar for picawho
0
123
Member Avatar for benjaminhan

Hi All, I am trying to create crystal report 11 with VB6. But it seen like during the execution of code, the sql statement was ignored (line 12). And the report listed out everything. Below is my code. [CODE]Dim rs As ADODB.Recordset Dim strSQL As String Set Report = New …

Member Avatar for sinnerFA
0
95
Member Avatar for Trixx red

how can i enable or disable internet connection in registry using visual basic 6? pls help. tnx

0
64
Member Avatar for abchigley

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 …

Member Avatar for cguan_77
0
69
Member Avatar for 4ukh

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 …

Member Avatar for 4ukh
0
98
Member Avatar for andy999

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 …

Member Avatar for andy999
0
157
Member Avatar for manoharan

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

Member Avatar for Vineeth K
0
97
Member Avatar for Afi83

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, …

0
86
Member Avatar for EntangledDesi

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, …

Member Avatar for makybe
0
297
Member Avatar for stan yost

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.

Member Avatar for lanze12
0
106
Member Avatar for coollife

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 …

Member Avatar for vb5prgrmr
0
89
Member Avatar for abinmd

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

Member Avatar for vb5prgrmr
0
121
Member Avatar for coollife
Member Avatar for vb5prgrmr
0
75
Member Avatar for jonathannavarro
Member Avatar for Afi83

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 …

0
61
Member Avatar for coollife

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 …

Member Avatar for debasisdas
0
30
Member Avatar for is2kid

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 …

Member Avatar for vb5prgrmr
0
77
Member Avatar for Israelsimba

[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 …

Member Avatar for abu taher
0
107
Member Avatar for rjrodrig

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 …

0
78
Member Avatar for rsk_beckon

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

Member Avatar for debasisdas
0
154
Member Avatar for coollife

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 …

Member Avatar for marco93
0
124
Member Avatar for devmakwana
Member Avatar for xirosen
Member Avatar for Afi83

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 …

Member Avatar for omoridi
0
180
Member Avatar for xirosen

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 …

Member Avatar for omoridi
0
184
Member Avatar for coollife

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 …

Member Avatar for omoridi
0
228
Member Avatar for jatinder_44
Member Avatar for omoridi
0
97
Member Avatar for gothic1989

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 …

Member Avatar for omoridi
0
74
Member Avatar for xWiredx

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

Member Avatar for vb5prgrmr
0
84
Member Avatar for leokuz

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 …

0
62
Member Avatar for abu taher

[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 …

Member Avatar for abu taher
0
146
Member Avatar for EntangledDesi

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?

Member Avatar for EntangledDesi
0
96
Member Avatar for Krondorl

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 …

Member Avatar for AndreRet
0
204
Member Avatar for HelloMe

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 …

Member Avatar for AndreRet
0
123
Member Avatar for sanam

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 …

0
49
Member Avatar for Nerrisa

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 …

Member Avatar for vb5prgrmr
0
116
Member Avatar for xirosen
Member Avatar for abu taher
0
135
Member Avatar for hery

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

Member Avatar for manoshailu
0
114
Member Avatar for phuanon

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:)

Member Avatar for phuanon
0
119
Member Avatar for EntangledDesi

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 …

Member Avatar for EntangledDesi
0
99
Member Avatar for leokuz

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 …

0
56
Member Avatar for RousebyWolfCA

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, …

0
49
Member Avatar for santosh.garg

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 …

Member Avatar for vb5prgrmr
0
146
Member Avatar for HelloMe

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 …

Member Avatar for Nerrisa
0
108
Member Avatar for francoise

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 …

Member Avatar for shiftingspanner
0
393
Member Avatar for santhanalakshmi

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 …

Member Avatar for francoise
0
345

The End.