12,425 Topics
 | |
| | THIS IS MY CODE.... bUt i am not getting the data between the given dates IN THE DATAGRID VIEW Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ConnString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= C:\Users\Anand\Documents\db.accdb" Dim dfrom As DateTime = DateTimePicker2.Value Dim dto …  |
 | Hi Dw I'm trying to create a server that will handle simultaneous connections from clients and for simplicity I've decided to save data to the text files, it not one text file but there are many text files which will be located on the server. The clients (written in VB5.0) …  |
 | i need to know if i can scan an image or any file from vb6 form then save it to my database, if yes how i can do it ?? thanx in advance... |
 | Hi, i am having problem with my vb project to clear all item in my form. Below is the code that i am using : Dim ctrl, obj as control For Each ctrl in Me.controls If typeof ctrl is GroupBox then For Each obj In ctrl.Controls If typeof obj is …  |
 | hi is there someone that can give me some hints on how to create excel file using data from my ms access database..because i haven't seen one in the net maybe someone might help me here..i would appreciate some hints or tutorials..:D thanks a lot...  |
| | Hi all, I have a large txt file (3 Million lines). Ouside excel capacity. Thanks for your support... input file format: =================================================== .. ... ... 2014 Jul 23 08:15:16.675 ... .. Name = x Lastname = y . . Age = 5 height = 1 .. .. ... ... 2014 …  |
| | If cboSearchType.Text = "Accredited Month" Then If rs.State = 1 Then rs.Close SQL = "SELECT * FROM BusinessInfo WHERE " & " AccreditationDate " & " like '" & cboMonths.Text & "%'" rs.Open SQL, con While rs.EOF = False With grdSearchResults .Redraw = False .Rows = .Rows +1 .Row = … |
 | '====================================================================================================== '====================================================================================================== Option Explicit 'For Log ID Public RUNNINGID As String Private Sub butBrand_Click() On Error GoTo ErrorHandler Dim colData As New Collection frmSearch.SQL_Statement = "SELECT ROW_NUMBER () OVER (ORDER BY brand_type_code) AS [NO.] , " & _ "[brand_type_code] AS [Brand Type] , " & _ "[brand_type_name] AS [Brand Name] … |
| | I have a EXGrid in a form and want to add button to a cell that either say "Edit" and "Remove", or Have icons for the two. Here is the code I have so far. With grdGrade .BeginUpdate '.DataSource = objCo.DAL.Connection.Execute(sql) .DefaultItemHeight = 21 .TreeColumnIndex = -1 .MarkSearchColumn = False … |
| | can anyone help me?..i trying to make a very flexible report according to a search Results...i use vb6 and ms access as database...  |
 | Guys. I Want To open file,Find the LAST line,Start APPENDING then finishing When User Presses Return.Any Ideas? I am a Beginner with VB6. Sorry for bad Engilish.  |
| | visual basic code for student details in library management system  |
| | can anyone help me arrange my code?..i would like to format a text to be displayed in a flexgrid.. Format(len(rs!UserPassword),"•") the len = 11 so i would like to display 11 dots..••••••••••• |
| | Hye. i need to build an inventory system. In that system, the production department will scan the barcode in each item. **How should i connect the barcode scanner with the system ? ** and the requirement of the system is to be able to compare the information scanned **with** the … |
| | Please tell me how to get report for a given from and to dates using crystal reports......i am using access database.....thanks in advance.... |
| | i am developing a project in vb6.0 and i want to open a child form in mdi form with function keys and want to close child form with escape key.Plz reply me with source code  |
| | Hi, I have a set of word macros which I need to share it with my friends. I want to make the job easy for them such that I share them an installable which they will install and all my macros will be automatically added in their PC's MS word … |
| | I want to connect my access database to my project in vb 6. What are the steps i should follow? Once i'm done with that, i want to know how to drag them and place them on a form (like the way we do it in VB.NET). Thank you |
| | how can i write codes that only clears specified text boxes |
| | Type rounds_key 'Storage Container raundnyh keys key (255) As Byte End Type Global data_ () As Byte 'Declare global byte array Global key_ () As Byte 'Declare global byte array Global data_size_block As Long 'Declare global variable 4 bytes Global su_box () As Byte 'Declare global byte array Global … |
| | Hello, I am a bit new to vb.net. I was learning Database in vb.net . I have created a MS Access file. But when I Started my Visual Basic (vb.net 2008 Proffestional) and then I Clicked the Option Add New Data Type (In Data), nothing came. Can someone help me …  |
 | Hello to all! I have two questions 1- please give me a internet link from where i download Vb 6 enterpize edition setup 2- Please also give me a link from where i download vb 6 enterprize edition origina/reference book  |
