Recent content by rkckjk

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...