By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,391 Members | 1,514 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,391 IT Pros & Developers. It's quick & easy.

Forms in Outlook and Tables in Access ?

P: 8
Ok, we've got this complicated form with 10000s of lines of vba code, doing all sorts of calculation,

The forms are on several pcs, and the tables are on the server, (using the external link)

Now we need to install those forms on many other pcs and are looking into buying liscencing,

Along the road, someone suggested to have the forms in Outlook instead of Access, (Since every one has Outlook)

My question is: Can a Form be imported and used and run from Outlook using external link to the tables on the server?

(i know simple forms can be created in outlook, but they dont have the complexity of access, so again, the question is: can a form created in access be imported in outlook)

Thanks,
Dec 11 '07 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
Ok, we've got this complicated form with 10000s of lines of vba code, doing all sorts of calculation,

The forms are on several pcs, and the tables are on the server, (using the external link)

Now we need to install those forms on many other pcs and are looking into buying liscencing,

Along the road, someone suggested to have the forms in Outlook instead of Access, (Since every one has Outlook)

My question is: Can a Form be imported and used and run from Outlook using external link to the tables on the server?

(i know simple forms can be created in outlook, but they dont have the complexity of access, so again, the question is: can a form created in access be imported in outlook)

Thanks,
As far as I know, you cannot, nor would you want to try, use Outlook in the manner you describe. The only reason I can possibly think of for that suggestion is budget crunching, as certain versions of MS Office do not have Access, while Outlook is ubiquitous.

You mention the forms are built with vb, is that vba as in the visual basic for applications that Access uses, or the visual basic that is a stand alone programming language (the two are not the same animal!)

Regards,
Scott
Dec 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.