i want a automatic packet number in text box if there is no data in database...if there is a data i want to add 1 in packet number to next packet in text box'packet no= JA0001
q = "select max(mid(pack_no,3,4))as max_pck_no from mef_info where mid(pack_no,1,2)='"JA "'"
cn = New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=Database Path ;Jet OLEDB:Database Password=*********;")
[Code]...
i would like to know how to automaticaly save a given chart from an excel 2007 file into a given folder with a given name ^^i have already got the vb sending the data i want to the excel, and with macros within excel to make the line chart in the excel file..
View 1 RepliesI'm using MS ACCESS for my dbase..i have a tblborrow where you can find transac_num ..now, i have in my form a label which here, you can see how many transactions you have done already(i'll name it sa lbltransacno) and a save button..what i want now is that.. every time the user save a transaction.. the lbltransacno will automatically go to its next number.. but of course.. the user should fill up the information needed.. if those are not filled up, and he click the save button.. the transaction will not be counted.. how to code it?
View 1 RepliesI'm writing a program for my algebra students to practice integers.Stuff like....
3-6
-4 + (-5)
3(-4)
-15 � 3
etc.
I want to show an explanation and for the addition and subtraction, I want to show it on a number line. For example, if the problem is 3 - 7, the number line should show and arrow to that goes right to 3, and then left 7 units (starting from 3). Then the student can see that the answer is -4.I could probably do this with some string manipulation, but what would be the easiest way to do it in a picture format? Maybe a bitmap.
In VB if you prompt the user for a number between 1-20, then a word, how do you get a text box to show the word the same number of time as the number selected using loops?... Ex: please select a number: 4 / select a word: cat....the text box should display ::: catcatcatcat ........
I am doing this for a class and my brain has locked up. Prob. just over thinking it though. Thanks in advance for any help!
am writing an system application for a company that must generate inquiry id and order id automatically. Whenever a customer makes a new inquiry or new order by clicking the add button, an automatic number should be displayed in the text box and when it's saved, it should be saved in the database access.
View 9 RepliesI wrote a function to format numbers like this: 123456100,12 -> 123.456.100,12 (I have a function too, which converts numbers from this strings).Now, I have a dgv and a column with these numbers (or rather strings). The sort mode is set to automatic. If I sort the column, it doesn't work, because the values are not really numbers, but strings. But I get the same result (the sorting doesn't work), if I use the formatnumber function (this returns strings too).
I could use the programmatic sort mode and before sorting I format the strings to numbers, then sort the column, and then format the numbers like above. But this is a bit slow (the dgv has appr. 800 rows), and in this case, I haven't an arrow next to the column header text.is it possible to sort the column like a normal number-column with automatic sortmode?
All I try to do is to display 10 as 10.00
Dim amount As Double = 10
lblAmount.Text = Format(amount, "##,##0.00")
And what I am getting is this
&10=##,##0.00
I have form 1 (User Details) and form 2 (Transport Usage). Now in form 1 there is a textbox which shows the user's ID and when i click a button that links form 1 (user details) to form 2 (transport usage) i want another textbox in form 2 to have the same user ID as in form 1. (the user ID always changes)
View 9 Repliesi have a division of 2 integer that give me a result as2,3944534 ...how i can give e result as
View 3 Repliesis there a way to show my running number in a text box. the logic is like this, i have 1 button once i click on that button,the textbox start running a random number start from 1-47. when i click again the running textbox stop.here is my code.
If lb_count.Text = "0" Then
Dim RandomNumber As Integer
RandomNumber = RandomClass.Next(1, 47)
[code].....
is it possible to make something that can show the number of active applications? For example some code that say: Label1.Text = Number of running applications
View 15 RepliesI have a form (FRMQUESTIONNAIRE). It contains, a listview table, a panel and picturebox, 2 combobox, 10 questions with 5 radio buttons each question ( A survey),A log number id (I just used Label in here) and 2 buttons ( save and skip).
Problem: When I click one item in listview table, the picture captured realted to the item click in listview table will be shown in panel beside it. However, the problem start to happen when the log ID is not appear accordingly based on user selection on listview table.
What I reckon start of the problem: - Previously The listview table(listview1) in frmquestionnaire was in frmqlist(another form). But to suit user requirement, it has to combined with frmquestionnaire. In frmqlist, I use a label Image. This form contains the similar details in frmquestionanire except there are no 2 combobox, 10 questions with 5 radio buttons each question ( A survey),A log number id (I just used Label in here) and 2 buttons ( save and skip) But it have a button(Proceed to survey). Having said that, when user click an item in listview(Frmqlist), the picture will be shown beside it. User will click button proceed to survey and frmquestionnaire will pop up. Here, It shows the correct Log ID based on user selection in frmqlist.
But now....
I have combine everything in frmquestionnaire. I am facing as the LOG ID is not showing according to the selection. As a result, I can't save the questionnaire answer as well as this log will be used to save in database.
[Code]....
How can I get VB.NET to show the number of each code line, so that I can more easily keep track of where things are in a lengthy program?
View 6 RepliesI mean, a big number like million in this way: 1,000,000? I know i have to parse the number somehow and add the commas there and stuff, but how?
View 2 RepliesDoes anyone have a 1 to n thread example in which n threads are created dynamically? There are a number of examples that show a definite number of threads, and some that imply n threads by using a tcp ip listener or a file system listener. However, I'm looking for a 1 to n created in response to a dynamic requirements, provided purely by and for my program.Essentially, my requirement is to be scalable. 1 to n threads based on application throughput should make this pretty easy to satisfy.
View 9 Replieshow i can format a number to only show decimal places if needed?For instance...
string.format("{0:SomeFormat}", 26.9) = "26.9"
and...
string.format("{0:SomeFormat}", 26.0) = "26" 'Drop decimal for whole numbers
so below is my code. I am trying to get the autonumber generated in newdb into txtcallid field. the error i get is that the field is not unique. What i am trying to do is to get the form to fill the db witha new blank record, assign the auto number and then display that number with the blank record info in my form. I will be making it so that the data must be changed before saving so that the form will not be blank save for when it is loaded.
Imports System.Data.OleDb
Imports ChessyFunk1._5._1.ADODB
Public Class frmNewCall
[Code]......
I have 2 panels set up, one contains the rich text box the other one contains a single label. The am currently using the following code however it is not working.
Dim line_count As Integer = mainEditor.Lines.Length
Dim linecounter As Integer = line_count
linecounter += 1
line_count = 0
[code]....
When logging into my system, I select the number of result that needs to appear on the report. In my stored procedure it selects count of all the data for a period. It returns all in the information, but I only want the number of records to appear on the report that I selected at the beginning.
View 1 Repliesi have a database shown on VB 2008 showing music information. i am trying to show the track with the greatest number of sales however it is only displaying the current information on the screen (i am showing the access database in multiple text boxes) rather than searching the database.
this is the section of code i am struggling with:
Private Sub Btntopseller_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btntopseller.Click
Dim index, largest As Integer
[Code]....
i also would like to add to this, i would like the user to be able to select a year from a list box to show the track with the greatest number of sales in that year.
I have created a com dll in vb 2005 and used in vb6. It's working fine.
I have a question why Windows Explorer does not show it�s version number? I have properly set both the Assembly version and File version.
Again I did create a test com dll - windows explorer does show it's version number properly.
I need to know how create a number that increases every time my main form is loaded. This would go in succession. So the first time after putting this code in it would show the number 1. The second time I open my main form it would show a number 2, and so on.
View 2 RepliesI have a form with a textbox, a button and a label. If I put a number in the textbox this number shows in the label but after that the label start to countdown from that number to zero.
View 5 Repliesi follow this script Quote:
[Code]...
I am trying to convert watever is in the ComboBox to a number. So say I select "Grey" in the ComboBox I want it to show a number in the file i am making. My.Computer.FileSystem.WriteAllText(TextBox_ChooseFolder.Text & "" & TextBox_ItemID.Text & "-" & TextBox_ItemName.Text & ".sql",<ComboBox Number Here>, True)
I have tried
My.Computer.FileSystem.WriteAllText(TextBox_ChooseFolder.Text & "" & TextBox_ItemID.Text & "-" & TextBox_ItemName.Text & ".sql",If ComboBox1.Select = "Grey" Then "0" ElseIf ComboBox1.Select = "White" Then "1" ElseIf ComboBox1.Select = "Cream" Then "2" End If,True) ...I am new to Visual Studio!
i have a loop in here what suppose to add a rondomly choosen number and show it on the label .text increase every time by the the same number when appear. It does not do it correctlythat is the
Private Sub licz()
Dim pbs() As PictureBox = {PictureBox1, PictureBox2, PictureBox3, PictureBox4, PictureBox5}
Dim las() As Label = {Label1, Label2, Label3, Label4, Label5, Label6, Label7, Label8,
[code].....
My code worked fine until i added this balloon tip function url...me.show now shows as an error [code]
View 2 RepliesI have an app with 4 buttons that each generate a random number into textbox, before this number is entered i would like to have a progress bar at the bottom, well show that its processing basically.
View 4 RepliesIs there a way to show the line number of the line of code that caused an exception within a Try...Catch block?
View 5 Replies