Johny
Registered User.
- Local time
- Today, 11:32
- Joined
- Jun 1, 2004
- Messages
- 80
Hello,
I got an unbound OLE object on my access form that holds the excel sheet.
The unbound object is disabled and locked so the user can not click in it (otherwise the menu's of Excel appear)
Now.. when I paste data onto the sheet through code, sometimes the object isn't big enough to display all the data (meaning I have to change the height of the object to see all the data). But I know when increasing the height, Access has limited to xxx twips (dunno exact) but it isn't enough to display all the data on my sheet. So I though I just could lock the object and use a button onto the form to scroll on the sheet, but it doesn't work
It seem that the window has to be active if you want to scroll...
Anybody?
Or if anybody has another solution for my problem.. and yes, I really want to use an excel object on my form
Regards
I got an unbound OLE object on my access form that holds the excel sheet.
The unbound object is disabled and locked so the user can not click in it (otherwise the menu's of Excel appear)
Now.. when I paste data onto the sheet through code, sometimes the object isn't big enough to display all the data (meaning I have to change the height of the object to see all the data). But I know when increasing the height, Access has limited to xxx twips (dunno exact) but it isn't enough to display all the data on my sheet. So I though I just could lock the object and use a button onto the form to scroll on the sheet, but it doesn't work
Code:
me.excSheet.object.application.windows("Book3").SmallScroll down:=1It seem that the window has to be active if you want to scroll...
Anybody?
Or if anybody has another solution for my problem.. and yes, I really want to use an excel object on my form
Regards
