Search results for query: *

The statement doesn't generate any errors but it doesn't delete any files at all.

I get the following two errors on this statement: If File.GetLastWriteTime(Archive_Files(x)) < First_Date And x.Chars(0).IsDigit(x.Substring(0)) = True Then Filtered.Add(Archive_Files(x)) End If Chars is not a memeber of integer Substring is not a memeber of integer

I have the following module that I delete old files based on how old they are: Sub Main() Dim First_Date As String = Date.Today.AddDays(-7) Dim Archive_Files() As String = System.IO.Directory.GetFiles("C:\Turnover") Dim Filtered As New ArrayList For x As Integer...

Are datasets and data tables controls that I put on the form or are you talking about using tables in Access with VB .Net? Could you write some code to get me in the right direction??

I'm not familiar with using Dataset tables. Could you add elements with this method also??

I want to be able to delete and search for elements in a XML file, I'm using the code below for adding elements which works great: Public Sub cmdAddElement_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAddElement.Click Dim doc As New XmlDocument...

Thanks again I used the evaluate based on formula routine and it work great.

Thanks a lot lbass, the formula works great, I was trying to create sub totals for each of the four groups(First, Second, Third and Weekend) to be placed at the end of the report. The current formula does total the amount for each group per day - I'd like to have the total for each group for...

Sorry, about all the trouble I had a selection formula in my crystal report to exclude first shift. It works great now. Thanks a lot for all your help.

here's the formula: if (dayofweek({Sheet1_.Open}) = 7 and time({Sheet1_.Open}) >= time(8,0,0)) or dayofweek({Sheet1_.Open}) = 1 or (dayofweek({Sheet1_.Open}) = 2 and time({Sheet1_.Open}) < time(7,0,0)) then "Weekend" else if dayofweek({Sheet1_.Open}) in 3 to 7 then (if time({Sheet1_.Open}) in...

I had a typo, I 'm getting the count but it's not displaying the First shift records.

It's not picking up First Shift for some reason

I'm using the following formula that I was given to an earlier question I had: if time({table.opendatetime}) in time(0,0,0) to time(7,59,59) then "Third Shift" else if time({table.opendatetime}) in time(8,0,0) to time(15,59,59) then "First Shift" else if time({table.opendatetime}) in...

It works great except it doesn't display "Second Shift

Being sort of new to using Crystal Reports in VB .Net...I need help on how to setup and use formulas in CR with VB .Net. I have a sample of a CR I setup in VB .Net. The field name is 'Open' in my test.rpt. It's basically a date and time in the 24 hour(military format). The formula I need is to...

Let's say I have the following folder: C:\Archive\Data\Logs\ and within this folder are many files in this format: Cycle Run of Tuesday, February 01, 2005.html Cycle Run of Wednesday, February 02, 2005.html . . . Cycle Run of Monday, February 28, 2005.html The folder gets larger every day...

How would I check to see if the current time(military format) is greater then 07:30AM and the day of the week is Monday-Friday. Pseudo code: If Current_Time > 07:30AM and Current_Day = Monday or Current_Day = Tuesday _ or Current_Day = Wednesday or Current_Day = Thursday or Current_Day =...

Here is my XML file: <?xml version="1.0" standalone="yes"?> <MSR> <Info> <TODAY>Saturday, January 29, 2005</TODAY> <SSEC>4:00 pm</SSEC> </Info> </MSR> My XSL file: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"...

What I'd like to do is to check the values in an element if they're greater than a certain time and if they are, then change the font color of the time. I have about 10 elements that I will check against a different time for each element, I'm just showing one element below in my XML file. The...

Basically, I'd like to know how to delete all my emails in an Outlook folder called: "Previous Month's" and then move, not copy all the emails from "Current Month's" to the "Previous Month's" folder.