12,155 Topics
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 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 '" …
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. …
hi can someone help me? I have an excel file and the columns consist of : ID, Name, ContactNo, SalesOutput Sample record is: ID,Name,ContactNo,SalesOutput 123,Michelle Dela Rosa, 8437, 2 456, Anthony Diaz, 8414, 5 What I would like to achive is auto add rows depending on the value in SalesOutput …
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 …
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 …
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?
I am trying to update some records.The moment the line Adodc2.Refresh executes, I get an error message saying that the "Operation is not allowed when the object is closed" Yet, when I put "On Error Resume Next", it updates the records as I want it to. Please help me thank …
Hi guyz ! i'm HR .. does anyone know what's the code for printing using ADODC connection in VB6.0 ? I wanna know because I'm working on some system with a printing command so I hope anyone will give me answer .. Thank you in advance !! :)
Hi, I have one more issue.. tht after searching part number in datagrid, it will display the searched item in same datagrid. After tht i want to refresh the datagrid with completely. can you please help me on this. Sushma.s
Hi, I am stuck with this logical error and I was hoping someone could point me in the right direction. When I debug this program the array's do not contain the data from the textboxes that the user enetered. as far as I know the code is in the correct …
Hi, I have migrated OS from XP to win8.1. Earlier in my VB application, I was sending email thourgh my outlook object. set outapp = createObject("Outlook.application") but now I am getting error "ActiveX Compponent Can't create Object." as i have migrated my OS. is there any other change in code? …
I tried to create a setup project for my VS 2010 (Visual Basic) application (which was successful) but now whenever I try to open the solution project (.vbproj) the Setup project loads/opens. I'm afraid because I only have one copy of this project and I can't open the solution file …
Hellow daniwebians! Anybody can help me on how to print fastdraft in crystalreport8.5 thru vb6. Im using crystl.ocx to preview my report and i want that it will automaticaly change the printer settings into fastdraft.
The End.