| | how can i write this in case select syntax? please help If cboSearchType.Text = "Accredited Month" Then With grdSearchResults .Rows = .Rows - .Rows + 1 End With If rs.State = 1 Then rs.Close SQL = "SELECT * FROM BusinessInfo WHERE " & " AccreditationDate " & " like '" … |
| | Hello everyone. I recently started using C++ and blah blah blah you know the rest. Using my extremely limited knowledge, I attempted to make a basic 4 function calculator CUI in C++. The code I wrote is as follows. [CODE]#include <iostream> #include <string> #include <sstream> using namespace std; char operator … |
| | Hello guys, Pls help me, I really need your help! In my workplace we've got a Micron SCORPION Z4120C alarm system that's been connected to the Central Station. But my boss would rather like to monitor the system on his own. And I'm in charge of finding out the best … |
 | I started programming 3 2 years ago when I started the certificate in IT, I am now on my 3rd and final year of the bachelors degree in IT. The first language I ever used was Visual Basic which we learnt in the certificate, i then moved onto c# in … |
 | Have a program I am writing for class using the pseudocode given. I have written it in a flowchart program successfully, but cannot get it to work properly in VB. It is supposed to show the C for Celsius and F for Fahrenheit, and list the matching equivalents below up … |
 | I need to dynamically group rows together in an EXCEL worksheet. The obvious choice to do this will be VBA. I hope you can help. My spreadsheet has 18 columns and (up to) 5,000 rows of data. I've written the following code which works "OK" however it fails to group … |
 | IAm Creating a pRoject that uses visualbasic and m having difficulty storing data into the database m I created ......thqnks |
| | Hello, The code below works almost perfectly except for two flaws: 1. It provides the full name of the file (workbook.xls) instead of just "workbook" 2. If there is more than 1 worksheet then the loop appends the previous worksheet to the filename. For example, Workbook1 has 1 worksheet Workbook2 … |
| | I am trying to insert records in a SQL table from Excel sheet with VBA code. Data contains of a range with all the rows to be inserted. I am using below code for the same. Insert INTO [odbc;Driver={SQL Server};Server=myserver;Database=mydb;Uid=abc;PWD=abc].DPR Select * FROM [TempRange] I am getting error as above. …  |
| | I have vb form that accepts input from user,search in database(database acess) and displays matching records if any in the listview .The problem is that the search query will display only one matching record even if there are many matching records .anyone please help |
| | hie all i am in a phase of creating a hta application for our internal functionality of our company. basically the reqt is to embed a self devloped binary file in the hta file, but i am facing a problem. like where i should paste the base64 strings in the … |
| | Program runs without errors, unfortunately it will not calculate the days overdue. Any Suggestions? I have attached the code as a pdf, i have also done this as an IF, THEN, ELSE statement with the exact same results, but it will not let me upload it. Help! Private Sub calculateFees … |
| | Private Sub Command1_Click() Dim Searchvar As String Searchvar = InputBox("Enter the Name to find") Searchvar = Trim$(Searchvar) 'remove surplus spaces If Searchvar <> " " Then 'cancel if nothing entered With Adodc1.Recordset .Find "[Title of Books] = '" & Text1.Text & "'", , adSearchForward If (.EOF) Then 'record not found … |
| | Dim total As Integer For Each row As DataGridViewRow In DataGridView1.Rows total += row.Cells("Total").Value Next TextBox2.Text = total // the above was the code i used and it worked good,bt if i do it for another column it is showing an error (which is given below)// Private Sub Button1_Click(ByVal sender … |
| | Ok here is the required feature: To send data gathered from a database inside a UserControl to the main form which houses the UserControl. Hierarchy at present: Mainform --FlowLayoutPanel ----UserControl The UserControls are generated on the fly by a client list in a database. This all works fine. When you … |
| | i want to make a program which is connected to google maps and take input in form of (eg: location) and search it through webbrowser component???  |
| | Good Evening Everyone, i am currently facing a problem. I want to append data to an excel file but before that i want to check for duplication records in the excel file before appending. For example, an employee want to check in to a company but he can only check … |
| | Having a problem. Wrote program originally as VB Console using Sub procedures, had to change it to Function. It worked as sub procedures, but now as function it won't calculate correctly, I actually have two that are doing the same thing because of the procedure switch! Grr! Any suggestions? Sub … |
| | Friends, I met with a small problem please help me I developed a small programme. When I exit from it I want to make a backup in another drive I coded like this FileCopy "I:\My Documents\New Folder\Pebble.mdb", "D:\Pebble\Pebble.mdb" Here the "Pebble.mdb" is my database in Drive "I". I want to … |
| | Hello, I have my VB 6.0 Application and make a Exe and I hosted it on my windows server 2000 it gives me error 'Could not access network location \\mynetworkpath'. earlier when there was Datepicker control was used then also there was error coming but I had registered MSCOMCTL2.dll and … |
 | Hello , I have to perform a function repeatdly ,say in every 2 hours .For this , I have a form with me in VB 6.0 and added a button to it .I have written all necessary coding in click event of that button and finally made exe of it …  |
| | I have created a C# code where I'll input a code to it and it returns me an encrypted entry pass code. Its all working perfectly. Now the question is that, I want to apply this code to every application I create so that only after getting the pass code, …  |
| | Hi I need to turn off the printing of hidden text in my vb6 program so I have inserted options.PrintHiddenText = False after opening the file in VBA. However it gives me an error 438 which I do not seem to be able to circumvent. The section of the code … |
| | Friends, I made a small calculator in a form.It works well. On the form there is an Exit Button to close the form. Now I want this task.If I keep the calculator on the form (Computer) idle for 60 seconds the form must be closed automatically / If I goes … |
| | i want to set google chrome as default webbrowser instead of internet explorer in visual basic 6 ??? |
| | I want a very short code (maximum 6 lines code) for identifying the given input is prime number or not ??? |
 | Hi All Quick question would VB in visual studio 2010 work in visual studio 2013. I know that when I went from 6 to 10, there were changes in the code. Thanks Michael  |
| | Can I install Visual Basic 6 on Windows 8.1? |
The End.