RE: [Talk] Boston Software and VBA Forms

[Rich McNeil]

Linda,   I have good news and bad news.  The good news is, you can add Microsoft Windows Common Controls to a form in VBA just as you’d add it to a VB project’s UserForm object (Insert the UserForm and give it focus.  It takes all the usual components this way.  The bad news is that VBA uses “Forms2” a more “advanced” version of VB’s forms.  VBA’s Forms2 is quite different from VB’s, and I think it’s pretty bad.  You’ll probably have to start your Form design from scratch although a lot of your code can be transported between them.  Two major differences…no Timer component and an odd reliance on Modal forms.    Sorry, I missed your message.   Rich McNeil Boston Software Systems 866 653 5105 www.bostonworkstation.com   -----Original Message----- From: Linda Ralston [mailto:[EMAIL PROTECTED]] Sent: Monday, October 20, 2003 12:59 PM To: [EMAIL PROTECTED] Subject: Boston Software and Visual Basic   Hi there.  I sent an e-mail through [EMAIL PROTECTED] and wasn't able to get help on my question.   I'll rephrase the question.    When I use Boston Workstation the Visual Basic that comes with it is limited. VBA  rather than Visual Basic.  I am used to using Visual Basic and have written programs that access Microsoft Windows Common Controls.  Specically I am trying to allow the user to open the "File Open" dialog box to pick the file they need to work with.  I can't figure out how to do this with VBA?  Is this a stupid question?   Can you help me?   By the way,  please pass on a Thankyou to your company for the cookies that were sent to our office from Boston Workstation.  They were very much appreciated.   Thanks.   Linda Ralston, ISP Applications Analyst Peace Country Health Grande Prairie, AB Canada