10,989 Topics

Member Avatar for
Member Avatar for InfrequentCoder

First, of course a List box (it has it's default name List1) is not a variable. I tried variables that were close because Visual Basic gets "confused" about its error messages (as when one has nested strings and it lists the wrong one an error) Oddly the current version I'm …

Member Avatar for vb5prgrmr
0
255
Member Avatar for Baz_Singh

Hi. I am very new to VBA and the task in hand is a tough one to start with. Basically I have requirement of code I can run using Active X in DTS to load data that sits in excel files in a certain folder location into an sql server …

Member Avatar for vb5prgrmr
0
135
Member Avatar for Plec

Hello, I'm writing a thesis and in order to interrogate the text have written a small programme in vba which allows me to run from a form boolean searches on the chapters which I've entered in an underlying table. The results are pasted to another table and can be viewed …

Member Avatar for AndreRet
0
109
Member Avatar for Lovi Aggarwal

hi Lovi here..... I'm making a project on library management in vb. I have made the forms but I have a problem in coding. I want to do connectivity between the forms. Can anyone help me in this????? Thanks....

Member Avatar for AndreRet
0
144
Member Avatar for java_programmer

Hi, I am writing macro to copy an excel sheet to another excel sheet with some modification of the data. But I have some currency and numeric field in the source excel sheets, which I need to copy as it is in the target excel sheet. But when I copy …

Member Avatar for AndreRet
0
93
Member Avatar for ryan311

[CODE]If Option1.Value = True Then a = 3 End If If Option2.Value = True Then a = 2 End If If Option1.Value = True Then a = 1 End If If Option4.Value = True Then b = 3 ElseIf Option5.Value = True Then b = 2 Else b = 1 …

Member Avatar for labq5
0
181
Member Avatar for viruprateem

[CODE][/CODE]]Hello friends need a help in vb6 to handle third party party software using dll files or tell me how my dll files can attached to third party software while running

Member Avatar for AndreRet
0
87
Member Avatar for sophie_kiu
Member Avatar for AndreRet
0
118
Member Avatar for pritesh2010

hello everyone. i have a problem with MDI parent.in my project there is parent form and child form. in my MDi parent form i had created fix layout panel where i want to show the other child form . but i dot no how to call child form on that …

Member Avatar for labq5
0
1K
Member Avatar for DrPhil

I am having a problem with the SQL INSERT command in VB. I am trying in move data from one table to another. The problem is I am going from a table with duplicates to one with no duplicates. Since there are duplicates the SQL statement bombs. Here is the …

Member Avatar for ryan311
0
177
Member Avatar for abhinav_blue87

hi this is abhinav i am a newbie to this world ... i very urgently need a project on library management in vb...... is there any one who can help me in this ....... thanks

Member Avatar for AndreRet
0
167
Member Avatar for emsd123

Hello, everyone. I have generated a treeview loading from database, learned from a book. But I have no idea how can I save the view state of my treeview, I have tried the following code to do, through it, I can only keep expanding the first layer of treeview, but …

0
107
Member Avatar for Leesha

i'm a student of BSc IT. i have to submit my final year project but i've got no idea what i'm going to do. any idea on what i can do it?

Member Avatar for zebnoon
0
176
Member Avatar for jwelch

I'm fairly new to VB Scripting, i have written a vb script that will check to see if out look is open and it is not it will open it. i want to a some code in that script that will allow it to run every 5 minutes un till …

Member Avatar for AndreRet
0
148
Member Avatar for java_programmer

I am writing a macro, which will take an excel sheet as input, process the data and after processing the data, will create a new excel sheet with the processed data. In the input excel sheet, there will be some blank row, which I need to be ignored. But i …

Member Avatar for AndreRet
0
161
Member Avatar for edy_sze

Hey guys I'm trying to debug a program which gets values from a Sybase database and exports those data to a Excel Worksheet, all is fine but when there is a value '001' from the database the exported valued to the worksheet is a null character. That is strange so …

