Recent content by noboffinme

I found the answer, the way to do it is to select 'Delete' instead of 'Format' as the new OS software runs. It then creates a new C drive & wipes the old one clean.

Thanks Galaxiom, I've tried that, left it today to delete & was still going 8 hours later. Also other folders were also left behind. The reboot from the DVD works OK, I just need to know why I can't format the C drive in DOS. Thanks

Hi, I'm rebuilding my laptop which is a Toshiba portege M800 with Windows 7. I have the OS disc but when I boot from the DVD drive all goes well until I get the message that it will keep all my data in a folder called 'Windows old'. I want to completely remove all files on the C drive but...

Just a follow up note as I have found the cause of this 'anomaly'. I created this file for a colleague & after sitting with him watching how he used it, I found he was inserting & deleting Rows in the file & this was the cause of the Conditional Formatting Range changes... Mystery is solved !!

Hi LexpectoPatronum, Here's a VBA script that is run from Access to a nominated Excel Workbook/Worksheet. In VBA, an apostrophe (') is used to add comments to the code to help a reader understand what the code is doing. Use these comments to follow what the code is doing & help you...

Hi wotme, The 'Input Mask' is what I think you're referring to, this forces the format to comply to a certain pattern. If that's correct, I don't think you'll be able to apply one format that suits 2 different formats. If the info is being entered into a Form, why can't you choose one...

Thanks lemo / Brian, I have enhanced this report for a Colleague & he is the one having the problems. The version I have is fine. I can't pinpoint anything he is doing that would cause this ??? Microsoft Customer Service advise they're not aware of the issue. One other question, what...

Thanks lemo, That's a good idea,I'll give it a try. Any idea why it happens?? I can't find any pattern as to why they change... Any Microsoft people out there that know why this happens?? Thanks

Sorry, I should add that I originally applied an 'Applies to' range of $A6:$R500 for this CF to make the changes but it changes, by itself to all sorts of cell ranges as well making the 'Applies to' range work inconsistently. So the original $A6:$R500 changes to something like $A26:$A501...

Hi, I'm working on an Excel 2007 file that has a Column of Data Validation Drop Down lists in Column 'A'. Depending on the value selected from the Drop Down, I have added Conditional Formatting (CF) rules to shade the row (Up to Column 'R') a certain colour. I've set this up for about 20...

Hi ccl, It may help if I explain why you need to do these things to get Excel to work from Access. Access doesn't normally understand 'Excel' type commands. In order to help, you need to let Access 'access' the Excel Reference Library by going to Tools >> References as pr2-eugin advised &...

Hi ccl, As Alansidman has advised, create the button on your Access Form & add this code after you change the Path where you want the file to save to & the query name. Option Explicit Private Sub cmd_qry_export_Click() Dim XLApp As Excel.Application Dim XLwkbk As Excel.Workbook Dim a As...

Hi John64, I was working on this with a learned colleague but I haven't got any more answers from him as yet. I'll let you know if/when I get an answer.

Sorry Darrell, I've run this in 2007, 2010 & 2013 & I can't replicate the error.

Hi leighms, Here's some code I use to export from Access to Excel & saves the files to the 'C' Drive. Depending on the version of Excel, you may want to change the extension to .xlsx for the 'DoCmd.OutputTo ... ' part. You may want to add a Loop that select the various report names from a...