Creating a template for an Access form in Excel

[cathywoodford]

Hi. Just wondering if I can create a template for an Access form in
Excel? If yes, can someone give me some ideas on how to do this.

Thanks,
Cathy

 

[Douglas J. Steele]

I'd be extremely surprised if you could.

Excel forms and Access forms are extremely different animals.

 

[Ron2006]

It would be almost as easy to convert "buttons" on your microwave oven
to become "buttons" on your stereo.

Ron

 

[Douglas J. Steele]

I want that song to play at Defrost for 15 seconds, please!

 

[James A. Fortune]

Hi. Just wondering if I can create a template for an Access form in
Excel? If yes, can someone give me some ideas on how to do this.

Thanks,
Cathy

Hi Cathy,

I haven't worked with forms in Excel, but Excel is capable of using
Automation to control Access. If Excel forms are capable of running
Excel macros you can have the macro open Access, manipulate some data in
Access using information from the Excel form, then close Access. Since
Access can create it's own forms programmatically, Excel can tell Access
to do that also. It's an interesting concept but one that not many
Access developers are forced to use. If you mean creating an Access
form directly from Excel without using Access at all, perhaps you can
use, IIRC, the undocumented methods SaveAsText and LoadFromText in
Access to see what the text storage of a form looks like for Access. An
Excel macro would be used to create a similar text file. I've never
tried that either.

Hope this helps,

James A. Fortune
(e-mail address removed)