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

crystal (strive4peace)

Michael Vasilevsky

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?

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.

ASKER CERTIFIED SOLUTION

Michael Vasilevsky

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

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.

Michael Vasilevsky

ASKER

ActiveX spreadsheet control was what I was looking for