Recent content by gillonia

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