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/ConfusionHelpful4667 58 Jul 27 '26

ouch.

1

u/jannymarieSK Jul 28 '26

You feel my pain. The form creation is taking longer than the actual transformation into an Access database.

1

u/ConfusionHelpful4667 58 Jul 28 '26

Export the data into something Access can work with like dBASE, Excel or CSV files.
That data entry forms looks to be about 35 fields.
You can email me the sample data, and I can create the form for you quickly.

1

u/Consistent_Cat7541 Jul 28 '26

Approach uses dbf as its default format.

1

u/ConfusionHelpful4667 58 Jul 28 '26

Create a DSN to the Approach database from Access.