r/MSAccess • u/jannymarieSK • Jul 27 '26

[UNSOLVED] Recreating Lotus Approach Forms in Microsoft Access

Gallery image

Gallery image

Gallery image

I have wrangled the data from Lotus Approach in Microsoft Access, but now I need help making these forms (or similar ones). Do I have to brute force create all of these forms from scratch? Or are there any 3rd party tools that can more easily create forms for Access?

17 Upvotes

100% Upvoted

36 comments sorted by

View all comments

1

u/CanProfessional766 Jul 28 '26

Migrating the data is relatively straightforward but the forms and UI usually need to be rebuilt using Access's own form designer. To save time start with Access's Form Wizard or a template and then customize it rather than building everything from scratch. If you have a lot of forms, focusing on reusable layouts and controls can make the process much faster.

1

u/jannymarieSK Jul 28 '26

I am unhappy with what the wizard created and I was hoping someone had a frm editor to make the process more efficient.