20,897 Topics
 | |
| | pls help me with auto generated alphanumeric pk say i want my customer id to be like these CUST00001 CUST00002 CUST00003 CUST00004 any help is a great help.! Blessings! |
| | [code] Dim Conn_web As SqlConnection Conn_web = MyFormz.connec.ConnWeb2(dbName) Conn_web.Open() Dim sqlcmd_Insert As New SqlCommand(sql_Insert1 + sql_Insert2, Conn_web) Try sqlcmd_Insert.ExecuteNonQuery() MsgBox("The New Record has been saved.") Catch ex As Exception MsgBox(ex.Message) End Try [/code] [code] Sub Insert_New_Converts_Followups(ByVal strFollowup_No As String, ByVal strFollowup_Date As String, ByVal strFollowup_By As String, ByVal strFollowup_Response As … |
| | I'd like to use data from a text flat-file in my VB app. I have a data dictionary that describes the content of the flat-file. The challenge is that the flat-file structure may change in future (with an associated change in the data dictionary). Not frequently but every 6 months … |
 | Hi Everyone, In my form there is a "Validating" event on a textbox. This form also has a "Cancel" button. Is there a way to not execute the "Validating" event when the user clicks on the "Cancel" button? Please show me code to do this. Thanks. Truly, Emad |
| | Hello! Can someone help me? I need to get the product of the 2 columns in the same row but my problem is the values of my datagridview come from database and the number for rows is not fixed. Thank you very much and God Bless. :) |
 | anybody know how to load 1 column data from accessdatabase into combobox item...i mean, i have 1 table " info_table and 1 column "product..so in product column have data like nokia and sony"..i want nokia and sony to be load into combobox item or dropdownlist...anybody help me...  |
| | hi im having errors with listview binding navigation specifically in last >> and first << here's my code [CODE] Dim inc As Integer Dim MaxRows As Integer Dim dr As DataRow Dim ds As DataSet Public Sub navigaterecords() txtMed_ID.Text = ListView1.Items(inc).SubItems(0).Text txtMed_name.Text = ListView1.Items(inc).SubItems(1).Text txtfname.Text = ListView1.Items(inc).SubItems(2).Text txtMname.Text = ListView1.Items(inc).SubItems(3).Text … |
 | Hello all, In the game microsoft flight simulator X, there are guages called "XML Guages" and there is a picture of the guage and an XML file which it reads from. What I am wanting to know for VB.NET is: Is there any way to implement this into my program? … |
