11,870 Topics
 | |
| | Hope someone can help me with a EXCEL VB code for copying select data to separate spreadsheets. I have a farily large spreadsheet (~5000 rows x 200 columns). Column A has three string variables. For every value in Column A there may be up to 20 variables in Column B, … |
| | Hi, I am using MSSQL7 at work along with VB6, and while I have the VB work sorted, I am struggling with the SQL quite badly. Basically, I will try to explain my problem as best as possible, and will go from there. Firstly, here is my SQL statement as … |
| | any1 here know how to make a browse button? that can browse files inside a specific folder and then playing it? also what player should i use in my form? only know Amovie.ocx but i still dnt know how to make or have an idea in making a browse cmdbutton … |
| | Hi all! I am still wondering how to add data to excell file without erasing old data is it possible to do it in Visual Basic 6 ? I know how to open excel file and write data i just want to keep the data and continue counting the clicks … |
| | Hi I have created a database using ms access linked with vb6.But i am having difficulty coding or programming for a method that will help me find and retrieve a specific record.Any time i try, it either tell s me a runtime error has occurred or data member not defined.In …  |
| | Good Day, I have a customer requirement to extract test log information from a CSV file into an array so I can export the information into Word in tabular format. Does anyone on this forum have sample code on how to extract data from CSV? Regards, Keith |
| | Good Day, How would you code in VBScript to read the content of multiple HTML files into an array? Please observe the below sample and modify as necessary. My requirement is read multiple files by extension and not simply specify a single file. Const ForReading = 1 Set objFSO = … |
| | Hello everyone, I am beginner with Microsoft Visual Studio. I was doing my project and somehow I pressed some shortcut and enabled some kind of "indent notifiers" or whatever the purpose of this thing is. Now I have no clue what I pressed, but it is really irritating, and makes …  |
| | i have the following code for loading the csv file in to database dynamically. that is i want to give the file path dynamically . Dim conn As New MySqlConnection Dim myCommand As New MySqlCommand Dim myAdapter As New MySqlDataAdapter Dim myData As New DataTable conn = New MySqlConnection() conn.ConnectionString … |
| | hey guys i have been troubled by this for quite some time now. i have this example code in the command button. Dim ctr As Integer, ctr2 As String ctr2 = lst1.ListCount x = Val(txt1.Text) For ctr = 0 To ctr2 If x = Val(lst1.List(ctr)) Then MsgBox "Error Duplicate" Else … |
| | hey need some help guys. for example i have a text box and i will have input in it. but only numeric ones are allowed to be inputted in the text box if a character for example "a" is pressed the text box will not change and type the "a" …  |
| | I am having trouble with getting my data to display. The program works fine if I choose option 7 to display the balances and it exits if the user enters option 8 but I can't get it to perform the other functions. Can anyone help me to figure out what … |
| | |
| | heyyy anyone out here know how to create a chart in Visual basic6.0 data is stored in excel worksheet .......:icon_question: |
| | I am new but I am stuck with a problem that started last night. I haev been working on this forever and I am sure this has an easy answer. I have been using VB that is stored on a Citrix server and I gain access to this through a … |
| | hello guys, how can i select from table with a given time then select the nearest time available sample select * from mytable where Time=10:00, i want to get the nearest time ID | Time 1 09:00 2 13:00 3 15:00 |
| | Hi, Having read the announcement about kids doing homework I am a little worried now that I am gonna get a backlash. I work for a company that has pushed Access onto us as our Database Function unfortunateley they have not trained our IT to help when something goes wrong … |
| | i have 2 table table1 have itemno, qty1 // many item (sum if) table2 have itemno,qty2,qty qty = sum (qty1) i want write value sum of qty1 into column qty in table2. how to code for this statment, what is declaration for open database and record then edit ot update? … |
| | Hey if you have any questions on 2D or 3D Visual Basic Programming ( Mainly involving Graphics ) let me know, I know a few tricks. Thanks |
| | hi i am bond, i am a newbie to this website.i got a project in visualbasic in which i have to complete it in 3 months.pls help me which software is the best to work on it. |
| | Query = "select * from table2 where number='" + Text5.Text + "'" Rs.Open (Query), Conn, adOpenStatic, adLockReadOnly Hi, If "number" is defined as Auto number in Access database, second line generates an error. If "number" is not defined as Auto number then, no problem. What can i do? Thanks |
| | is it possible to change the color of the form's border usually when form is active it's blue and when inactive it's a little lighter I want it should seem active even when it's not |
| | Hi guys this is my first post on DaniWeb, I have searched for help on here for hours on hours. I am the webmaster at my high school and I have been given the project of making a Book Depository for one of our departments, one that would do the … |
| | I am using the code below to open the printer selection screen. when using it an a network I have to unload my program after making a selection and then restart my program for the printer selection change to take effect. any ideas on why this is happening? it used … |
| | I formatted my computer and I want to install the visual basic 6.0... I can’t install it using my installer... I’m enjoying making programs and of course experimenting… hehehe… So I just wanna ask... If there’s any possible website where I can download to install visual basic??? Thanks and more … |
| | Reading from text files........I have to read in a file which contains the list of all service calls to be done today, the calls have to be assigned based on how far the area is in the 10X10 grid of the sector, assuming the office is in the middle say, … |
| | hi, I am a beginner of visual basic programming. I know form designing and can write the source code also.But i would like to know how can i store my data in the project or programming.Means how to create and use databases in VB. Please give me the reply as … |
| | Hi everyone, I am attempting to access a database that is located in a shared server/ directory "K:\". Assuming I don't know where the database is located, how can I programatically tell vb to locate this database by searching all the network server directory? My database name is called: `PTS.mdb` … |
| | i designed a form that has labels on it that you are expected to insert value (Alphabets and Numbers) an then it will do a calculation and give you a result on that page this page contains about 200 -250 labels i want to make a "save" menu that will … |
| | I have made a report in Crystal Report, fetching records by SQL Query from ODBC Datasource. The query is taking too much time and error is comming after 50 seconds that timeout expired. What would be the problem ?? |
| | I've just started a new job two weeks ago, and as a first project I want to create a VB stle front end that will be used to co-ordinate documents in a control room. Looking for some help as I want to work on this next week so I can … |
| | Hi, I Hold a MS degree in Information Systems and I work in a University as a turore, I am to tutore visual basic 6 for next semester, I sont know where to start? I dont know anything about VB. I know Pascal, fortran, and C++ but I have no … |
| | Hi, I use VB6 with Access. I have 4 records in my DBF file. When i do Recordcount, it says that i had -1 record. Why not 4? Help please Thanks Dim Conn As New ADODB.Connection Dim Rs As New ADODB.Recordset Dim Query As String Private Sub Form_Load() Conn.ConnectionString = … |
| | I was wondering what i would have to do if i wanted to Write a program in Visual Basic but wanted to do some calculation(as to make it quicker) in C? Like say i wanted to fine the average of.. bah a few hundered thousand numbers in an array. So … |
| | Hey, I was programming in excel VBA environment and i came across the need to mail a sheet out of the worksheet using the default mail client, but i am not seem to be able to attah the worksheet in the file. Any Help will be greatly appreciated Thanks |
| | I want to link worksheets but i seen to be failing,please help.Am using exel VBA |
| | I m working on a multiuser VB project using MS Access as Backend Database. I wanted to know that through VB coding, how to know that any other user is currently accessing the MS Access DATABASE . |
| | HI I have created database with ms and linked it with vb6 user interface.But i have a problem linking or loading pictures to the records.I need help on how this can be done,and if possible how pictures can be loaded with it's corresponding data into the database at runtime. Thank … |
| | Hi, I would like to use VB to access a field in MS Access db which contains an article but I only want to retrieve a select sample from each article not the whole article. Any ideas Thanks Richard |
| | I m working on a VB project with MS SQL SERVER 2000 as backend database and Crystal Report 8 for Reports. The problem is : When showing a report, after some moments error comes as Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver]Timeout expired When I click … |
| | Hi, I need to build an MS Access database and include abstracts and articles. I then need to retrieve this information using Visual Basic. I would like to design it so that when someone types in a word in a search facility then relevant info would appear just like in … |
| | i am using vb6.0 and crystal report11 and MS ACCESS database how to create a crystal report at run time from a vb form i dont have any idea regarding this please give some suggestions or code would be very helpful to me |
| | Hi This may seem as a trivial question, but I'm new to VB so please bear with me. I'm writing a form to control one worksheet as a database. On PC, I used the ControlSource property of every textbox to bind it to a field in a record. [B]On Mac, … |
| | Friends. I need to do a program that intercept a job printer, and depending of numbers to page to print, enable o delete the job. Somebody know how to do? Thanks ! JAOR |
| | Newbie question. I want to simply have a form with several command buttons, that when I run the prog, i can click on them it will open either a word document or an excel spreadsheet. (These must be editable and savable) I need to know the actual code for the … |
| | Is it possible to display report in Visual Basic which is created in Microsoft Access? We developed a databasep applicaton that uses Access database. but one of the cross tab reports is difficult to develp in VB , but could develop in Access. Now I want a way to call … |
| | Hello All, I'm new to this community and new to VB as well. I was just wondering if anyone can help me in writing a coding. It's like if I click a command button, it should login into a remote desktop machine. I have no idea on this! |
| | This is a rpoblem related to VIRUS. forgive and help me. My computer have a VIRUS. The VIRUS make some of the folders as .exe. When look the properties of the folder, it shows only 37 KB size even if it contain GBs of data. Pse help me to remove … |
| | Any clues as to how to limit the number of records in a comma delimited file?? My program continuously writes records into a .csv file but the file very rapidly grows too large. I would like to trim off the oldest records before writing a new record. A code example … |
| | Hello everybody... How can I get the Object properties contained into a web form? I mean, how can I know if the web form opened has some command buttons, text box, and how many objects has. I have another question, how can I send a TAB key, move de Mouse … |
The End.