Schedule Display in MS Access Form
I'd like to create a display embedded in an Access form like the attached Excel. The current path I'm taking is embedding the Excel spreadsheet for format and then updating it with VBA. Is there another recommended approach?
Thanks!
MV
Schedule.xlsx
Thanks!
MV
Schedule.xlsx
ASKER
Thanks but I do want to display the data in the Access form, rather than force the user to go some place else. Is there a better approach than using embedded Excel?
If it's just for display purposes (i.e. sort of like a Dashboard), then create a table with columns named like your Row1 cells in the Excel sheet, and then use VBA to fill that sheet.
However, you could use the embedded method suggested by Crystal, and use VBA to fill that embedded worksheet. Often that's a better choice than trying to force Access to act like a spreadsheet.
However, you could use the embedded method suggested by Crystal, and use VBA to fill that embedded worksheet. Often that's a better choice than trying to force Access to act like a spreadsheet.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Note that control is not certified to be compatible with Access (like nearly all ActiveX controls). It's also part of the OfficeWebComponents, which is no longer available. If you're going to deploy this to other users, you'll have some trouble with that one.
ASKER
ActiveX spreadsheet control was what I was looking for
https://www.experts-exchange.com/questions/28922684/Access-Form-Embedded-Excel-Spreadsheet-Does-Have-Scroll-Bars.html