20,285 Topics
 | |
 | hy when i run this command to open excel and i get error (on 2007 excel it was fine) //Excel.ApplicationClass xlApp; Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; SaveFileDialog oDialog = new SaveFileDialog(); xlApp = new Excel.ApplicationClass(); ** xlWorkBook = xlApp.Workbooks.Add(misValue);** xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); int i = …  |
| | i want to print my receipt in A4 size, but the problem is when i tried to print preview the form that need to be print , it occupy the whole paper. I use Word in printing. and here's my code in print preview Private Sub frmreceipt_Click(ByVal sender As Object, … |
 | Hello guys, I have an application similar to an on screen keyboard but there's some functionality it's lacking - the ability to write to external software. For example, how could I get the application to write straight to a Microsoft word window or notepad window. Preferably write to the notepad …  |
| | sorry for my english its kind of its not my primary language.. i am new with programming, and also connecting databases. i use vb2008 and ms access 2010. i watched lots of videos with binding source etc on it connecting with database and i found it easy but somehow i …  |
| | Hi, I have a database which stores details of different department. Each department have uneven number of members. Eg. Table field Department A President : 1 Vice President : 3 Treasurer : 1 Secretary : 3 Committee : 10 Department B President : 1 Vice President : 4 Treasurer : … |
| | database - field[counterx3 - Id(text)Primary Key] my code works really well before but when i changes and add codes in the others forms i got error in updating the value in my database, here's my code for update sql = "update counterx3 set ID='" & Val(acsdr!ID) + 1 & "'" …  |
| | Hi again, i am working for a new project [payroll system] , i want to know how can i calculate late like for example my working time should be 8:00am-5:00pm and one day i go to office at 8:30 am , can someone tell me how can i save in … |
| | Im totally blank for work on crystal report. Please do some favour for intial start for crystal report. help me by sharing something to understand Crystal Report so that i can implement it on my project. |
 | How do i get this to write to a txt file instead of message box pleaseWr Function ReceiveSerialData() As String ' Receive strings from a serial port. Dim returnStr As String = "" Dim com1 As IO.Ports.SerialPort = Nothing Try com1 = My.Computer.Ports.OpenSerialPort("COM3") com1.ReadTimeout = 10000 Do Dim Incoming As … |
| | Hello I need help getting this to display the 3 outputs (Euro, Franc, Rand) with 2 decimal places (1.00) I have all the calculations done so this is what I have as my code: Public Class frmConvert Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load End Sub Private … |
| | Is there any way I can make this select case more efficient? Select Case cboBoard.SelectedIndex Case 0 To 1 If intDaysRented = 0 Then If intHoursRented > 3 Then lblCost.Text = FormatCurrency(arrDailyRates(cboBoard.SelectedIndex), , TriState.True, TriState.True) Else lblCost.Text = FormatCurrency((arrHourlyRates(cboBoard.SelectedIndex) * intHoursRented), , TriState.True, TriState.True) End If Else If intHoursRented > …  |
| | HI all i am working on a project where i am adding login and password. Also i add button if someone forget his\her password so they can able to retrive it. for this i put 2 textboxes one is email and other is username which will retrive data from listview. … |
| | Dear All i want to design a software in which i play a role of server and all users in my office will be a clients. whenever IT department want to send any message to all i will write in server app and msg will appear on everyone's screen and …  |
| | Hi guys, I need coding help in printing contents that are inside the groupBox only. I have a form with two groupBoxes, and would like to print contents on only 1 groupBox. Thanks. |
| | Hi, I am new to programming and have attached my code so far, i need to insert the code to read data from serial port but havent a clue where to put it or how any help would be great Imports System Imports System.IO.Ports Public Class Form1 Private mySerialPort As …  |
| | Is there any way to format the datetimepicker so that it only shows hourly intervals? I already put it so it only shows time... And when I try dtmPicker.CustomFormat = "HH" it doesnt work. I want the user to only be able to pick from hourly intervals without having to … |
| | Hi, I have writen web sites before but have been asked to create a VB program, but dont know where to start so hoping someone can help me. I need to create a program that sits waiting for data from the serial port which is attached to a set of … |
| | I'm trying to take some basic form data (item and quantity), from a form where this sort of information is filled out by a user, and after the user clicks "ADD", the entered info is moved to a DataGridView on a different page. The following code: Me.DataGridView1.Rows.Add(...) ...does not work … |
 | How can i count the vote of the voters, i used dropdown tool to choose a candidate, and my database in MS SQL SERVER 2008... please help my in my project.... |
 | Hi guys Im trying to save a combobox selected item to my database but i cant get it working, it saves "user" instead of the username that is stored in the combobox, any suggestions? here's a snippett Try '----------------Sends the message------------------------------------------------------------------- MysqlConn.Open() ' opening the connection to the DB Dim … |
| | Hallow everyone! I'm developing an application that features a bunch of reports and I have been using DataGridView as a way of displaying my reports, which come from the database (programmatically). When I want to print, I have been using a function that prints the datagridview like you are taking … |
| | Basically i'd like to click this "button" only once in the div "data-aid="115553109754009608849"" (this button is present in every div, and has no name or id, but i can click it by his class if i can locate him or walk the entire DOM - just that i don't know … |
| | i have app.config file in my application for storing/updating connecting strinng to my database.But when i installed my application on user machine i cannot locate the file to update new database link. How can i find the file on user machine .i.e where the file is installed on hard drive. |
| | Please help me. I am trying to insert into mysql database, but it is throwing this error. **Fatal error encounter during command execution.** this is the sample of code am trying to run cn.Open() cmd.Connection = cn cmd.CommandText = "insert into corps(callup,statecode,surname,firstname,othername) values(?,?,?,?,?) With cmd.Parameters .Add("@callup", OleDbType.VarChar).Value = txtcallupno.Text .Add("@statecode", …  |
| | I have been trying to write a simple program to issue Identify device ATA command to a drive with VB 2008 express, and has so far been unsuccessful Below are the code I have so far. But everytime I call the DeviceIOControl, it always return false. Can someone tell me …  |
| | Hi All, I am trying to create a new report in VS2010 using reportviewer. The report must use data from two dufferent databases, I would rather not have to create a temporary database and then populate it with the data and then create a new dataset. I also can't get …  |
| | i have below code to send email in outlook 2013 Try Dim SmtpServer As New SmtpClient() Dim mail As New MailMessage() SmtpServer.Credentials = New Net.NetworkCredential(OutlookID, OutlookPassword) SmtpServer.Port = *** SmtpServer.Host = "smtp.office365.com" SmtpServer.EnableSsl = True mail = New MailMessage() mail.From = New MailAddress(OutlookID) mail.To.Add(TbxTo.Text) mail.Subject = TbxSubject.Text mail.Body = TbxBody.Text … |
 | I worked on a program a few years ago that takes data from a series of text files and loads an Access database. I added to the code from a program started by someone else, so I did not write the imports and declarations. They used an ADODB.recordset, addnew and … |
| | Please I am a beginner to Visual Basic can anyone you help with this coding: Write a program that plays “guess the number” as follows: Your program chooses the number to be guessed by selecting an Integer at random in the range 1–1000. The program then displays the following text … |
| | (a) Use a one-dimensional array to solve the following problem: A company pays its salespeople on a commission basis. The sales people receive $200 per week, plus 9% of their gross sales for that week. For example, a salesperson who grosses $5000 in sales in a week receives $200 plus … |
The End.