Activating/disabling Controls Based On Date?
Mar 19, 2009
I have most of this working, but there are some issues yet. Basically, it's a "History" form for patients There's a date field for each entry, and if that date doesn't match the date you're accessing the form I want it to disable all controls so you can't edit the form.So it would have to check the current date with the date that is on the form.The issues I'm having are this. It seems to work because when I click today's date nothing gets locked like it used to, but when I do click another date everything in that form gets locked, including the override button and the scrollbar. I don't want the scrollbar locked, and I want to have an override button so the user can edit the form if they truly wish. It also locks the DateTimePicker so I can't pick another date, I don't want that locked either.I tried enabling the DTP in the sub below but it must get ignored
[Code]...
View 6 Replies
ADVERTISEMENT
Mar 19, 2009
I have this form with a bunch of input controls. I have code working that will disable them all like I want, but need to work with the if/then statement portion. Basically, it's a "History" form for patients. There's a date field for each entry, and if that date doesn't match the date you're accessing the form I want it to disable all controls so you can't edit the form. So it would have to check the current date with the date that is on the form. Then I also want to have an override button that will ask you if you want to enable all controls anyway, which I can probably figure out. There is some older VB6 code (I think) but I know nothing about VB6 or how it translates.
I think this is the portion that does what I want in VB6:
Private Sub DATE_DblClick(Cancel As Integer)
Call Setdate
Exit Sub
Dim sysDate As Date, Response
sysDate = VBA.Date
[Code] .....
How to have the program check the current date with the date in this form. From there it's probably just a simple if/then statement to fire off either sub. This date control on the form is a DateTimePicker. Maybe I just have to compare that to the system date but I still don't know what to call for that.
View 20 Replies
Jun 21, 2010
im trying to disable a button until anything has been entered into two text boxes simultaneously.
So far i have tried:
If String.IsNullOrEmpty(TextBox1.Text & TextBox2.Text) Then
Button1.Enabled = False
Else
Button1.Enabled = True
End If
However it doesnt work simultaneously, the button will become enabled if i enter anything into either textbox, i cant have any of them left blank.
View 2 Replies
Aug 16, 2009
I was looking for quick assistance with disabling the write button based on wrong user input. Program works great just feel like it needs a little more.
[Code]...
I don't like validating through the TextChanged event either as I believe that to be the cause of some issues. Doesn't the Textchanged event validate on each time a letter is typed?
View 2 Replies
Apr 28, 2009
i have this function to enable disable the controls on a form....
Private Sub EnableDisableAll(ByVal xType As Boolean)
Dim ctl As Control
For Each ctl In Me.Controls
If TypeOf ctl Is TextBox Then
ctl.Enabled = xType
[Code]...
everything fine ...but when the controls r disabled it shows in the dull color. can i change the color ? as u can see i have given the command to change the forcolor to red to textbox but it still shows in dull greay... i dont want it to be enabled as i am using this to just give a view of records....the back color is changing to white but not the forecolor.....is there any thing more to be done...or any better way so as the items remain enabled but i dont allow the changes to be done.
View 11 Replies
Jul 10, 2011
I'm trying to enable/disable controls inside a repeater:
<asp:Repeater ID="Repeater1" OnItemCommand="RepeaterItemCommand" runat="server">
<HeaderTemplate>
<table>
<th>
[code]....
View 2 Replies
Feb 10, 2011
I'm working on a winform which contains several controls like textboxes, radio buttons, datagridviews... All of these controls have been added to a main group box called gbDataEntry. My problem is when the user is seeing the form, I set gbDataEntry.Enabled = False but I want to enable some controls like DataGridviews so the user can scroll them. After disabling gbDataGridview I set DataGridView1.Enabled = True but it seems that the datagridview does not respond to this line. Why?
View 1 Replies
Jun 12, 2009
Is it possible to disable the dates that appear before todays date in a dateTimePicker control?I want to put in some validation so that my users can only select days in the future...ie a future appointment date?
View 5 Replies
Dec 30, 2011
A recent project of mine has been to make a designer. I've finished everything, but when I click the controls to show the properties window, the control interacts with the cursor. So my question is: How do I freeze the controls from interacting with clicking or key presses without disabling the control itself?
View 11 Replies
Jul 14, 2009
Would it be possible to search a table, confining to a specific date range based on a date-time column, and get a count of the 10 most used words in a particular var-char column excluding a list of words?All in SQL?Currently I am pulling out the records that match and sorting through the contents outside of SQL, I would think where I can do it directly on the server it would be more efficient.(SQL 2008)
View 4 Replies
Sep 15, 2009
I am using VB.NET. Is there a date function that calculates the date based on the number of months I have given?
for example, if i say July 2009 and looking for 10 months back, it should return Sept 2008.
View 4 Replies
Dec 13, 2009
i want to set the system date of my a client pc based on the system date where the sql server reside.In short i want to sysncronize the date between the client and server.I have a working code in vb6 but i dont know how to do it in vb 2008.
dim RstDate As ADODB.Recordset
Set RstDate = New ADODB.Recordset
RstDate.Open "SELECT GETDATE() as ServerDate ", CnAP
[code]....
View 5 Replies
Sep 16, 2010
I had this question before "Resize image on the fly make the image lose quality online but locally works nice".And what i got now is that it's not a problem of local or online, i ran this resize on the server itself "dedicated server", and i got the same bad quality image, so the problem is in the IIS configurations.What in iis can make this bad quality image happen?
View 1 Replies
Jan 2, 2012
I have code which has been working awesomely but for some reason wil not take dates from this year. the date starts in a date picker datepick is a variable string log is the table, dater is the coloum
datepick = format(datetimepicker1.value, "dd/MM/yyyy")
dbprovider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbsource = "Data Source = C:datadatafile.mdb"
[Code]....
now the code has worked fine (and still does) for dates pre 2012. now and dates like 02/01/2012 it hates. the dates in the database are set to custom format of "dd/mm/yyyy" and i CAN NOT figure out why this is not pulling the data ..
View 8 Replies
Nov 28, 2010
I am looking to create several custom controls (PictureBox Derivatives) on during runtime. I've read that the best way is to create template controls that will be created, and duplicate them in the Controls array.
Well, that's all fine and dandy, but what's the best way to store the template? I considered a seperate form with all the templates laid out on it for easy access for my editing, and keeping them out of the user's sight. I also considdered doing a Struct for each template, and smply mirroring values onto the control being created from the Struct to the created control.
I'm looking for ease of development first and foremost, as I'm most likely going to have a vast number of these templates, and keeping the system as simple as possible will eliminate a lot of hair-pulling. After development ease, I'd go for optimisation.
View 11 Replies
Oct 15, 2010
I have a form with some textboxes on it. The textboxes show values from a table. I have a binding navigator that lets you step through the records in the table and the textboxes update. What I want, is to have a control, say a listbox, that allows you to select a value which will filter the data behind the controls so that you only have one record.
So, for example, say you have a table of contacts. There are textboxes on your form that show name, phone, address etc. You could then have a listbox that showed a list of all the contacts and you could select one, which would in turn the textboxes. The filtering field could be contactID for example.
View 11 Replies
Sep 21, 2010
I would like to get a 'due' or predicted inspection date based on alternating with another date? How would I go about this? [Code] The due inspection either can be 24 months (second yearly) but it has to alternate with the last safety inspection.
View 1 Replies
Jun 3, 2010
Given a week number, I need to get the date of the Monday of that week.For example, I have several strings that are stored in a file, such as
"WK 28 2010"
"WK 30 2010"
They could be any any valid week number.
The Monday on Week 28 of the year is 12 July 2010
The Monday on Week 30 of the year is 26 July 2010
Its these dates that I need.
I guess I could create a lookup table, but would prefer a more smarter approach so my software will be future compatible?
View 3 Replies
Mar 23, 2010
I have an application where a payment needs to be made on the same day of each month.
So if the day of the month is the 7th. Then I need to take today's date and if it's before the 7th display the 7th of the current month. if the date is after the 7th then i need to display the 7th of the next month.
View 3 Replies
Jan 20, 2012
Ok, here is my problem. I got a wonderful dataset/database going on. In my program I have a datagrid (TicketGrid). I need it to highlight the Ticket Created DateTime if the ticket is older than 45 mins, based off system time
For i As Integer = 0 To Me.TicketGrid.Rows.Count - 1
If Me.TicketGrid.Rows(i).Cells(0).Value <= Date.Now Then
Me.TicketGrid.Rows(i).Cells(0).Style.BackColor = Color.Yellow
[code]......
View 9 Replies
Jan 15, 2012
Im trying to move all files from "C:SSISTest1" that are new than 2 days old to the C:SSISTest" but for some reason it keeps skipping over the if statement marked in red.
Sub Text()
Dim sDay As DateTime
sDay = DateAdd(DateInterval.Day, -2, Date.Now)
[Code].....
View 3 Replies
Oct 11, 2010
I would like to know how to coding in VB 2010 as this problem:The sequence numbers I want as the following:
Date 08 October 2010 --> 10-10-08
The first number is --> 10-10-08-01
The second number is --> 10-10-08-02 and so on
Date 12 October 2010 --> 10-10-12
The fourth number is --> 10-10-12-04
The ninth number is --> 10-10-12-09 and so on
How can I do it?
View 13 Replies
Feb 25, 2011
My gridview does not use controls, because it is populated using expressions
<asp:TemplateField HeaderText="As Of Sales">
<ItemTemplate>
<%#Getsales(Decimal.Parse(Eval("asofsales").ToString())).ToString("C0")%>
</ItemTemplate>
<FooterTemplate>
<%#Getsales1().ToString("C0")%>
[Code]...
View 1 Replies
Jun 12, 2012
I need to create a sample question types web form in VB.NET which allow user to the following:he user selects the control type from dropdown (TextBox, RadioButton, ListBox etc). Generate controls dynamically based on the control type on the webform.It will always show the TextBox (where user writes the question) and (generated control - TextBox, RadioButton, ListBox etc) and save those values to the database.
View 3 Replies
Jun 25, 2009
I have a group of three radio buttons. Depending on which radio button is selected, I want to disaply one of three controls - a textbox, a dropdown list, or a button. How do I display controls based on the result of a selected radio button?
View 1 Replies
May 17, 2010
I have the need to disable multiple controls based on specific circumstances.[code]Thing is, this doesn't work for ToolStrip items. Is there a way to do this without checking the type of each control passed to the function?
View 7 Replies
Jul 27, 2010
is there a way to validate controls on a form, where the validation rules themselves are stored in a database table?My problem is my application is used to submit forms to mulitple government agenices both local and state level. Every entity seems to have there own rules about what needs to be in what location. i would like to not have to code all of the various rules for all the different fields. My thought was to store them in a database table and then perform validation based on rule table lookups...however I would like to use the .NET validation controls.
View 2 Replies
Mar 30, 2011
Have a column of dates which i need to compare to a specific time of the year, which establishes what calculation needs to be applyed then depending on the outcome apply conditional formating to highlight an adjcent cell, but need to remove the YY element as the contents spans multiple years.
if the date in A1 is between 1st Jan & 14th Mar use -8
if the date in A1 is between 15th Mar & 15th Oct use -17
if the date in A1 is between 16th Oct & 31st Dec use -8
Then deduct the above value from B1 to give a target for each row (from 3 onwards)if the target is < the value in n then change background orange in f
View 1 Replies
Nov 25, 2011
I have a ticketing application and I want to create a date based, sequential, ticket number.I'm leaning toward something based on Posix time as this generates a sufficiently large number and the likelihood of any two ticket numbers overlapping is slim to none (two people would have to just happen to hit the button at exactly the same time on two perfectly synchronized systems).Has anyone done anything like this or have any code snippets/ suggestions? At the moment, I'm just using a UNIX time converter someone posted elsewhere: [code] This works fine (although it's not POSIX time), but I wanted to see if anyone else had any feedback as well.
View 11 Replies
Aug 12, 2009
I have an MS Access database that has a field called DeletedDate. I want to use a Delete statement that will delete the record(s) when DeleteDate is 30 days old or older. I have tried several different Delete statements but none seem to work properly. They will always delete some of the records, but will leave some records where either DeleteDate is older than 30 days or will delete recored where DeleteDate is not yet 30 days old. I have tried these using DeleteDate as a Text field and as a Date/Time field. Which should I use? These are the Delete Statements that I have used:
'sComm = "DELETE from Agents WHERE Deleted = 'Y' AND DeletedDate < " & System.DateTime.Now.Date.AddDays(-30) & "
sComm =
[Code]....
View 1 Replies