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
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.
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?
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.
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?
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?
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?
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)
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
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?
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
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 ..
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.
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.
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.
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.
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
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)
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
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.
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?
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?
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.
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
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.
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 =