I have been working on a project that uses MS Access to get mutual fund
performance and write it to a spreadsheet in a formatted manner. The user
inputs the company name, the database looks at the company's 401k fund
holdings and extracts the performance info and benchmark info for them. It
writes out the information to a spreadsheet embedded on an Access form and
simultaneously writes the same info to Excel. I also have logic built in
that will compare the performance of the fund to its benchmarks and will
highlight the row in the spreadsheet if if fails to beat one or both of its
benchmarks on a 3-yr basis.
Now, if an existing fund is performing poorly, I'd like to give the user
the option to select alternative mutual funds from our master list of such
funds. One idea I have toyed with is to embed checkboxes on the
spreadsheet and have the user check the boxes if they'd like to see what
alternatives we can offer. I am not sure if or how that would work.
Another idea is to put a list of funds into a popup dialog box with
checkboxes in it. I'm pretty sure that is doable in Access.
Has anyone been in a similar situation? What would be a good way to
approach this? Pitfalls to look out for? Just looking for a general
approach at this point. Thanks for any ideas that you have.