Spreadsheet functionality (Access 97 SR2)

Topic

New Reply

Is there a simple way to have some form of basic spreadsheet control on a form?
– I need to do some summations of various rental fields relating to properties, but the issue is that the period of change is different for each property
– I would like to put something like a 6 column by up to 21 rows Excel sheet on the form, but if possible avoid using Excel (not sure if every user has Excel)
– is there a easy minimal installation way to do this, as again different users have different options on installation of ‘other’ components (from no problem, to this must be authorised by the CEO)
I think I’m talking myself into a grid of text boxes with code behind the scenes to manage them, but wondered if there was a better way

Reply | Quote