Search results

sorry for double post - server slow.

Hi all, Could somebody confirm whether or not Excel 97 supports the .EnableSelection property on a locked range, and allows the cells below it to remain unlocked? I have a protected worksheet with a macro which allows the user to click on the locked row and paste the row information into a new...

Hi all, Could somebody confirm whether or not Excel 97 supports the .EnableSelection property on a locked range, and allows the cells below it to remain unlocked? I have a protected worksheet with a macro which allows the user to click on the locked row and paste the row information into a new...

If you move the file to the same folder as the access DB and use the Application.Path method (can't remember what it is in Access right now, it would be App.Apth in VB and ThisWorkbook.Path in Excel) does it work then?

You may need to set the SQL Security Check registry key if you are working in XP, since that resists automation from Access to Word or Excel: http://support.microsoft.com/kb/825765/en-us Presumably if you execute menu option to "analyse with Microsoft Excel" on the same query, it runs ok?

Format(ActiveCell.Value,"dd/mm/yyyy") will also do the trick. But be careful with dates in Excel. It does a bit of sneaky formatting all by itself, as I found out when I saw a date of birth somewhere in 2020. The above approach has the advantage of keeping the date in strings.

I would design a query with an expression field concatenating both name and surname - and maybe writing a little function that will do that for you. e.g. SELECT CombineTwoFields(Table.Firstname,Table.Surname) AS FullConcatName Use that query to drive the report and then you can change the...

You already have a variable strPartNo which holds this value. Use CDbl(strPartNo) instead of the [fldPartNumber] which it won't recognise as a value.