I have a query table like below
[code]...
I have a "bank ref id" text box and value is " yy/98"One the basis of selected row, bank ref should update on second table.
I am doing an assignment for my intermediate programming class. It is due tonight at 730. Anyways, I am almost finished, but I have run into a snag. I have this "bank application" and we are storing the info in a text file. However, whenever there is a deposit or withdrawal, the "accounts.txt" file is to be updated. All of the new account info is being written to a "Temp.txt" file and eventually will be renamed to the new "Accounts.txt" file. The problem I'm having is that it isn't writing non-updated account info to the temp file and I don't know how to make it do that while keeping the accounts in order and not rewriting the same account info more than once.
Here is the code for the entire project so far:
Imports System.IO
Public Class Form1
Private Sub btnProcess_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnProcess.Click
lstDisplay.Items.Clear()
[Code] .....
I'm using VB 2008 express edition.I have to show the growth of savings in a bank account using input from two text boxes that will be deposit amount and interest rate. I have attached a picture of my form.I have declared my variables and now I'm working on my processing.When the compute button is hit, based on the deposit amount and the interest rate, the amount of years it takes to double the money and the amount of years it takes to become a millionaire with that amount will be displayed in the lower text boxes.
Here's some of my math reasoning...
Doubling time formula : 2P = P(1+ i)^n I tried solving for ^n and got: n = logP(1 + i)/log2P
Is this correct? How do I express logarithms in VB?As for the amount of years that it takes to become a millionaire, can I simply take the deposit amount for example $500 dollars and divide 1,000,000 by 500 to get 2000 so it takes 2000 deposits of 500 dollars each to reach 1 million. Is my arithmetic correct?
I have developed a software, now i want to float in market on license basis, what i want to do is data, there should be some code which generate sever hardware key and then prompt for license key.
View 1 RepliesIt has been a while and I got tired of it, what I am doing now is going to my accounting program to print out checks.Is there anyway I can print out checks on VB.NET?
View 6 RepliesI am creating a banking system using excel and visual basic programming. To create a withdrawal macro I must have a button which will perform the following things: Ask the user via input box the account number, amount and pin. The program should then search for the relevant record in the account sheet, check the pin and reduce the balance by the correct amount. a message box should then result that tells the user they have made a successful withdrawal the program should not allow a withdrawal if this makes the corresponding balance less than - 1000
View 3 RepliesI have been asked to create a Framework to be the basis of all our drafting toolsets. The approach I think is best is to outline all of the Classes that will be required (Text, dimensions etc), identify routines and properties required for the Classes and document in a spreadsheet.
View 2 RepliesI want to create a page in asp.net website . it has to have one text box . the user enter the productcode in the textbox and click on search . when the user click search i want to display all the information about that product from product table.
[Code]...
i have datagridview with rows in it and one of the col show type of product. there are row with same type. on click of button i want to select all the row where productype = 1 (for example)
do i have to go thru each row in grid and check the condition for product type and then select it or there is another quick method.
I am trying to find some source code that is reputable such as code created by Microsoft or a similar entity that has released the source code for AES 128 encryption in the latest VB .net framework. My understanding of encryption methods is sufficient though, I am not an expert on the subject. The following source code [URL] on the MSDN network works very well in VB though with the advent of more secure AES encryption, I would like to be more prudent by using a more secure method. Unless someone can prove or explain that this source code is at a level of a "bank standard encryption" or better I would like to be pointed in the right direction of more secure code or advice from experts.
View 1 RepliesI query on the data bank with Ado, put everything in a Dataset, changes the data and then lets it write in the table. How can it be that is written in all lines except the first one? I do not find any error. Someone can help me? Here the code:
[Code]...
i have my code as below in which i need to check the column(3) and column(4) for a condition and based on it i need to change color of the text and add some text to the value. Kindly guide for the same...
Dim sDs As DataSet
Dim sTable As DataTable
Dim sBuilder As SqlCommandBuilder
[Code].....
I am developing a program in which I add the payments for my bills on a monthly basis. I have the design layout and the logic thinking, but having a little difficulty getting the database codes in place. I have 2 comboboxes that act as drop down boxes (1 lists all 12 months and the other lists the years, only 2009 for now for testing).
My access database has 3 columns (name, dates, amount). The names are pre-populated and the only columns displayed in the datagridview are name and amount.
When I choose a month and year, the datagridview should populate with the amounts entered from that month. I am having trouble debugging which lines of code are not working because there are no errors showing, just seems that it stops running at some point.
Dim Connection As OleDb.OleDbConnection = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\BillTracker.accdb;Jet OLEDB:Database Password=password")
[CODE]...
I am trying to come up with a way to store 3 pieces of information for each employee in the company on a daily basis. So for instance:
Day 1: Joe, 8, 80
Day 2: Sam, 10, 90
Day 3: Bill, 5, 40
Day 4: Bob, 8, 40
Day 5: Sue, 2, 50
I am very new to collections and most of the applications that I build are Create, Read, Update and Delete type applications that don't really need arrays so I have almost no experience with either.
This is what I have so far.
VB
'
Dim iDays As Integer = NumberDaysPerMonth(Date.Now)
Dim DayNumber(iDays) As Integer
Dim EmployeeRecords As List(Of String) = New List(Of String)
For i = 1 To DayNumber.Count - 1
[Code] .....
Create a project that determines the future value of an investment at a given interest rate for a given number of years. The formula for the calculation is Future value = Investment amount * (1 + Interest Rate)^ Years..Form- Use labeled text boxes for the amount of investment, the interest rate (as a decimal fraction), and the number of years the investment will be held. Display the future value in a text box formatted as currency. Include buttons for calculate, Clear, Print, and exit. Format all dollar amounts. Display a message to the user for nonnumeric or missing input data.Remember that the result of an exponentiation operation is a Double data type. Interest rate is annual.So far this is what I have and I am missing something(s) in the calculate process.[code]
View 14 RepliesI am working on making a program that will log into my internet banking site (this will most likely have to be done in IE) grab my current available balance and store this to a string, before I do any research I was wondering if anybody had anything like this already completed.I also need it to do this silently (as in no open IE windows) no visibility of program running to the user.
View 7 RepliesI have problem on my project on vb.net I'm using visual studio 2008. May I know how to do to show all my sales everyday. I have sale almost 5 items every day I want to have list for this. I'm new on vB.net..
View 22 RepliesI have made a banking system in which a user can log in via a username and password they can enter the amounts they have into their bank account, but I need to be able to "withdraw all" all that users money via a button and show that amount once clicked.
View 2 Repliesu have a problem with a auto number of access field,Description : in my bank(access) i have 4 field , one of them is my primary key(id) and it is AutoNumber,in my app i connect to my db and i insert a record to my bank and it works correct,but when i delete a record which id is 1 , no one of my new record has id 1 , and it is a problem in future because i should have a 40000 record and i may delete a lot of them ,
View 1 RepliesI have an awful lot of it "down" by now, in that I understand how to design a form and add buttons, how to set properties and am even learning "procedures and parameters". But I think I'm missing something, and it's probably my own fault as I jump around the book (I'm about 1/2 way through the 500 page volume, and have completed chapters from the beginning and middle) I think I understand the "Visual" part, and I think I even understand enough of the "Basic" part to get going.
I want to write a simple program to take our downloaded bank statements (what better time to do this than tax time and sort them out. They are .pdfs so I need to first copy the text and sort of "break it apart" and add tabs etc so I can import to a database (I've been playing around a lot with databases too, and have a good grasp on that part of the equation) I have been reading (in the book) about reading text files with StreamReader, and Replacing Text Within a String, etc. how to "get going..." how to even start writing a program. Do I start with a form? Do I need to create a Visual interface to run the Basic?
Are there existing examples somewhere I could "get my feet wet" working with that already have simple find/replace functions? It's almost as if I know too much about the more complex stuff like "Denoting Scope Using Variable Prefixes", but not how to write a simple program. I'm adding to this -- as I think about it, the main "Project" used throughout the book is a Picture Viewer. I think it if had been a "data replacer" or something like that, I wouldn't be asking this question! I don't want to open a picture, I want to manipulate a text file.
I have a problem with Reporting
1)i introduce my bank to Crystal Report as Datasets
Describing :
1)when i introduce my bank to my project then i make a blank Reporting and i choose project data>Ado.nets >datasets then i choose my datasets
2) i design my reporting and but i cant use it in my project...
Attached image(s)
I am trying to come up with a way to store 3 pieces of information for each employee in the company on a daily basis. So for instance
Day 1: Joe, 8, 80
Day 2: Sam, 10, 90
Day 3: Bill, 5, 40
Day 4: Bob, 8, 40
Day 5: Sue, 2, 50
most of the applications that I build are Create, Read, Update and Delete type applications that don't really need arrays so I have almost no experience with either.
VB
'
Dim iDays As Integer = NumberDaysPerMonth(Date.Now)
Dim DayNumber(iDays) As Integer
[code]....
I need to create a window service that will check a Date field in the database and on the basis of that date it will send an auto generated mail.I am new in the field of Window service.
View 1 RepliesHey everyone, i am in the process of making a replica deal or no deal game.It will have 20 cases, and have done half of the program i am up to programming the game stage I am a little confusd on how to make the program give a bank offer after x number of clicks?
View 8 RepliesI have this function which evaluates the contents of a textbox (or combobox or maskedtextbox) control and, in conjunction with a KeyPress event, will either allow or disallow the input. It is quite useful for dates or textboxes for which only numeric input is valid. It allows a set number of digits after a single decimal point, if specified in the function call. It also allows the backspace character if the textbox is full.
I would like it to allow me to input what would otherwise be valid text when the textbox is full but one or more characters are highlighted (and would therefore be replaced by the keypress character.
[Code]...
I have Three text Boxes and i want to use Cut, copy, paste method.But the problem is when i copy one text box matter and then apply Paste option through menu control ,then matter is displayed all three text boxes.
View 1 Repliesi have retrived this datatable from datasource and i want to add a more colum 'category'basedon the each value of each Role, like if role column has the value '90 daya client' then in the same row it should have a value 'DC' in the category column.n make a temporatry dt1 table but to add related values.
S.No First Name Last Name Role Date
1 Us er1Name User1Name 90 Day Client 11/01/2011
2 User1NameAtt1 User1NameAtt1 90 Day Client 11/01/2011
[code].....
Several months ago, I asked someone here if it was possible to perform "DoEvents" on a conditional basis. This was for a VB6 application and it worked okay. It will not work in VB2010 and I was wondering if someone could tell my why?Error Message from VB 2010:
A call to PInvoke function 'MyApp.frmMain::GetQueueStatus' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention and parameters of the PInvoke signature match the target unmanaged signature.
[Code]...
I'm trying to display a list of "bank transactions" (these are fake, it's a game) so no need to worry about security but what tool should I use? I've use a Grid view for other parts of the game and don't want to "overuse" this tool.The list may have 2 rows it may have 30 rows although I might limit this? It will need to be able to use a date, a text reason and a value.
View 3 RepliesHow can i get selected text in web page and put it on textbox? This is the text that i want to copy.
[Code]...