Link to home
Start Free TrialLog in
Avatar of howcheat
howcheatFlag for United States of America

asked on

EXCEL USERFORM IMPORTED INTO ACCESS MODULE/FORM

I have 10 MS Excel forms that I imported into my access module/form. The are userforms from excel, yet, I can bring them up in form view in ms access with the run menu command or the F5 key. However, how do I code a control button on another form to use the "on-click" to open one of these forms?

thanks,
howard
Avatar of nico5038
nico5038
Flag of Netherlands image

Did you try to use the Button wizard and select the Openform action with the formname of your excel form ?

Nic;o)
Avatar of howcheat

ASKER

They do not show up under the form wizard!
Hmm, interesting. Can you drop a zipped version this "excel.mdb" in my mailbox so I can have a look ?

Nic;o)
(Mail in my profile, click my membername)
ASKER CERTIFIED SOLUTION
Avatar of nico5038
nico5038
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Nico,

Thanks for your assistance. You can't believe how excited I got when that form popped up!! However, I am also listening to your advise about recreation.

thanks again,
howard
Glad I could help and your question learned me something new about the Excel form too :-)

Nic;o)