I have tried to use a masked edit box for this but the highlight does not seem to work. Is there a better way for entering dates. I want the user to enter the date without entering the / symbol and enter it as dd/mm/yy then format it to dd/mm/yyyy. I also want it to be highlighted when they give the control focus.
View 5 Replieshere is insert record coding
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|hvaccine.mdb")
cn.Open()
Dim str As String
[code]....
Is it just me or is it so that a DateTimePicker can only be used for entering dates or times but not both?
View 9 RepliesI have two DatetimePickers on form1.
DatetimePicker2 is not enable.I want to auto change date of DatetimePicker2 on selecting a day in DateTimePicker1 by 3 days.
Example if i select MAY ,1,2011. in DateTimePicker1 then DateTimePicker2 must show Date as MAY,4,2011.
Entering a date with an Input Box and validating it to ensure it has been entered in form dd/mm/yy. I have a VB Macro in Excel and I want the user to enter a date in an Input Box in the format dd/mm/yy. The entry needs to be validated to ensure it is valid and if possible in dd/mm/yy format which if not would request another date is entered.
View 2 Replieshave 4 worksheets, need to enabel user to open any 1 by entering date which is name of worksheet?
View 1 RepliesI am building an application that needs to store different time of day values in dateTime fields of an Access database.I am trying to enter the time value's via a DataGridView using TextBoxColomn s.The coloms are formatted with the defaultCellStyle property to show only the time part of the datetime.After i save the entered data and look in the database itself, i see not only the time, but also the (current) date in the datetimefields. This raises a problem when i want to compare the timevalues later on in the functionality of the program i am building.(Of course it is simple to seperate the date and time part in coding of the program, but it would be more elegant (i think) if i could just save only the time part in the database (and have the date part of de datetimes left to 0))I have tryed via the CellFormatting and the CellParsing events, but no luck.I am new to visual basic and probebly missing out on something.
View 2 RepliesEntering Date in Access database form vb.net's masked textbox , just need insert qurey
like ; "insert into table1 values(" & age.text & ",'" & name.text & "',#maskedtextbox1.text# or ????"
I did a code to insert a data into a mdb database but I want the data to be saved in the database in an encrypted manner.
View 7 RepliesI would like the user to enter positive numbers (decimal or whole numbers but no fraction) using combobox. However the user can only enter the numbers using a number key pad built in the combobox. The number key pad will appear once the user click the down arrow of the combobox (I am not sure if there any predefined feature built into vb.net 2005 that has this property). The number key pad should contain the numbers 0-9 and decimal(.).
View 2 RepliesI have created an application which asks the user to enter password to login.Now how can i inform the user(if his caps button is on) that his caps button is on while he is entering his password?
View 3 RepliesI have an Sql server 2005 table called Emploeefl with 2 fields, EmployeeCode and Date of Birth. The data type for the date of birth is Datetime. I have a Date time picker on a vb.net 2005 form called dtDateOfbirth. When I click on the save button I get the error message "Conversion from string 'yyyy/MM/dd' is not valid. Below is the code
Dim newQE_Date As Date
newQE_Date = Format(Me.dtDateOfBirth.ToString, "yyyy/MM/dd")
'newQE_Date = String.Format("2008/09/10", "yyyy/MM/dd")
[Code]....
there, im doing a leave management system with vb 2005..and here's my problem -how do i 'find' the expiry date?? eg: from the datetimepicker in my form, if the date i select is 1st january 2009.....how do i type the code to find the expiry date 1 year later (which is 1st january 2010) and display the date in a textbox in my form???
View 1 RepliesI have a date in the future e.g. 13/10/2008 I need to subtract the current date (today is the 28/09/2010) minus 7 days, so thats 21/09/2010 minus 13/10/2008, which would equal erm, 720 something ? But the current date won't always be 28/09/2010, obviously. I need the code for this. EDIT: When i said future I mean past :)
View 3 Repliesi am trying to insert date in dd/mm/yy format in sql table from a textbox but everytime the default date 01/01/00 goes in table.
View 19 RepliesI am working on a project inwhich I want same date format in all project forms. I want to use a form for setting/resetting date format for whole project. whenever I will change date format in this settings form, there should be this new date format available in all forms. how can I implement this?
View 8 RepliesI working on a project that includes to call a certain type of method to each control, i have this
Private Sub txtBcNum1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtBcNum1.KeyPress
[Code]...
This code works like a charm if i want to allow only numbers and backspace on my textbox.Problem: I have 15 textboxes( txtBcNum1,txtBcNum2,....,txtBcNum15 ), what's the best way to call this function inside KeyPress method on each textboxes with out manually adding it to KeyPress method?
I am retrieving some data from the db and using an sqldatareader to read the data. I have a date column in the table which i am retrieving in the following mannervb Dim d as DateIf Not reader.IsDBNull(10) Then d = reader.GetDateTime(10) Else d = ???
View 5 Repliesi want to format a datetime column like4-mar-10 9:15 pm
View 1 RepliesI Want To Insert Date Into Sql 2005 But Without Using Datetimepicker In Vb Net 2005 forms every time i do it by using textbox got an erro converting iwant to use textbox like we use it in access with input mask is that avilable
View 1 RepliesHow to validate the Date format "MM-yyyy" irrespective of the culture datetimeformat
View 2 RepliesI have a Login.aspx page where if the user has the 'Remember Me' checked then it stores their username in a cookie for a year so whenever they hit the login page (session timed out, or they clicked logout at some point) the username is pre-filled. The pre-filling is working fine, in fact it works every time. The flip side is if they login and the 'Remember Me' isn't checked, then that cookie (whether it exists or not) needs to go away. The going away part never happens, even though I'm expiring the cookie. here's the cookie name, at the top of the form:
[Code]....
I have the following function that checks if a date is on a holiday or weekend and returns the first non-holiday or weekend date.
vb.net
Private Function CheckDate(ByVal D As Date) As Date
TempDate = D
[code]....
The function does return a date. But when I try to assign it to variable, it assigns a time instead. Both tempdate and newdate are declared as date also.
vb.net
TempDate = CheckDate(NewDate).Date
I have one hour format datetimepicker and other short format datetimepicker. When I select an hour from 1:00 AM to 5:00 AM want to change the current day to the day before. I tryed to - 1 day but doesn't work or maybe isn't the correct way to do it.my error says operator '-' is not defined for types 'Date' and integer
here's my
Dim hora As Date
Dim fecha As Date
hora = Me.dtpHora.Value
fecha = CStr(Me.dtpFecha.Value)
[code]....
I am developing one web application using VB.net. This applicaton this site is actually meant to fetch the details of the active directory users. When i enter the user id in the text box and press enter it should give the complete properties of the user account. This includes : Account Creation date, modification date, password last set, user cannot change password, user account expiry,user must change password at next logon etc. I have done almost all the things. but still i am not able to read the following properties : Account Expiration date, User cannot change password,user must change password at next logon.
View 1 RepliesI am encountering an error in the following statement:For i As Integer = 0 To dtAccess.Rows.Count - 1 If dtAccess.Rows(i).Item("YMD") = dateval then dtAccess is a datatable where the column YMD is of type string.dateval is a variable of type date. Now here is the anomaly. The first ten rows works fine during the loop execution. However when the 11th row is encounter I get the following error:"Conversion from type string to date is not valid." My question is that if it is not valid then why it worked for the first ten rows? My second question is what can I do to overcome the error?
View 2 Repliesi have the following setup What i am trying to do is, when the user clicks on the 'calculate age ' button it must calculate the age and display the result based upon the selection in the combobox i.e if 'Days' are selected then it must display in days, if weeks are selected then it must display in weeks..etc
Similarly when the user clicks on the 'convert to date' button , it must subtract the given days(or weeks or months or years) from Todays date and set it to the maskedbox
I have trouble with my vb application.I create query in dataset like this :Select * from Trans where year(dateTrans)=2009 and month(dateTrans)=5But is not work and error message : year and month function not identified, what is the problem ? what a sql date function ?If i create databound from dataset and drag n drop date field in form with datetimepicker control, if i had update dataset, date field is empty.Whats wrong with datetimepicket databound.
View 5 RepliesI am trying to format a date to ShortDate and having some problems doing it. The date is not changing, regardless of the format option I use. [code]
View 2 RepliesIs there anyway of reading the date a computers name was changed? I can get the OS installation date which is the same date that the computer name was first set.
View 1 Replies