473,804 Members | 3,720 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Forms in Outlook and Tables in Access ?

8 New Member
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 1200
Scott Price
1,384 Recognized Expert Top Contributor
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
4069
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 possible under the newer versions of Office to use the information already stored in Outlook as part of an Access database project. The logic being that the data could then be held in one place rather than two. This is a customer & order management...
1
1796
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 avail. Briefly, the problem is this: I'm having an old Access 2.0 database that I want to convert to Access 2000 on a different computer. The reason why the new database is on a different computer is that the old database runs under Windows 95a...
19
4115
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 the code that implements managing unbound controls on forms given the superior performance of unbound controls in a client/server environment. I can easily understand a newbie using bound controls or someone with a tight deadline. I guess I need...
1
1241
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 again into Access. Is there any way to access the student information from the Contacts in Outlook, so we don't have to type the same information in twice? Thanks!
3
1923
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 maximum of 5 deep starting at the INBOX. So.... the problem is that Outlook is running too slow now and I have to figure out how I can organize these messages
0
4253
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 Applications and owner of Access Microsystems. Doug can be reached at doug@accessmicrosystems.com. --------------------------------------------------------------------------------
5
3330
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 time-periods that the rooms are booked for that day. I know how to code all this in Access. I can show some testdata for 5 rooms quite nicely on a form. I never ever needed to use Outlook-to-Access before, so I need a good starting point to get the data.
4
2007
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 linked table in the database which is drawing data from the outlook contact file and have related this to the relevant access tabel so we can see all the data from both tables in the access form but I am at a loss as to how to actually open the...
6
2661
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 (recently bought a PDA to bring to job sites!). I have been able to get things set up so that I can synchronize my Quickbooks customer and vendor lists with the Outlook contacts, and thus with my PDA and this has been immensely helpful. My DB has...
0
9706
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9582
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10580
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10082
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7621
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5525
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5652
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4301
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2993
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.