Access form in word

[AppleEater]

What is the easiest way to open and use an Access form from a word document, and how can I do it ?

Thank you.

 

[scottfarcus]

Use VBA and automation.

You will need to create an instance of Access and use the OpenDatabase method of that instance to open the existing database. Once you have set the instance to a particular database and opened it, you can control in from within Word using VBA.

If you need an example let me know. I'll write something quick and send it to you.

Scott
access_junkie@hotmail.com

 

[AppleEater]

Thanks Scott. An example would be a great thing since I'm not very good with vba.