Search results for query: *

Thanks raja2008, I'll give this a try.

Thanks very much for the reply Raj, one issue I foresee with that is if the pattern repeated itself later in the day, ie in the example below, if I take the max & min of www.bbc.co.uk it'll give me 12:40-15:49, when I should really be looking at 12:40-12:49 & 15:40-15:49.... <Row 1>...

CR10 From a table containing the following two fields: "URL", "DateTime" I'm looking to calculate the total time spent on internet sites, data is in the following format: <Row 1> www.bbc.co.uk 01/08/2008 12:40 <Row 2 >www.bbc.co.uk 01/08/2008 12:42 <Row 3 >www.bbc.co.uk 01/08/2008 12:43 <Row...

Perfect, I thought there had to be a simple solution Thanks very much for your help lbass, very much appreciated!

CR10 Can anyone help me to write a forumla on a text field that will pick out the main site from a URL: IE www.newss.bbc.co.uk from http://news.bbc.co.uk/sport1/hi/football/default.stm AND edinburghnews.scotsman.com from...

Quick question, Is it possible to deny print access to files under a certain folder? Thanks for any suggestions.

Outlook 2003 I'm looking to see if there's a way for recurring appointments in Calendar under the 'By Category' view to show as separate individual appointments (ie one appointment every Monday morning as opposed to only one appointment showing) Thanks for any advice!

Thanks to all for your help, GJParker pointed me in the right direction. The field is displaying correctly but short as it was right-aligned and the text box was too wee, doh. Thanks again to everyone.

Thanks for all your suggestions - Formula I'm using is called EndDate and all it contains is the 'CurrentDate' function, not doing anything fancy with it until I get it displaying the correct date. I've put the Special fields onto my report to see what they display: Data Date - Sep 05 Date...

Yeah, sorry should have made that clearer when I said the PC time is correct I meant under Control Panel -> Date and Time, the date is correct.

Yeah, still getting the same issue though :-(

The Pc time is correct The value under Report->Set Print Date and Time is set to 'Todays Date and Time' but still my date value is incorrect.... (05/Sep when it should be 09/Sep) Any suggestions much appreciated

Thnx again for your reply 1. No hidden columns unfortunately 2. No formatting being done. Just a simple export. This issue is happening with all my other Macros that export data with dates so I'm thinking it must be a application-wide setting somewhere.

Sorry, I should have explained more fully. I have two actions within my macro, the first one creates a table based on a link to the spreadsheet. The second one exports from that link to a text file. First Action is called 'TransferSpreadsheet'- Transfer Type: Link Spreadsheet Type:Miscrosoft...

MS Access 2003 SP1 Ok, apologies for what might be a really simple problem. I'm taking data from a spreadsheet, and exporting it out to txt files using Access Macros. Instead of getting the date in the correct format I require I'm getting it as follows (ie with three digit number in front for...

Hi ShortyA, thnx again for your suggestions. All I'm doing with the sub-reports is passing values to them in order to chart on them (As per the Charting on Print-Time Formulas technical paper -cr9_charting_print_time_formulas.pdf). If I suppress the sub-report it works fine so it definitely...

Yeah, I had checked this out already and they're all running under the same account. These reports all use sub-reports. Thnx, IanG

Thnx for the reply ShortyA. No, this isn't all my reports, just a couple. I have a few reports that use the same datasource which don't have this issue and work fine. The only difference I can see are ones that don't work are more complex. Any thoughts? Cheers again, IanG

CE V9.0.0.287 Database: Oracle Viewer: DHTML What is the difference between the 'Preview' and 'History' options within Crystal Enterprise. A couple of my reports I can view ok when using the Preview option but when I try to look at them through the History Option I get the following message...

I get the message: "Unable to retrieve Object. ClassFactory cannot supply requested class " when I schedule a report. I can view this ok through Crystal reports but when I schedule it, it seems to run successfully but when I go to view it I get this error. Any thoughts/suggestions? Thnx for...