[visual-basic] Forum Topics

HI evryone I'm a student and new to VBA and currently self studying this program. Found this forum which might help me in studying and some task :) Hope i can find my help here too :)

hi guys can someone pls help me... Im copying data from different files (all excel), how can I count the last row then the second data that im copied will placed under it. It's somehow like insert a record.. Thanks... :)

Hi everyone How to introduce myself? [B]I[/B] hate using the "[B]I[/B]" letter too much, but [B]I[/B] believe [B]I[/B] have to. Let us start with my name, [B]I[/B] was named Assem عاصم in Arabic (pronounced 3aasem) before [B]I[/B] was born in Beirut, Lebanon. [B]I[/B] am now 41 years old, [B]I[/B] am …

hi everyone; can somebody help me with my project. I have different files in one folder (Budget Folder) then I will import that in a single excel file (destibook.xls). This is the code. [ICODE] Dim DestBook As Workbook, SrcBook As Workbook Application.ScreenUpdating = False Set SrcBook = Workbooks.Open("C:\Documents and Settings\cbanato\My …

Hello.. I want to make a macro to create a chart from a table in different sheet. What i try to do is copy the information into a new sheet. Next i use the information copied to make a column clustered chart. The problem is the chart does not appead …

So far i have managed to butcher some code i found around 12mth ago to allow me to read the relevant node but i'm struggling to find out how to edit this node value and save the xml file. I cant find where i got this from or anything similar. …

I ask for simple help. I'm at a part of my application where I need it to open a text file, and search for id numbers within the text. There will be several instances of "id=######"s that I will need to grab from the text file, and put them line …

hi how to make the process sleep until my webbrowser gets loaded. this is my code [B]webbrowser1.navigate("www.google.co.in") text=webbrowser1.document.body.innertext[/B] pls send me the code

I have a form has to (maskedbox1) and (maskedbox2) if maskedbox1 I put date of today, I want ([COLOR="Red"]maskedbox2[/COLOR]) show date after 30 days as defult I will be thank you if you help me to do this I use vb6

Hey guys I am a VB noob and need some help, basically this is what I want to do please look at the following picture [URL="http://www.bus.ucf.edu/llinden/courses/ISM3253/assignments/marketing_study.PNG"]CLICK FOR PICTURE [/URL] The app should basically pull up the data contained within this CSV file : [URL="http://www.bus.ucf.edu/llinden/courses/ISM3253/assignments/survey_data.csv"]CLICK FOR CVS FILE[/URL] and display it …

I've just started playing a game again after a while (Runescape.com) and thought i would just make my own small utility program that looks up hiscores etc, but for some reason i get this error: "Attempted to read or write protected memory. This is often an indication that other memory …

i am working on a vb project in which need has arised to print an invoice. however the problem is that the contents of the invoice is accompanied by horizontal and vertical lines. Also the so-formed rows and columns are not regular. My question is how can i print such …

When I Enter The First Data enters as null in the database. while record count shows me there is one record in the database. i have uploaded the whole project. can anybody figure out the error in the code. if yes please assist me!!! please note about the project : …

[ICODE]Private Sub Form_Load() Dim tmp() As String Dim i As Integer Open App.Path & "\links.txt" For Input As #1 tmp() = Split(Input(LOF(1), 1), vbCrLf) Close #1 For i = 0 To UBound(tmp) DL.Download tmp(i), App.Path & "\" & ExtractFileName(tmp(i)), "k" & i Label2.Caption = "Connecting..." Next i End Sub Private …

i am working in developing a package for reading data from a com port and then display its interpretation. i am getting data in a text box. i have a database to compare eachline and give results. Now my problem is data is coming in the text box, i have …

Hi all, I am generating a report in flexgrid. I need to copy this data in excel and attach the excel sheet in the outlook so that the mail can be send. Outlook will be opened on a button click. I am able to open the outlook but unable to …

In the code below I use the Form_Load to connect to a Access database and load a form and combo box. I then use the cboComp_Click to look for a record in the tblToDo table, If found I load it into the form using the FillFields If not found I …

Private Sub btnedit_Click() Dim a As Variant Set conn = New ADODB.Connection strConn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SPUM;Data Source=(LOCAL)" conn.ConnectionString = strConn conn.CursorLocation = adUseClient conn.Open 'lblindexid.Caption = rs!Indexid strsql = " Select * from ES_otherSchools where Indexid = '" & lblindexid.Caption & "' " Set rs = conn.Execute(strsql) …

hi everyone, I am not a software kid that much but after getting fail from all books, im here for help. I am trying to read data from a device like monitor with a screen like calculator. It is connected with its main unit with 15 pin serial port like …

Hi, How do i select a particular value of a combobox? Example [code] combo1.selectvalue(rset.field("id"))[/code] I believe you understand what i mean. I bring data from database and want select it in combo. Thanks

Can anybody help me. I want to store data from a textbox to a word document and viceversa. mt second query i have developed a package using Vb and access which involves mscomm com control. i am not able to make an exe file or make a package using package …

hello Frends, i m creating a new project of vb to access conncetivity in 5 PC small LAN. I don't Know What is the code,connection string use in project. And I am biginar for that type of programming. I want to store data in server, access database tables. Please give …

hi i used the following code to read data from web. this is my code Private Sub Command1_Click() Dim Text As Variant WebBrowser1.Navigate ("www.google.co.in") [U]Text = WebBrowser1.Document.Body.Innertext[/U] MsgBox Text For i = 1 To 1000 If Mid$(Text, i, 8) = "google" Then MsgBox ("String Found") End If Next i End …

hi i have 3 form and an exit button in 3rd form i want to close the whole project when i click exit i think unload me can only stops that particular form i want to close the whole project thank u very much

hi... when i save a data from text box it didnt show at the listview how to do that? and someone please check my delete coding Private Sub cmdSave1_Click() If MsgBox("Are you sure you want to save?", vbYesNo + vbQuestion) = vbYes Then Set rec = New ADODB.Recordset rec.Open "Select …

hi, i am currently working on a software for hospital records. i am using vb6 linked to db. i wanted to view the records of the existing patient and add new records on the same patient and at the same time i would like to view the table of the …

I'm getting the above error at this section --> SetCurDir ("\\Cls000008\actuarial_data\Xtractor") in my code below ... please help ! _____________________________________ Option Explicit Private Declare Function SetCurDir Lib "kernel32" _ Alias "SetCurrentdirectoryA" (ByVal lpPathName As String) As Long Public Sub Extract_POL(strinputfile, lngTOTpno, blnPOL, blnIDAT, blnTcode, _ blnHPTAR, blnTerm, blnOccode, blnAge, blnPollines, …

can anyone help me? where can i DOWNLOAD visual basic language for free? please help me thnx!!

I have looked threw several times and cant find it. I am a coder for the united states air force. i feel ashamed that i have to get help but there is a first time for everything right? help will be much appreciated :) [code]Private Sub cmdLogin_Click() On Error GoTo …

