how I can get the LIKE statement to work if the user enters a number like 403* ? The sql works if I do not enter an *
strWildCardFound = InStr(TNSearchTextBox.Text,
"*")
TNSearchTextBox.Text = Replace(TNSearchTextBox.Text,
[Code].....
count the number of times when a user enters a character followed by , and I want to count , number of times. So far here is what I have if you also know a little about the split function can you check to see if what I have is right?
Private Sub Strat0_LostFocus()
Dim q1 As New rdoQuery
Dim LO As Integer
[code]....
I am wanting to allow a user to enter a number and depending on what number is entered, it will allow that many entries. For example, if 5 is entered, the user has to enter 5 numbers. Those 5 numbers will then be added together.I 6 is entered, 6 total numbers will be added.I was trying to do this with a for next loop but I wasn't getting anywhere.
View 5 RepliesI am using a vb windows application I need to allow a user to enter their ID num in a text box and it need to automatically populate their date of birth
View 6 RepliesMy homework assignment is to create a project where a user enters a password that must be at least 3 characters long with at least 1 number and 1 alphabet character. After that the password has to be encrypted so that vowels become X, numbers Z, and it reverses. For example, a password of CS2301 would be ZZZZSC. There's supposed to be Loops to extract 1 number/letter at a time and search for them in the string to validate, and I don't know what to do. The form itself has a Text Box to enter a password and a label to display the new one, and a Go button.
This is what my code looks like so far.
Option Strict On
Option Explicit On
Public Class Form1
[CODE]...
I have a login form that I made. The user enters a username in textbox1 and then enters a password in textbox2. The user then hits the submit button (button2) and from there it works beautifully. The problem is, I would also like the user to be able to hit the "enter" key after they fill out the password textbox (textbox2) and have it be like they pressed the submit button. When the user hits enter right now, the form hides.
View 4 RepliesI am trying to create a program that the user enters the number of enrollments for 5 different campuses during two semesters. I just got started and here is what I have so far but when I run the program it is stuck in an infinite loop and will not go to the next function. I am not sure how to end the loop.
Here is what I have so far:
Module Module1
Dim SIZE As Integer = 5
Dim campus() As String = {"Decatur Day", "Decatur Evening", "Huntsville Day", "Huntsville
[CODE]....
I was developing my own project in the university so what i am stack is to have save button which firstly validates what the user enters the form. for instance if the user skips the text fields, i wanted to restrict the user to fill all the form and when he completes, the save must be accomplished.
Here's the code i was trying to put but i was having problem saying the windows.forms.etc is unable to convert the save as Boolean and something like that.
Dim success As Boolean
Private Sub Save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Save.Click
[CODE]...
How to write a if else statement to check if the number user enter follow within a range.
View 5 RepliesCreate an application that allows the user to select or enter into a combo box the number of days a person will work, and calculates the total amount of pay she will receive over that period of time. Salary is one penny the first day, two pennies the second day, four pennies the third say, and continuing to double each day.
The combo box must list the following items: 30, 180, 365, and 1000. Must be the default drop down box. Use a validating event procedure on the combo box.
The program should go through a loop once for each day, doubling the number of pennies with each iteration of the loop. You will need a running totl of the number of pennies that you add to with each iteration. To calculate the total amount of pay, multiply the total number of pennies by .01 and show the result in currency format.
Public Class Form1
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
[CODE]...
I am doing a bar cash register and I want to use a if statement to see if fosters button and number 1 on the number pad are both pressed then multiply constant by quantity number
View 1 Replieshow to take the value that a user enters into a textbox and add it to values entered into other forms by the same user. I want the values to all add together onto a new form in a label. Code for textbox:
[Code]...
I've been using KeyPress to help limit what the user enters into certain textboxes. e.g. here's my code for a Phone number. It only allows for numbers and dashes: [code]It's all working fine; however, the thing I hate about using it is that when ever have to do debugging of the screen, for each keypress into this textbox, it goes into debug.I'm wondering if it's possible to do something similar when the user clicks the save button. Has anyone done any type of validation like this?
View 6 RepliesWell, I have a form called customers. Login form and mainform.
So my clients want to have an option that explains this: If a user enters information in the customer form, then that information has to be confirmed by admins panel.
Get me well. When application program loads with a limited user, I set some buttons hidden so that only admin can see it when they log in. so in that case, users are not capable of inserting anything in the customer form.
But this time they want users to insert information then the information goes to administrators to confirm the information...if admins accepts the information, then information is then goes to customers table in database. If they don't confirm it, then that information will be ignored.
am using vb.net 2008 with sql server database.
See
Public Class Form1
Dim sql As String
Dim conn As New OleDb.OleDbConnection
Dim da As New OleDb.OleDbDataAdapter
[CODE]...
The problem, The INSERT statement works fine in the form load but not in the button click event?
I've watch the videos on asp.net and I've looked online and have found nothing.
I have a search box on a site, that searches for recipes. Each recipe has a what you're making image, a title, and type(dessert, lunch, dinner).
All of these items are in a DataService, which I can query against and get a list of the items they are searching for.
Now I'm using VB's ASP.NET MVC3 w/ Razors for the site and I'm trying to get some auto completeness going on when the user enters text.
What should happen is when the user enter text, it will call an ActionResult in the Search Controller. Which queries the DataService and puts all the search results in a model. With that model I return a PartialView, results, with the Model included.[code]...
I have two textboxes on the screen. They are used for startdate and enddate. If the user does not enter anything in the textboxes I pass nothing (VB.NET) to the webservice. When the webservice receive it on the other end it shows the value "#12:00:00 AM" which I think is the default for the datetime field. Anyway, now I do not want to pass this value to Stored procedure since it will not work. How can I check before sending values to sproc that the value is not the default datetime.
View 3 RepliesIs there any way to use a DTP and have nothing but the slashes show until the user enters a date?
View 7 Repliescodes one that validates that user will enter only uppercase letters in a textbox and no numbers and symbols. The second one should validate user only enters string no symbols and the third should only accept string and symbol
View 1 RepliesI started learning visual basic a while back but stopped, now I am trying all over. I created this very basic windows form application. What I am trying to do is add a greeting based on the time of day. Example, the user will enter a name and click the button to get a greeting; example: Good morning Bob.This greeting is based on the time of day; example if time after 12:00pm, good afternoon, if greater then 5pm good evening and so on.Here is what I have written so far:
[code]...
Im using Visual Basic 2005."Devise a program to create a multiplication square for any size the user enters, up to a maximum of 10x10. The program should output something like this for a 4x4 square.
1234
2468
36912
481216
You will need to make use of the RichTextBox, along with concatenation to make the output format correctly within the box.When you have created the working program, document it properly by printing out and annotating the code to explain how it works."
so my program takes what the user enters into a textbox and searches through the data i have stored and if it matchs one of the peices of data it displays the apropriate data to the user. This all worked fine till i changed the textboxes to be added dynamicly to the form when it is load and i put all textboxes in a collection. So now when the text is sent to the search sub it sends the data over but always returns that it didnt find a match. But if i go into the search sub and just tell it what to search for automaticly it finds it no problem.
View 3 Repliesi was wondering how i can make a simple program that when for eg a user enters 4 it gives this figure **** and so i want that if the user enters 5 it gives ***** etc.
View 9 RepliesJust a pretty question that seem to me a bit difficult to do it. Well, I have a form called customers. Login form and mainform. So my clients want to have an option that explains this: If a user enters information in the customer form, then that information has to be confirmed by admins panel.
[Code]...
I am trying to write the code for a conference:
1 person costs $695.00
2-4 people costs $545
5-8 people costs $480
8 or more costs $395
If the company has been before they get a 15% discount and no company can have more than 16 people. The program asks that the user enters valid data.?? (error msg boxes)
Ok so i made a program where the user enters 3 inputs in a 3 textboxes (First Name, Last Name, Bday) and when the person presses enter a check list is made under the checklistbox with the Lastname. So can any1 tell me if i click on that checklist then everything i entered shows up in a label.
View 11 RepliesI'm playing with XML, DataGridView control, DataSet and DataTable. [code] the user can edit/add records via DataGridView control. So, when the user enters a string value where it is expected to give an integer value(first column and third column), it would give a big error message. Instead of showing that, I would like to apply custom validations.
View 3 RepliesUsing VB2008, Access
I have 2 fields defined as date/time (short date).
I need to store dates fields which may at times be blank (null), how do I go about that?
I tried using:date.minvalue and that stores the value of 12/30/1899. I would like the field to be blank until the user enters a valid date.
I'm using a bindingnavigator. My datasource has the column "key1" marked as unique = true. The user presses the "+" button on the screen. A blank form is presented as expected to allow entry for the new record. The user enters "A" in the "key1" field, "A" already exists in the dataset as all records have been returned by the fill command of the tableadapter, the user then, without attempting to click the save button, clicks in the "PositionItem" textbox in the bindingnavigator. They then enter a number (say "1" for instance to go to the first record in the bindingsource), when they press enter an unhandled exception of type ContraintException is thrown. The exception is expected since the Constraint is not met. But how can I handle this exception, or how to I reimplement the code to do the work of the "PositionItem"? I know how to override the "movenextitem", "movepreviousitem", etc.
View 2 RepliesI've got a VB.net web app, and its start page is http:\<myServer> myApp>webformslogin.aspx
I'd rather they didn't have to enter this whole address. Is there a simple way to redirect my users to this page if they just enter the root i.e. http:\<myServer><myApp> ?