Avatar of Michael Vasilevsky
Michael VasilevskyFlag for United States of America asked on

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
Microsoft AccessVBA

Avatar of undefined
Last Comment
Michael Vasilevsky

8/22/2022 - Mon
crystal (strive4peace) - Microsoft MVP, Access

ASKER
Michael Vasilevsky

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?
Scott McDaniel (EE MVE )

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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
Michael Vasilevsky

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Scott McDaniel (EE MVE )

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
Michael Vasilevsky

ActiveX spreadsheet control was what I was looking for