10,989 Topics
| |
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 … | |
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 … | |
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 … | |
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.... | |
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 … | |
[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 … | |
[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 | |
how to add openfiledialog and pass the file location to the DTS package which is saved as VB file? Thanks. | |
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 … | |
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 … | |
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 | |
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 … | |
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? | |
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 … | |
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 … | |
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 … | |
Can anayone help me how to retrieve the picture in Sql 2005?i need a simple a code plz help huhu, | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
[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 … | |
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 … | |
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??? | |
[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 … | |
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 … | |
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 … | |
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 … | |
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 … |
The End.