I am writing a program that takes a SSN into a number field.Issue is when a SSN is entered with a leading 0. Ex. 012-34-5678 The zero is cut off and turns it into an 8 byte field, which is not good for SSN obviously.What can I do to prevent this from happening?
View 10 Repliesi am using vb/vb.net and the database is visual foxpro 6.0 then i want to create the tables from the application using sql statement.i need to add the number field into the table. i can not add the number field in the tableres.open "CREATE TABLE Customer ( CustName char(50), CustId int(2))",conXavier
View 2 RepliesThis is probably a stupid question, but how do you make a function which takes a number then does an operation to it again and again until it gets a vlue which it already has seen, when it returns all of its values? I have this function:
Private Function fractal(d as string) As double
Fractal = Val(D) * (Val(D) - 1)
Fractal = FormatNumber (Fractal, 2)
[code].....
I am working on a program that takes data from a survey in the program and needs to compile it into a PDF file. Optimally it would just be a snapshot of the filled out survey. I tried using the PrintForm component in the PowerPacks section, but I need a PDF not an EPS.
View 1 RepliesA couple days, I figured up a working program and it was def. faster than what we needed. Now, adding a couple more loops, the program barely uses any memory, but the cpu used spikes up to 90+ and just letting it sit doesn't help.I tried taking out the couple loops I put in, but it does not revert back to being fast. It's nothing big, but since dealing with 1000+ excel files a day, I'd rather not do that by hand.
how many infinite loops vb.net can support without dragging down the system? I know, infinite loops are poor design, but it works.
How would i write a program that takes three values X Y and Symbol. the program is supposed to display a rectangle which is X
View 1 RepliesI am not recieving any errors, but the program is not doing what I had expected. I wish to make a program that randomly takes characters (well, not completely randomly. I used the table of letter frequency from wikipedia and included that data in my program by figuring out the max for the random numbers from the percentages in the wikipedia chart.) and adds them to a long list of characters ands saves the file every 5 minutes. I have calculated the timer interval so that the number of miliseconds shown is equal to 5 minutes. I am getting the textwindow, and it is showing (rather rapidly, as I need it to be) a long random list of characters (including spaces). The problems are (A) I am having difficulty saving the text as a file. You'll find the code that is supposed to do that at the bottom. The other problem I am having is once so many characters are added, the ones at the top start disappearing. I would scroll to the top, and each time I did so the letters at the top had changed (this is all during the same test), but I need all characters to be stored when the file saves. Granted, I haven't actually seen one of the saved files as I have not figured out how to make that work. One other thing, not sure if it's important, I haven't run a published version yet. I've only been running the debug builds. Does that affect how it handles actions with files?
Module RandomModule
Dim X, Y, contents As Primitive
Sub Main()[code].......
How to terminate function/code (not entire page) when it takes some time, for example, more than 1 sec?[code]...
I found the command "Server.ScriptTimeou", but it stops the entire page instead of one command.
I've been working on a program that takes input from a textbox, removes the punctuation, puts the words into an array (using the split method), and compares the array against a reversed copy of itself to determine if it is a word palindrome or not. I understand the logic, but I'm getting kind of caught up as far as what code to us. This is what I have so far, but no matter what I enter into the text box, nothing happens. I'm completely lost as to what I'm doing wrong.
[Code]...
I'm writing a program which takes one item from each of two lists and combines the items in one of three ways selected by the user. The results of the process are provided in either a summary form or a detailed form, again selected by the user. As it's currently developing, this program will contain six subroutines covering each of the six combinations of user selections, which are stored in three Booleans. Selection of the appropriate subroutine is done through traditional "if then else" coding.If I understand OO and Visual Basic (Express 2008) correctly, I could make the subroutines into different variations of one method, which when invoked would automagically use the correct coding depending upon the settings of the Booleans / properties. Assuming this is correct, the problem is that I have no idea how to actually set up code like this.
View 4 Repliesi need to make a program that simply takes current date and the input date (users birth date) from the user both as i integer then if the users is 18 or more then the back color turns green otherwise turns red.
Code:
Public Class Form1
Dim int_ThisDay, int_BirthDay, int_ThisMonth, int_BirthMonth, int_ThisYear, int_BirthYear, int_DifYear, int_DifMonth, int_DifDay As Integer
[Code]....
I'm trying to make a program that takes my old records from Access and moves them to MySQL. Its supposed to take records from 3 different tables in Access to 3 different tables in MySQL. The first table is "Orders" and it sorts the ones to pull to the dataset, taxDS, by "Where Status = 'Waiting Payment' OR 'Cancelled'". Then the second table pulls its info(this is where i'm having trouble) by the "Control_Number" in the "Orders" table, so basically if the control number isnt already in the dataset its not going to pull the data into the new table "FNF Taxes".
Imports System.Data.OleDb
Imports MySql.Data.MySqlClient
Public Class Backup
[code]....
So now after my 3rd edit and no answers, I'm finally at the point where I'm only stuck on my For..Next statement not working, How can i get this statement to run for each 24,000 controlnumbers?
Alright, So ive returned to using vb after several years now. Ive programed in VB6.0 years ago and I was quite proficient at it. However after returning to vb (now using Visual Studio 2010). Either Ive forgotten everything, or something has changed. For a university project. Im trying to write a program that takes a string of bits and encrypts it using DES Encryption.
[Code]...
I've recently started programming for Visual Basic Express - 2008, and I'm currently trying to make a program which takes a bunch of inputs (Name, Age, x2 score results) and then turns this into an output at the end which varies depending on the score results.
I've stumbled upon a small hinderance, which is that the very final stage which has a Console.Writeline does not appear after testing the program. So, everything else functions fine, but as soon as it gets past the "Console.WriteLine("All pupils have been calculated, the results are...")" command the program closes itself.I'm not looking for much help, just wondering exactly what is causing this to happen. I also realise that my coding is sub-par and is coded in a slightly odd fashion, but I'd rather just get this one to work and use the mistakes from this one to correct my future work.
Im trying to create a program that takes an amount entered by the user and then convert it into Half Dollars, quarters, dimes, nickles, and pennies when the calculate button is clicked. Each coin has its own function and is shown in separate text boxes... right now i cant get it to work correctly. When i try to get half dollars to work it rounds up and then the rest of the coins say 0. How should i do this?
View 5 RepliesI've been trying to make a program which access the internet and takes the source code from the webpage. I've copied this code from the internet:
[Code]...
I'm making a program that takes common applications and installs them silently using batch files. Someone would select the programs they would want to install and my program will write a giant batch file and execute it to install whatever they want. Heres the problem, After the user selects the programs they go into either one or two lists. Non Silent Installer List Or Silent installer list.
Some programs I have simply won't go silently so from there they can choose in what order they want to install these programs. Then there is a combo box that tells weather you want to install non silent programs first or last. From there you hit add to batch file and it would add everything in listbox1 and listbox2 in order. Listbox1 would contain just the text "MalwareBytes" for example. Along with Novell Groupwise and Firefox. How do I get that to add to the Batch List as a code and in order? So the user wants Malware bytes added first to the batch file. How do I add that to my batch list as a completely different code?
[CODE]..............
I need to write a program in VB 2008 express that takes an user entry from a textbox and strips out all the spaces, changes it to either all upper case or all lower case then checks to see if it is a palindrome. I must also include a loop structure and a decision structure. I have seen bits and pieces of code but I do not really know how to put them together. Basically I need it from the button click to the end. ?
View 3 Repliesi want a button to perform a function of checking the last digit number in a field of a table in and add a digit to it and display it in a textbox.
View 1 RepliesHow to sum the number value(textbox) to my database field ?
the red section doesn't sum the value(textbox) to my data field.[code]...
Probably a simple question for most of you. I'm putting members of a group into a SQL Database so we can better manage attendance and 'points' that they earn for doing work. I've written the program in VB and have the SQL server running fine. However, I have created a separate table to handle the points and have marked the relationship between the table - the column is named 'PointID', and should be unique for each person. When I add a new user to the database, I want it to automatically assign a value to that without me having to do anything extra beyond pressing save. From this PointID, it should identify the user and it will bring up the person's points.
View 12 Repliesi have 2 fields in the database (sql server 08)
Dob = "05/09/1965"
license_age = 16
how do i get the number of years this person hs had licence. so basically dim age1 = current year - (dob - license_age)how do i find out which year he got his license based on the above two fields?
I created a code that inserts a number into a row every time someone submits a form.I am able to read the data back to the form using a loop.My confusion is I would like to get the highest number from the data field(column)Lets say the Field(column) has five numbers from 1 to 5.How do I get the highest number?I was looking at using a loop to go through the field and bring out the highest number, but should I use an array?
View 5 RepliesI have in my DB a few number fields, but I would like put null values or empty values in some of this fields...
I had try this but without results:
If valorcolocardebito = 0 Then
valorcolocardebito = Nothing
End If
[Code].....
Private Sub ButtonSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonSave.Click
[Code]...
Is it possible to put Number validation in required field validator in asp.net text box?
View 7 Repliesso 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 got a Mysql sql database for my project. The id field is set as auto increment, which seems to function correctly. But on the form in my text field and datagrid i see a negative number, while in the database its a postitive number. I do not really plan to use the id field right now, but when i do it might cause some problems.
Anybody know why it would show as a negative number on the form(textbox/gridview) and as a positive in the actual database?
I need to write a program that requests a high number and a low number from the user, then the program searches the array and finds all elements within the two numbers. The program is used to search for past presidents, so if I type 43 for low number and 44 for high number, the program will display:
George Walker Bush
Barack Hussein Obama
I think I have an idea of how to search up to a certain point, but not to stop at a certain point....Here is the code that I have for that particular sub procedure:
Quote:
Private Sub btnDisplayRqst_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDisplayRqst.Click
Dim sr As IO.StreamReader = IO.File.OpenText("PRESIDENTS.TXT")
[CODE]...
How can input number to database where my field in database data type money.[code]...
View 5 Replies