473,326 Members | 2,126 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Forms in Outlook and Tables in Access ?

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
1 1175
Scott Price
1,384 Expert 1GB
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

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

Similar topics

1
by: Iain Miller | last post by:
Currently using & developing a new application in A97. This app has a lot of Name & Address information in it. A lot of that information will be duplicated in Outlook & I suddenly wondered if its...
1
by: Stephan Neuhaus | last post by:
Hi all. I'm having a problem that's driving me nuts. I am not familiar with Access, but I have read the FAQ, searched google, read the Access Security FAQ, and looked at the Access Web, to no...
19
by: James Fortune | last post by:
I have a lot of respect for David Fenton and Allen Browne, but I don't understand why people who know how to write code to completely replace a front end do not write something that will automate...
1
by: Joy | last post by:
Hi - There is a file of students in Outlook (located in Contacts). These students are also used in my MS Access 2002 program. But we have to type everything (all the student information) in...
3
by: Curious George the Monkey | last post by:
Hi, I have about 20,000 emails of which about 1% of them have attached word, excel, jpeg, pdf, powerpoint files. The emails are located in about 1000 folders. The hierachy of folders is...
0
by: Anonieko Ramos | last post by:
ASP.NET Forms Authentication Best Practices Dr. Dobb's Journal February 2004 Protecting user information is critical By Douglas Reilly Douglas is the author of Designing Microsoft ASP.NET...
5
by: Arno R | last post by:
Hi all, I need to get at specific (shared) agenda-data from MS outlook 2003. I need every day to get the scheduled 'appointments' for some rooms to Access. In Access I will show the...
4
by: rwm | last post by:
Hi Before updating to Access 2007 we could open outlook contact entries by using a hyperllink along the lines of <outlook://contacts etc> This does not seem to work in 2007 any more. We have a...
6
by: Kevin | last post by:
In my business, I use Quickbooks extensively for billing and accounting and a custom built Access DB for project management. I recently began using MS Outlooks contacts quite extensively as well...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.