| | my datagridview displays my records but when i click my next button it display error message " Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index " what should be the problem here?  |
| | Please i need help in leap year. My problem is, all of the month has a date of 1-31, except for feb. after i choose feb, as my month ( i'm using combo box ) , it removes the date from 29-31, and if i choose a leap year, it … |
| | hey guys, can you help me? im using a datagridview, and it is connected to ms access. every time i have an input same in the column where primary key is I already got an error. can you guys how to show a messagebox if the Customer Contact number is …  |
| | I have an online MySQL database, and I need to connect to it using Visual Basic. I have to read the values in the table and edit them. Any ideas? |
| | whenever i try to run my program i keep getting this one error: [IMG]http://i54.tinypic.com/2n8u815.png[/IMG] it works fine in college but on my laptop at home it doesnt seem to work :( does anyone know whats wrong with it and if theres a solution for it? thanks |
| | I have a set of code that builds a table as the user enters information. This information may be changed more than once before it is considered complete. After the user is done, I want them to click a button, and have that information entered into the SQL database where … |
| | Hi, I am using vb.net 2010 with access 2007. everything works fine in XP, but when I switched over to windows 7 I did not proper result some queries here is my query: [CODE]Select * FROM tblname WHERE fordt=#13-12-2010# [/CODE]. It shows result in access as well as as in … |
| | Hi, How to move a form without controlbox? Help please ... Thanks  |
| | i got this error i already checked my table definition [CODE] Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click da.InsertCommand = New SqlCommand("INSERT INTO AdmissionRecord VALUES(@Patient_ID, @Patient_Type, @LName)", cs) da.InsertCommand.Parameters.Add("@Patient_ID", SqlDbType.VarChar).Value = Txtpatient_id.Text da.InsertCommand.Parameters.Add("@Case_Number", SqlDbType.VarChar).Value = txtCaseNumber.Text da.InsertCommand.Parameters.Add("@Patient_Type", SqlDbType.VarChar).Value = IIf(String.IsNullOrEmpty(cboxpatient_Type.Text), DBNull.Value, cboxpatient_Type.Text) da.InsertCommand.Parameters.Add("@LName", SqlDbType.VarChar).Value = … |
| | Hello Daniweb! [COLOR="Red"]I'm using VS2010, targeting .NET 4.0. [/COLOR] I'm looking for options with programmatically printing PDF's from a windows service. Basically, I have an app that will have a folder full of PDF's that were created overnight. The service should be able to print them to a specified printer, … |
| | Hello everyone :) , this is my first post in here , well , i want to display a right to left langage like urdu,arabic .. my code is working fine , but doesn't display this kind of langage :rolleyes: , [CODE] <%@ Import Namespace="System.IO" %> <%@ Import Namespace="itextsharp.text" %> … |
| | Hi, i am getting an error like invalid attempt to read when reader is closed [CODE] Try Dim k As Integer = 0 Dim l As Integer = 0 Dim str_select As String = "select * from Suggetion_master where que_no=" & FrmErrorQuestions.dtgErrorQue.Item(0, FrmErrorQuestions.dtgErrorQue.CurrentRow.Index).Value dtgQueSuggestion.RowCount = 1 nxtlsdquescon.Open() cmd = New … |
| | Hi ,,, I need your help plz... i have programed a calculator and i have an On\Of button . when the user click On\Off button i want to disable all buttons i have except On\Of button, But also I need to enable all buttons when the user click it again. …  |
 | I hope you could help me with my documentation. Please help me to compare and give advantages and disadvanatges of the following based on your experience: MS ACCESS FORMS versus VB.NET STANDALONE APPLICATION versus WEB APPLICATION (intranet) for example : __________________________________________________________________________ 1.CATEGORY|2.ACCESS FORMS|3.VB.NET(WINFORM)|4.VB.net(WEB)|5.comments ___________________________________________________________________________ 1.DEPLOYMENT|2.fail|3.fail|4.pass|5.when deploying standalone applications,you need to … |
 | Hello Guys, My problem is When i'm trying to run this program Sql QUERY doesn't work properly , but the month and day are okay but it comes to year it doesn't work... :( anybody can help me please? thanks [CODE] Dim strSql As String = "SELECT * FROM tblAudit … |
 | Please how do i create a report at runtime in vb.net? I have no idea at all because i've never worked with crystal reports and most tutorials I've come across actually don't treat the topic. |
| | Hello, I have an Image Specifically for a certain XML file. And in Visual Basic is there any way to add an image, then have the image read from the XML file? Any Help would be awesome. :) |
| | I have searched and cannot find out why my code will not update the database. The program stops at the mDA.Update(mDS, "temp_data") line with the following error: System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217904 Message=No value given for one or more required parameters. Source=Microsoft Office Access Database Engine StackTrace: at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] …  |
| | I'm trying to bubble sort an array then display it in a list box. When I click the button the program crashes. Here is my code: [CODE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If Not TextBox1.Text = "" Then ListBox1.Items.Add(TextBox1.Text) ReDim Preserve numbers(numNumbers) numbers(numNumbers) … |
| | Hi everybody, i just registered here. Hoping to learn some from everything i find here and also hoping a bit to be helped out. I am creating a small program which has a few texboxes which i want to saved in a access database. My problem is i have no … |
| | im doing an employee attendance monitoring system, and i need to have a search feature which shows an employee attendance record in a given range of dates example date1: feb 14, 2011 date2: mar 1, 2011 results must be: feb 14: login time logout time feb 15: login time logout … |
| | Hello! I wonder if someone can help me. I have a combobox named Requirements and The values of it come from sql. I want to ask how can I detect if I already selected one item to avoid selecting it again the next time I dropdown the combo box. Thank … |
| | is there anyway how to merge 2 pdf files into 1 pdf file using vb.net. couldn't find a method to do it...pls help |
 | please people your help will be appreciated. i have a table with data definition: column Datatype BookID int AuthorFirstname nvarchar(20) AuthorSecondName nvarchar(20) BookTitle nvarchar(50) Price nvarchar(50) My problem is that i can't see the inserted data in my table Below is the whole code: [CODE]Imports System Imports System.Collections Imports System.ComponentModel … |
