Visual Basic 4 / 5 / 6 Forum

can any one help by providing the method inserting the records in excel file because i created it all it works fine but i have no idea about how to insert new records in the existing excel file. e.g my excel sheet has filled first 20 rows and then i want to insert the new records in the excel sheet starts from 21st row is any idea about...

Since this is now a discontinued and unsupported product from Microsoft, is it ok to develop and sell software made with it now? I still have my old copy from back in my college days.

Hello World I have a problem in detecting the conflict schedule (Day and Time). Day 1. M 2. T 3. W 4. TH 5. F

Hello all I have these records on my Day Table for my complete database table please click here 1. M 2. T 3. W 4. TH 5. F 6. S

Hello expert. I made a program in which the data from an SQL table is transferred to an Excel sheet. When the data type of a field is Integer it works fine, but when the data type of a field is "numeric" it produces the error "APPLICATION ERROR OR OBJECT DEFINED ERROR" but I can't change the data type of the table from Numeric to Integer....

Follow the code: code:vb If mesge = vbOK Then rs.Open "select * from empdetail where name = '" & mName & "'", conn, adOpenStatic, adLockOptimistic txtid.Text = rs!id txtid.Enabled = False Else txtid.Text = ""

Hello World I'm back again. LOL How to make an image arrays? I have 6 images named Button (Index from 1-6). I'm working on MouseMove events these images. So far I have these codes: Public Sub DefaultImage() It should be array For i = 1 To 6

Hi everyone, I am making a game in Visual Basic. I need some help with it. My question is: that when the user would click the Next button on the Form, the next Question should show! I have 15 Questions to show. How can I do that. It's my exam, and I really need your help! Regards Prince Dhump

Here is my scrpit,, when I try debugging it it keeps doing something stupid saying Conversion from string "" to type 'Double' is not valid. I will make the line it's refering to bold... Public Class Form1 Dim X As String Dim Password, PWord Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...

Hello Experts See My Code Private sub F_Clear(Paramarray Cntr()) dim i% For i=0 to ubound(cntr) cntr(i).text = "" next End sub

hello can any one help me by providing the way how can i search the records of one column in another column actually i have a column which contain some names and in other column i want to search the same name and if found then print else goto next record i used some looping concepts but not getting the proper idea please provide some...

hello guys im new here..hope you can help make my first project in visual basic..i want to make a mp3 player in visual basic without using the WMP OCX.. i have started i downloaded a simple mp3 player without WMP OCX and use it as a reference but since it has no tutorial i have to see the codes 1by1 i cant play my project..here's my code.. ...

hi plz help me, i would like to know if got two timer in form( vb), does it run parallel or synchronous. i got problem here where i want to calculate time duration the formula is EndTime-StartTime. I code the StartTime in first timer and the EndTime in second Timer(Timer2) with 5s and 10s Interval each. BUT i facing problem here where the Time...

I am trying to useSQL code inside VB code and I keep getting an Expected Case error on my first select statement, can any one help me with this?? Thanks ConnectionString = "Provider=SQLOLEDB.1;server=wsus;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=inv_tracking" set cn = CreateObject("ADODB.Connection") cn.Open...

Hello everyone, I m using some button using toolbar such as Add,Save,View,.... my save button is not working.... it doesnt give me any error but does not save to my database.... or showing in my gird... Plz Help here is my code for save button Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button) On Error GoTo ChkErr If...

Good Morning Everyone. i would like to merge 6 workbook together they are all the same format all with the same headers and are all in the same folder called merged. I have this code ( below) but i keep getting User defined error on line 3and i dont understand why... Some please help me merge these files together i would appreciate it sooo much ...

I am seeking help to try and fix an error that I am getting inside of my excel vba code. I am trying to import the column names of a sql table into an excel worksheet. When I run this code: I get this error: Run-time error '3265'- Item cannot be found in the collection corresponding to the requested name or ordinal. The error appears...

Hi,I have say 10 checkbox in my form. In which i should be able to select only 2 checkboxes. Once 2 checkbox are selected then the remaining checkboxes should be disabled. And which ever checkboxes are selected, those checkboxes should fetch the data from the different excel sheets and place it in the 2 frames which are designed below.(Each frames...

for this start and stop should there on a button. but i don't want start and stop text on the button. let the button text bi button1 only when we press the button the timer should start on a lable and when we again press the button the timer should stop and the lable time should bi zero. and when we again press it should start . does anybody know...

Hi I have a fairly large form with many labels and boxes etc. Some labels are set to alter their text onclick. It loads seemingly ok. However when I click the label the form crashes with the aforementioned error. The label is visible in design view. It is listed correctly in the document outline. Yet it is claimed it doesn't know about...

Hello, I want to start with learning VB for my work. I'm a Industrial Automation engineer and i want to know what the difference is between VB6 and VB.NET. Is VB.NET just an anaother word for VB.7 ?? Regards Arie

Hello Everyone, I have been working on a few applications in VB 6.0 for about 8 months now and pondering if I should pay any attention to all the buzz around .NET. My only reason for switching to .NET would be if I simply couldn't run my VB 6.0 applications on Windows anymore. Is this the case in Windows 2K or XP? Will it be the case when...

I really can't understand why you still use it or why you started using it in the first place.

Last night I was reading about implementing my own stack. The example given pushes items on and off the stack at the start and end of each procedure (ie. in a std module). What's not so clear is how this would work with class objects. In this case do you have to push the object on the stack at the start of every public procedure etc. in the...

i have to make a 12 days of christmas program using arrays and loops and im stuck. if someone types the number 12 in it has to display 1 2 3 4 5 6 7 8 9 10 11 12. anyone knows how to do this let me know. thanks