Using 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 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)
Is there any way to use a DTP and have nothing but the slashes show until the user enters a date?
View 7 RepliesI'm using the ErrorProvider in VB.Net (2005) which is associated with a BindingSource that is bound to a custom object that I have created. This custom object contains a date field that has a "Date" data type that. I am using a "TextBox" to bind the date field in my form. My issue is, whenever the TextBox loses focus and is blank, "String not recognized as a valid DateTime" is displayed by the ErrorProvider and the focus can't be changed to any other control on the Form. It's good that the ErrorProvider validates entries on Date fields by default (I didn't set up my custom object to display this particular error for the date), but it should allow blank values. I want the user to be able to have a blank date with no error message displayed. How can this be done using a Date field bound to a TextBox?
View 2 RepliesI have a field called PODate & TextBox txtPODate.text. It saves/updates fine when the txtPODate is filled. But when the txtPODate is blank, it throws an error. The problem is that I can't enter date for each record unless I got Purchase requisition converted into Purchase Order. Once it is converted to PO, I need to enter the date to update that filed. So, how can I make my program to accept blank date field.
View 6 RepliesI have a date field bound to a textbox. If I make any changes to the textbox, I get "stuck" in the field unless I put a valid date value. All I want to do is set the date textbox to blank and move on to the next field, but I can't. I am eternally "stuck" in the field unless I put a valid date value.
[url]..
I did several hours of research, but looks like there is really no solution to this problem... Is this true?
How can I get this to happen? I googled around and it seems setting the CUSTOM FORMAT to " " when the field is null will work but not for a BOUND datetimepicker.
View 12 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 RepliesI 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 need this for displaying in my crystal report here's my code:
Code: cmd.CommandText = "Select * from pos where date= '" & datetimepicker1.text"'" and nothing displays on my crystal report, I need the right query for that...the field value is DATE...I need the conversion for the 1/11/2001 format from date time picker to 2001-1-11 in DATE field
I have a matrix with rows indicating a name (Ex Store name) and I have data pertaining to that in the DATA cells. I also have another date field in this format (MM/DD/YYYY). I would like to use a cross tab between Store Names and Just the Month of the date field.
[code]...
is there any expression I can use to get the month format on the header of column.
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]...
I have a few date fields on a form. no matter what i've tried in the properties, the form still loads and there is a default date in there, how do you get rid of this?
View 5 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.
I have a combo box defined as a drop down list for a numeric field and have possible values under items. One of the values I have is a blank value (at the top of the items list) in case the user needs to leave the value as null. However, when I choose the 'blank' value, it will not let me past that field. I tried changing the 'data source update mode' to 'Never' and it let me past the field but then of course it won't save ANY of the values I choose.Is there any easy way around this without having to change the field to a string? I have several like this.
View 10 RepliesI'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]...
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].....
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 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 want to add a blank value to a field in access database with vb 2008 command.
Problem 1: Here is my code, it shows conversion to string not possible errors
Private Sub btnRedThrow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRedThrow.Click
Dim dbCnct As New DBUtills
[Code]....
notice the fifth and last value is empty. But it is not being added into the database, how do I do that?
Problem 2: Why does an additional field from my access database disappear even after I manually created the field?? (access database 2003 version, extension is .mdb) I'm using visual studio 2008
Dont know what happened but on every form whichever control is related with an image in the resource is not displaying image. I mean the background image field in every control is blank...
View 1 Repliescount 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 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]...
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 Replies