[Dba-office] Forms in Excel and Word

 Hi Gustav --

Yes, you can create UserForm objects, They are always unbound. They have slightly different set of controls than MS Access but programming them doesn't differ that much from programming MS Access unbound forms. And you can use WithEvents if you need to program a set of forms with similar generic manual data retrieving/binding/persisting/searching. WIthEvents worked in MS Excel better than in MS Access.

Here is a link on one sample UserForm: http://www.excel-easy.com/vba/userform.html

-- Shamil


Monday, February 02, 2015 7:37 PM UTC from Gustav Brock <gustav at cactus.dk>:
>Hi all
>
>Can you create an unbound form in Excel/Word similar to an Access form?
>I've never done this. It will have no data access - just a popup type of form.
>
>Any example to download to not reinvent the wheel?
>
>/gustav
>_______________________________________________
>Dba-office mailing list
>Dba-office at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-office