I need a 2 functions:
1)the first that alert me when one month is passed ex: 25 december 2011 - 25 january 2012
2)the second that alert me when one week is passed ex: 25 december 2011 - 1 january 2012
i'm currently using VB.net 2005 with an Oracle 10g db.1. Alert the Admin by displaying on the main page a list of users who are due for re-certification if there are any. - I've managed to do this except my date calculation for the alert is wrong. When a user is certified say on 25-06-2010, they will be up for re-certification in 25-06-2011. I need my program to start alerting the Admin a MONTH before the user is due for re-certification. So basically start the alert on 25-05-2011.Currently this is my logic in VB.
Reason = Get value in Reason field (If this field is not empty, then don't raise alert for this record)
Renewal = Get the re-certification date
Sysdate = Get current system date
[code]...
Alert the Admin via email - I've managed to create an email (stored procedure in Oracle) that contains the skeleton. I say skeleton because althought the mail executes fine, I've not managed yet to include the list of users due from the db. I created a Curser and dumped my results in there, but not sure what to do after that.
I'm currently making a billing system and I would like to know how I can set a reminder/ alert date?
I have data that consists of names of the payee and the outstanding amount of the particular payee. Is there a way that I can send a reminder to myself on the outstanding amount after 5 days later once the invoice is generated.
For example, Company ABC purchased products from me on credit. Invoice is created on the day of purchase and reminder would prompt to remind me about the outstanding payment of Company ABC after 5 days.
I want to pass a List of T where T is an object I've created that has about ten properties (strings, dates and integers).The lst passes to the function successfully. I am also passing an New T of the Object (itm as T).I can see all the values (see image below), but because it's generic I cannot seem to retrieve the property values and I cannot figure out how to iterate through the properties of each itm as they are retrieved in the For Each.[code]
View 10 RepliesA month consistof weeks and i want to find out which week of the current month.
View 2 RepliesI just want to clarify my select statement if correct to get records from my table. Please see below
List for products 3 months before Expire genReportExpires("SELECT * FROM t_products WHERE f_expire < #" & Date.Now & "# - Interval 3 month ")List of products 2 months before ExpiregenReportExpires("SELECT * FROM t_products WHERE f_expire < #" & Date.Now & "# - Interval 2 month ")List of products 1 month before Expire
genReportExpires("SELECT * FROM t_products WHERE f_expire < #" & Date.Now & "# - Interval 1 month ")
List of products 1 week before Expire genReportExpires("SELECT * FROM t_products WHERE f_expire < #" & Date.Now & "# - Interval 1 week ")
How can we calculate week number in one month.I am bit confused about caliculating this week number in one month.for example if we take today date 8/12/2006.Now we are in which week ? 2nd or first week (in december month)Our zone is united kingdom..
View 11 RepliesHow can i find the week number in a month.
A month can have 5 weeks, i need to know in which week i am.
I am trying to determine how to take a date and show what the week number is for that month. So 3/1/10 will be week 1, 3/16/10 will be week 3 and 3/30/10 will be week 5. I know how to get the week of the year number just not week of the month.
View 4 Repliesi am looking for some tip to format a datetime stamp to format Saturday, December 31, 2011. I am able to get day of week, month, year in numbers but not in string. I can create arrays for days,month but i don't want to use lots of memory, if theres a function i can use it.
View 3 RepliesHow to get difference between two dates in Year/Month/Week/Day?
I have a problem with the difference between two dates. I need the out put in 0 YEAR, 0 MONTHS, 0 DAYS LEFTm e.g.:
1 YEAR, 2 MONTHS, 3 DAYS LEFT
With dateDiff function or using anything else it is not pos
How can I have options (checkboxes) in my application to automatically update every startup, every week, every 2 weeks, every month or never?
Just showing a messagebox every time period would be great for an example.
I am writing a program that has to print an alert message in a textbox if the user inputs invalid data. Invalid data would be a negative number. The textbox is the same textbox as the result would be in provided they input valid data. Here is what I have but it will not print the alert.
[code]...
I had some trouble specifying Monday as the first day of week in the DateDiff function.
The following syntax does not work: Dim myWeekNumber as Int32 = DateDiff("ww",date1,date2,2)
Compiler Error Message: BC30519: Overload resolution failed because no accessible 'DateDiff' can be called without a narrowing conversion
However, using the enumeration value (FirstDayOfWeek.Monday) instead of the value (2) does work. I wonder why.
I changed the date of datetimepicker format to yyyy-mm-dd in custom format...but it displays 2009-00-22...the month part is not showing the month of the exact month..how to change the format of the date?
View 3 RepliesI'm not having any errors from these pieces of code, they're just empty everytime. I'm wondering if I perhaps have created them incorrectly.
Dim l As New Log()
l.Log = "Attempted staff login with username [" & txtUsername.Text & "]"
l.LogId = 0
l.StaffId = 4
l.LogDate = Date.Now()
l.Insert()
.Insert() is picked up in my BLL layer by these two functions;
[Code] ......
ok basically i've got a delegate ByVal function_to_execute As dele0 but instead of invoking it, i wish to add it to an eventhandler
Public Sub test(ByVal function_to_execute As d0)
Dim t As Timer = New Timer()
AddHandler t.Tick, AddressOf function_to_execute.address
[code].....
I need to generate a report that shows the 52 weeks of a year (or 53 weeks as some years have) and their start and end dates. There is an ISO spec to do this but seems awfully complicated! Im hoping someone knows of a way to do it in C# or Visual Basic (its actually for Visual Basic 6 but I will try port it across)
View 7 RepliesIs there a Limit to the parameters that can be passed byVal or byRef to a function or procedure in vb .net ?
[URL]
My issue is regarding overloaded functions of the already provided IIf function that would handle specific types. As you all know the IIf function provided returns objects, rather a specific type so for my needs I created a few overloaded function to do just that but with a specific type in mind. So having said I have IIf functions for types of booleans, strings, bytes, integers, etc etc.
Now my problem is when I'm trying to pass a byte value to this function that would return one of the two byte values. When I do this the designer keeps confusing my values as an integer value and calls for me to convert it to a byte. If I did this then it would defeat my entire purpose for creating these functions-which is to avoid any conversions. The only way I can solve this is by converting the whole statement itself or the true/false parameter parts individual to specify to the designer that these values are bytes. I'm just hoping there's a way of identifying the difference between bytes and integers..
I'm trying to convert an old ASP.Net 1.0 application to ASP.Net 3.5 and am running into trouble with a JavaScript function. The application passes in content into an within a table cell. The function is supposed to calculate the height of the content and size the table cell appropriately.
way of accomplishing this with the
JavaScript function
<script language="javascript" type="text/javascript">
<!--
function calcHeight() {
[Code].....
Is there a way to write a single function that will control validating the input to any textbox? How to pass control of it.
E.g.: My second try was to:
Dim CurrentTextBox As TextBox << Declare a global
Write a function that uses the global textbox and takes in 2 parameters, one determining the length it has to validate and the second telling it what to do once the input is verified
Public Sub ConfirmInput(length As Integer, which As Integer)
If (CurrentTextBox.TextLength < length) Then
CurrentTextBox.BackColor = vbRed
GoTo DONE
ElseIf (CurrentTextBox.TextLength > length) Then
CurrentTextBox.BackColor = vbRed
[Code] .....
My first try was to pass a textBox parameter to the ConfirmInput function but I believe that's the same problem as above.
I am in vb.net and have a function that will be accessed by multiple threads. Everything inside the function uses local variables. However, each thread will pass in its own dataset by reference. From what I have read the local variables should be no problem, but I think the dataset coming in is a concern. How should I control access / execution of this function to make sure that it is thread safe?
View 1 RepliesI wrote a Log class that details the exception, including the method name and its arguments list,but I couldn't find any way to programmaticly retrieve the arguments values.in some forums it was said that its impossible mission. I find it very odd.my arguments list looks like:
argA As String = ?
argB As integer (Opional, Default value = 2) = ?
etc. only actual values are missing.
In regular SQL i could do something like
SELECT * From T GROUP BY DATEPART(wk, T.Date)
How can i do that in Linq to SQL ?
The following don't work
From F In DB.T Group R By DatePart(DateInterval.WeekOfYear, F.Date)
Also don't work:
From F In DB.T Group R By (F.Date.DayOfYear / 7)
I have five text boxes & one button there in my form. I have written this code to get user`s current age. But problem is that I have to get user`s age with months.
My code to get age :
Private Sub Command1_Click()
BDate = Text1.Text & "-" & Text2.Text & "-" & Text3.Text
CurDate = Now
[Code].....
I'm not at all familiar with VB but do occasionally use C#. Really, i'm a BI guy who uses T-SQL on a daily basis in SSRS, which is why I have a question.I have a scenario where i've built a series of charts in SSRS 2008. Unfortunately, the functions available to me in SSRS are not enough for what I need my charts to do so I have decided to build my own function in embedded code. In SSRS, only VB.NET can be used when writing embedded functions.
I have opened Visual Studio 2008 Pro, created a solution and started building my function in Visual Basic 2008. So far, all is going well - i'm accepting a parameter which contains a string "date" of JAN-10, doing a substring operation on it to parse out the month and year, concatenating "20" to the two-digit year portion to get the full year. This part all works just fine.
For the three-letter month portion, i'm trying to use the MONTH() function to return it as an integer but unfortunatley it does not seem to be availble to me in Intellisense, which of course probably means i'm not accessing the class correctly. The odd thing is that the MonthName() function is available, but of course I can't use this with string values like "JAN" or "FEB" because it only accepts an integer. I'm familiar with the fact that in C# I can add a USING statement to the top of my class file to access a namespace, but i'm not sure how it works in Visual Basic 2008 because i'm honestly never used it before.
So my question - and this is probably a very basic question here - how do I access the Month() function? Which class or namespace (or both) do I have to reference in order to use it?Below is a screenshot of what I have so far, you can see from the Intellisense menu that the Month() function is not available:
[Code]...
[URL] That way if the string that is not recognised that is passed to Color.FromName it returns a SolidColor of
Color.Black = Color.FromARGB(255,0,0,0)
That way, Forms and controls that only support SolidColors are supported.Installing VB6 on Windows 7?
Currently i have a ReturnSystemDate in a module, so that whenever i need the current date and time i call this method, however my data is saving as in 1 format and displaying in another. I have my variables set up as dateTime to store the current date and time, when calling System.dateTime.now.toString() i get 11/08/2010 Time, however when casting to Date as in CDATE() i get 08/11/2010 time. How can i stop this?
View 13 RepliesI want my game to tick over month by month at a set interval. I would use the timer control to get the interval. But how can I pause it? Say if one "month" is 5 minutes in my game and user hits pause. I would disable the timer but then when they unpause the game the timer would start from 0 again. This would make a "month" 9 minutes if a user paused the game in the 4th minute.
[Code]...