If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please help - Spreadsheet find function on the access form fails
Hello all!!
I am having office 2003 on my machine. I have developed one access form on which I am having OWC11 control (spreadsheet). When I fired my query to find "*", it fails. My code snippet is as follows --- set ctrl=me!("Spreadsheet0") ' it is the spreadsheet control viz. Microsoft Office Spreadsheet 11.0 set rng=ctrl.activecell.entirecolumn.find("*") ' ---- Here is the problem Here rng is always sets to "Nothing" though spreadsheet is having any data in it. Where m i wrong? because if I fire the same query in excel-vba it works fine. Please point me to right direction. Any help would be really great for me. Thanks, Dhananjay |
Thread Tools | |
Display Modes | |
|
|