Any expert programmers here are willing to help out with my school attendance system? im using visual studio 2008 (Visual basic language) i am ask to do an attendance system whereby a student capture their own image using webcam and hence their attendance will be taken down. i REALLY need …

I want an embedded listbox (with headers) on my excel spreadsheet, that references a range on the worksheet. So using the ControlBox Toolbar I created a listbox. First thing I noticed is that there is no RowSource property appearing for this listbox. So I tried to enter the range using …

Hi folks, In My Application i have used the date function to find the difference between two date.but while executing is showing that runtime erroe 424,object required. Can anyone plz help me fast... This is the code i have used Dim date1, date2 As Date Dim diff As Long date1 …

this is a simple quiz program for addtion that generates random numbers and records the attempts and correct answers that were taken. i have a problem, i need to have the percentage of the scores. i have a text2(number of attempts) text3(number of correct answers) the text4 should automalically have …

Hi I need to import data from an excel sheet using a variable filename that has been defined through a user input.. I cant get it to work.. What could I use?? Cheers, J

Hi, I have a form with two tabs. On each tab, I have 5 different fields. Is it possible to design the elements in a frame and assign them to a tabstrip, or do I have to load and place them in the new loaded tab? I would appreciate your …

Hello All, I have two multi-select listboxes, 'listFrom' and 'listTo'. I want to be able to copy mulitple selections from 'listfrom' to 'listTo' and delete those selections from 'listfrom'. To copy over multiple items is no problem but when i introduce the 'removeitem' line to delete the selection, it deletes …

What i hav to in order to use Auto Cad using visaul basic 6.0

I've always wanted to post a comment online especially on information technology. I also love web-designing. I can write programs using visual basic, gwbasic, c, c++, and currently working on java The challenge i seem to have is getting a project topic for my final year project. if u have …

I'm using the following code behind a combo box name cboCompy. For some reason when I make a selection from the pulldown in the combo box this code won't fire. No errors appear but the code won't execute. I put stop in the code so I can view but it …

I'm rather new to VB, I'm starting my 6th week in the course at school. I made a form that includes a Windows Media Control and all the coding is correct to run the application. I have it set up so that the URL is already assigned because I have …

how to transfer contents of a word file into a text box by clicking a command button. can anybody help me

Hi, [code] Create table myTable( title ENUM ('Mr', 'Mrs', 'Miss') NOT NULL DEFAULT 'Mr' ); [/code] How can i load ('Mr', 'Mrs', 'Miss') into a combobox in VB6. Thanks

hi guys i need a concept to develop a VB project. it like a mediaplayer concept. actually i need to run a mediaplayer in full screen mode but should not support the mediaplayer feature. then same time in that same mediaplayer i need to run diferent file when i click …

Hi, I have created a project in VB6. How can make it SETUP / INSTALL kit? I have added some refferences and components as well. Thanks

I would be very grateful for any advice on this. The business I work for want all their paper data stored in Access 2000, and to be accessible through a small network - server, 3/4 PCs running XP. The main question is: Is there any reason not to use VB6 …

Hi, I am in the process of making an application to query Quake 3 servers, but I am starting with querying the master server as I'd like to get the server list down so I can then start to query them individually. I've read through a number of threads on …

i'm new to vb.net and i cant figure out how to solve this problem any help would be greatly appreciated how can i show data into list view if the data is located in different tables. here few of my code, Public strConn As String = "C:\*********.mdb" Public cn As …

Hi everyone, Will appreciate if someone could advise me on how to do this: In an Excel workbook I have a few sheets. [B]I'm trying to write a macro which looks for a named sheet and if it is there do the required action and if it is not there …

i randomized the numbers ranging 1-20, it generates 2 numbers for label1 and label2 after clicking the command1 button. i created a textbox and another command button for checking if ever the to labels are [B]ADDED[/B], the answer in the textbox should match the right answer.. it will be activated …

Hey guys I'm pretty close to finishing this payroll program, but i've run in to yet some more problems and i can't figure out how to fix them. So, i have various forms representing different tables of my database (Access - the database is connected to my vb application as …