| | Hi, Sorry for many questions... I need help for button sound that when i click the button sounds. Thanks |
 | Good day. How can I get the path from a Resource File(Resources.resx) just like a file path in Windows in VB.NET? Example, I imported a picture to my resource file, and want to use the picture while my form is loading, and want to use the path from Resources.resx file. … |
| | Hello Guys, My problem is i don't know how to query TOP ORDER PROD using COUNT,AVG... anybody can help me please? thanks ^_^ [CODE] EXAMPLE -LIST OF ORDER'S- ITEM CODE | ITEM NAME | 4323 PROD A 4323 PROD A 4323 PROD A 4323 PROD A 4323 PROD A 2345 … |
| | Hi Everyone, I'm doing a point of sale application and would like to add code to my "Save" button that will insert data into the database. The form will first lookup a customer and set up data for an invoice header. The customer will be able to select products and … |
| | Hi all, 1. When I insert an icon in my VB.NET form, for example: a small shield icon, a white box appears around it and it's very annoying and ugly! I want to disappear the white box at the back of my .ico image. 2. This white backgroud not only … |
| | Hello all, I have a form that has a Timer and a label and a RichTextBox. What I am trying to figure out is how to get the Label to say how many more characters are left in the TextBox. Here is what I have. [CODE] Private Sub Timer1_Tick(ByVal sender … |
| | [B]..hello im here again.. can someone help me about this?.. i wanted to show the name of an employee once he/she typed the correct id number and password.. and it will show the name into the name textbox... same as the the current time once the user clicked the time … |
| | [CODE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSend.Click Dim strSubject As String 'subject title Dim strBody As String 'Body of message Dim strBody3 As String 'Body of message Dim strBody4 As String 'Body of message Dim strBody5 As String 'Body of message Dim strBody6 As …  |
| | Hey everyone, I'm currently working on an application with the following guidelines and need some help with completing it: Create an application that allows the user to enter a password that contains five, six, or seven characters. The application should create and display a new password using the following three … |
| | I'm a beginner student learning Visual Basic 2010, and im trying to create an auction countdown timer in my form but I'm not sure how to do it. The countdown timer Im interested in would be similar to the ones found in BeezID or Swoopco, where the timer continuously counts … |
| | Hello, Although I am a student, this project is not for school. I am trying to make a program that blocks an application from running. The irritating program resists having it's process ended (it automatically restarts via another process that also cannot be terminated). However, I have found that the … |
| | I have a remove button like i would like to delete just sigle selected row from both datagridview and the actual database.the problem I am having is in deleting selected row.if i dont use the parameter the contents of the table gets deleted ,i dont have any primery key just … |
| | Hi im having a problem on displaying my Date ng my listview here is my code [CODE] Private Sub frmTransaction_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try IsConnected("Select CONCAT(person.lastName, ',',person.firstName,' ',person.middleName) AS FullName, transaction.transactionDate from transaction INNER JOIN person ON person.personId = transaction.personId", False) Call Loader() Catch … |
| | Hi there guys really hoping for some help after searching Google for a stupidly long amount time and coming up blank. I am using Crystal Reports 10, Asp.net 1.1, SQL Server and Visual Studio 2003 with VB. I have an Image field in the database that I need to retrieve … |
| | Does anyone know how to make sure the accdb become included in the program build/publish so it will install to the correct directory? And if so could they tell me please? I have searched high and low and simply cannot seem to find the correct method to get this to … |
 | Hi guys, I have searched for a sample code about 3x3 moving window which will be used to change the pixel values using the surrounding 8 cells in vb .net. It will start manipulating from (0,0) or top left corner pixel of the image and end the process after the … |
| | hello guys:D, i am new to vb.net and need some help from you. i have created an application in microsoft visual basic express 2010. it works fine when i debug . also works fine when i publish a setup file and launch it. it works awesome on my computer. But … |
| | im trying to add two radio buttons together to get a full price, they are split up by two group boxes. Meals and dormitories, I have the prices on how much they are, but I dont know how to put the right radio buttons in the right places and then … |
The End.