Migrating a whole lot of Word Forms into an Access Database

[mduplantis]

Hello,

Just looking for a few good ideas or suggestions. We currently use a lot of Word forms, that I am looking to migrate into an Access database. I am not so much worried about creating code to bring all of them in at once, but I am wondering how I would organize and if I can effectively manage.

My first thought is to create a main form with tabs to break down into main categories. I then could create buttons for each new form.

Has anyone created a project like this before? Any suggestions on preplanning or "gotcha" points, it greatly appreciated.

Thanks
Brent



PS. I have looked at Joomla plugin's as an alternative to Access.

[June7]

By migrate, do you mean embed Word documents in an Attachment field?

Access has a 2GB size limit. Embedding a lot of large files can use that up fast.

[mduplantis]

No, I'm sorry, I don't mean embedding a word document. I meant to say, I would create tables and forms to match the current word documents in an effort to go paperless. Some are small, but my biggest one will be creating a form to handle daily vehicle checks of fire department assets (fire trucks, medic units, etc).

Thanks

[nicko14]

You can do what you are looking to do with a Navigation Form, on a horizontal tabs, 2 level.

First you need to make your table(s), then the forms for each one.

Then create the navigation form, and then you simply drag the forms onto the tabs in any order you'd like. When the first level tab is selected it shows the second level tabs unique to the selected tab above, and so on for the second tab, third, etc.

As for buttons, you can do what you are looking to do as well. You can make a blank form and add command buttons. The rectangle box with the xxxx's when design tab is selected. The wizard can guide you through what you want that button to do (open new form, record form, etc).


My suggestion is to plan and design first on OneNote or paper, then create the tables and forms and try to replicate your design instead of trying to do it on the go.

[mduplantis]

Fantastic. I'll give it a shot. Thank you!