Member Avatar for AndreRet
0
132
Member Avatar for runnerme
Member Avatar for debasisdas
0
119
Member Avatar for Jollyyy100

Hi, am working on my assignment, i wanted to know whether there could be a way in which if i click on sign in on my vb.net button, i could get a pop up or a dialog style message asking me for the username and password. Is there any way …

Member Avatar for Oxiegen
0
160
Member Avatar for Jollyyy100

Hi, i want to know if its possible to bring upon many pictures in a single picturebox and navigating it. So far i have done the coding but when i run the program i cant see the picture being displayed following are my codes, and please help if theres any …

0
90
Member Avatar for navingupta52

Hello everyone, I m Navin Gupta and i m doing a project where webcam is used to display all the customers details in any field....I want if a customer comes on the Desk then the webcam of PC will scan the persons face and will display his or her Details...my …

Member Avatar for vb5prgrmr
0
83
Member Avatar for Jollyyy100

Hi, would u please help me with the buttons i use on my vb.net forms. I want a way in which if i drag my mouse onto a particular button it would increase its size and if i click onto it, it can respond to the codes. May be like …

Member Avatar for Jollyyy100
0
172
Member Avatar for mrnervios

I want to upload a text file to a access database, but the string does not work. I guess the problem is with the quote marks or something of the sort. The string is as follows: rs.Open "SELECT * FROM [" & Me.Text1.Text & "] ", objConnection, adOpenStatic, adLockOptimistic, adCmdText …

Member Avatar for vb5prgrmr
0
181
Member Avatar for shweta102030

[CODE]Private Sub Command1_Click() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn = New ADODB.Connection Set rs = New ADODB.Recordset On Error GoTo myerror cn.Provider = "Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Main.mdb;Persist Security Info=true;Password=123456789" cn.CursorLocation = adUseClient cn.Open rs.Open "SELECT * FROM BA_Data", cn, adOpenKeyset, adLockOptimistic, 0 MsgBox "Total …

Member Avatar for vb5prgrmr
0
210
Member Avatar for Tweed

First of all I know this has been asked several times before but I cannot get mine to work. Anyway, on the developer computer I have created a Class Library that contains COM classes. I have also created an Excel 2003 Addin that references the .tlb file that is created …

0
111
Member Avatar for edward50

how can i use notepad as my database and how can i search a list of data, compute numbers inside the notepad and how can i align some list of data in the textbox???

Member Avatar for AndreRet
0
243
Member Avatar for Bashir ahmad

[B] I use vb with Access. I have 2 tables table1 & table2 i create a data report showing the data from table1. My aim is to display the data from table2 on the same report in its next page(s). any kind of help, suggestions will be highly appreciated. with …

Member Avatar for AndreRet
0
429
Member Avatar for OsheRono

Hello, I have been trying to migrate some code I have written so I can use the advantages of Collection items in several forms I programmed in Access 2002. I was using an array list to collect information from a machine part and its resulting defect, then display a small …

Member Avatar for AndreRet
0
166
Member Avatar for shweta102030

i have developed simple system with ADODB connectivity n with some of components inserted like MS MaskedEdit control, or Crystal report control n then after installation of Windows 7 i tried to run some of my Program then my all other program run well with all components added but in …

Member Avatar for AndreRet
0
154
Member Avatar for leo1937ca

I am using w2k, vb6, VBOLock and access 2000. I created a program that at first ran OK in VB and the compiled EXE. Now when I compile and run the EXE, I get a run-time error '53' file not found. I have checked and rechecked the code for accuracy …

Member Avatar for AndreRet
0
198
Member Avatar for westwing

Can anyone help me with this program? Example: I have 100 images in one folder named "Photos". All the files are sequentially named. I have subfolders under the "Photos" folder. Can a program be written wherein I am prompted to enter the file names, (for e.g. 01.jpg, 02.jpg, 03.jpg....) and …

Member Avatar for AndreRet
0
210

The End.