Access + Exchange File Browsing?

Apr 23, 2007

It seems like I've been all over the web searching for a solution, and I'm almost convinced it can't be done, but something makes me press on. Here's what I'm trying to do:

A user opens a form in Access. The user clicks a button on the form which opens a "browser" that actually points to an Exchange mailbox. After the user selects a message (or perhaps several messages), they click a "save" button, and the messages, their contents, and attachments are all archived out to a folder on a network drive and then are deleted from the Exchange server.

It seems pretty simple, sort of like envoking a file dialog, only pointing it to Outlook/Exchange. I've even tried linking the Exchange folder as a linked table, but I keep hitting a brick wall. Perhaps it's coders' block?

If anybody has any suggestions, they'd be greatly appreciated...

View Replies


ADVERTISEMENT

Access And Outlook/Exchange

Jun 6, 2007

I have searched the forums and did not see the question I am about to ask.

I have created a link table in Access to the exchange server at work. When I try to get someone to view the table I created they can not view it. When I look at the Link Table Manager it shows the link is pointing to my personal temp directory instead of the main folder in exchange. How do you link the table to a folder that all can see?

Thanks

View 2 Replies View Related

Browsing

Nov 24, 2006

I have just been playing with the browsing example at the link below and wondered if it is possible to take this a stage furthur and browse straight to a drive. For arguments sake could I go straight into the D drive if I had one, or a sub directory, thanks!


http://www.access-programmers.co.uk/forums/showthread.php?t=97787

View 2 Replies View Related

Exchange Rate

Jun 18, 2007

Hey guys,

I have a form that works out the cost of products from £ to € by calcuation where the user puts in the current exchange rate into an unbound text field.

i was wondering is this is at all possible:
to get the current exchange rate automatically off the internet from some kind of website

i would love to hear suggestions.. what kind of problems i am likley to encounter or if any one has attempted or succesfully managed to do this or something similar.

View 4 Replies View Related

Exchange Rate Problem

Sep 17, 2005

I've got a question about MS Access.

I've got a table with different customers and different rates that they offer for certain products. The problem is that different customers deal in different currencies. The currencies are one of three; Euro's, Pounds or Dollars.

I would like to create a query that would convert each customers rates to the same currency (pound).

The information is divided into 2 different tables. A customer table and a product table. I've created a form that is based on the customer table and features the product table as a sub-form.

What I would like to do is have an option that would enable me to enter the current exchange rates (as they are constantly changing) which would be used to convert the individual rates depending on the currency used by customers.

Form fields as follows

- cust_id
- cust_name
- company_name
- company_add1
- company_add2
- company_pc
- company_country

sub-form

- prod_id
- prod_name
- currency
- prod_rate
- convert

I'm sure this is possible, but my knowledge on this matter is limitted.

Thanks in advance for any advice given.

View 1 Replies View Related

ADP Based On MS Exchange - It's An SQL Server, Right?

Oct 10, 2006

Hi all,

First of all I hope this question is relevant to this part of the forum, I thought this was the best place to put it, but my ignorance of the subject may mean it ends up being more closely related to one of the other areas.

I'm struggling with some statistical reporting on Email Enquiries, which I'm currently doing manually using Advanced Find in the Outlook Public Folders and putting counts into an Excel spreadsheet. I find the whole thing quite ackward (as you might imagine), and the Advanced Find in Outlook frustrates me as it can be quite limiting.

What I'd like to do is set up an Access Data Project as a front-end for the Exchange folders concerned. I'm pretty well versed in MDB's but I've never set up an ADP before. I assume this is possible as I'm under the impression that MS Exchange is basically an SQL Server database. Is this correct? Will I be able to configure it using the Wizard that appears when I create a new ADP (if given permission by the MS Exchange Admin)?

Thanks for your help.

Abby

View 3 Replies View Related

Faxing To Exchange Server

Apr 7, 2008

I had in the pass written a program in Access 2000 that would directly output reports to WinFax. It wasn’t the fastest solution but it worked just fine. I no longer have a WinFax Server. So that solution is no longer an option. Is there a way for me to do the same thing with Access 2000 and Exchange Server? The idea would be, to be able to print the 200 or so price list and have them faxed out using Exchange Server. These are not a broadcast fax each price list would be faxed to a different number. I am using SQL SERVER 2000, Access 2000 and Exchange Server 2003. Any help would be greatly appreciated.

View 1 Replies View Related

Modules & VBA :: Working Directly With Exchange Server?

Jun 23, 2015

As part of a larger system I currently have a standalone A2010 program which processes emails that it sees within Outlook. As my client is moving to Exchange Server I was wondering whether there was a better way of doing this by getting rid of Outlook and "talking" directly to Exchange.

View 1 Replies View Related

Queries :: Sequence Number Reset At Each ID Exchange

Nov 18, 2014

I have two tables - one with parent Records, the other with child records. The ID links the two tables .I want to add a sequence number on the child table which resets at each ID change. What would be the best way to accomplish this?

Code:
PC_ID ID Name Address

P 1 Parent1 Address1
P 2 Parent2 Address1

PC_ID ID Name Address SEQ

C 1 Child1 Address1 1
C 1 Child2 Address1 2
C 1 Child3 Address1 3
C 1 Child3 Address1 4
C 2 Child1 Address1 1
C 2 Child2 Address1 2
C 2 Child3 Address1 3

View 4 Replies View Related

Modules & VBA :: Search Outlook Exchange For Email Address

Dec 3, 2013

I'm trying to see if can search outlook exchange from access vba to get email address (using windows user name) .

View 1 Replies View Related

General :: Mail Merge Word File (using Data From Access File)

Mar 11, 2014

I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.

Please download the attached file !

If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.

Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.

Secondly, I click 'Insert Word Field' -> select 'Next Record'.

In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.

View 3 Replies View Related

Backup Current Access File Using Vba While The File Is Open

Jul 11, 2007

I have a button in the form of the current access file. What I want to do is when the user click on the button,
triggered the vba to backup current access file. But since the file is currently open, is this possible? If yes, may I know how to do it with vba?

I have tried two methods but failed:
1) Use copytofile method, but I get permission denied due to file open;
2) Use dbengine.compactdatabase method, but it also has problem if the file is open.

View 3 Replies View Related

Does File Server Hosting Back-end Mdb File Need To Have Access

Nov 15, 2013

I'm experimenting with MS Access, and I've successfully split an MDB someone created into two files. I can access the database from 2 computers at once using the front end file connecting to a file server which hosts the _be.mdb file.

Could the _be.mdb file theoretically be on a NAS without any computer attached, or is there some runtime or full version of Access that needs to run on the machine with the back end file?

View 2 Replies View Related

How To Make Setup File From Access File

Dec 7, 2006

i have develop an application in Ms Access, now i want to have setup file for that, how a setup file can be created.

View 3 Replies View Related

How To Convert .MDE File In To .MDB File In Access 97

Jul 18, 2007

Hi,

I want to make some changes in .MDB file and i do not have it. I have only .MDE file.. Could you please let me know how i can convert .MDE file into >MDB file so can change tabelsa nad reports...

Many Thanks

Nitesha

View 1 Replies View Related

Can Put Flash File Or Swf File In The MS Access

Nov 27, 2005

Hi,

In the Forms of the MS Access,

Can we add the flash file, or swf, other animation file on the form?

Thanks.

View 1 Replies View Related

Convert Access File To Exe File?

Dec 30, 2011

i want to convert accdb file to an exe file that not display any design view in other words i want the user watch only the forms and handle with the application as a program.

View 2 Replies View Related

Converting Access 2003 File To Access 2002

Nov 19, 2006

Hello,
I have created several files in Access 2003, and sent them to a collegue, but he is using Access 2002 and cannot open my files.

What do I need to do so he can access my files? My experience with Access is very limited.
Thank you in advance for your help.
Phil

View 3 Replies View Related

Zip File In Access

Feb 1, 2007

I need to copy a bunch of images to a directory then zip up that directory.

I don't seem to be having much luck finding info on how to get this done.

Any help?

iz

View 3 Replies View Related

Program Working In Access 2007 Not Working In Access 2010 Due To Missing OCX File

Dec 27, 2014

I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.

The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?

View 1 Replies View Related

How Can I Open A .mdf File In Access

Jul 16, 2005

Hi,

We have an old SQL server here which has died a horrible death and I need to get the data it contains out!

I have the .MDF files etc but I cannot seem to open them or import them in microsoft access.

I dont need to do anything flashy with it, just look at the tables!

Can anyone help?

Thanks

:)

View 14 Replies View Related

Fixing Access File?

Aug 10, 2005

i've got a 200mb mdb file and i can't
open it with ms access.

any idea how to fix this file?

ThanX
Yigal

View 9 Replies View Related

Open Old Access File

Oct 6, 2005

I am not an experienced Access developer.

I have a .mdb file that was created with Access 2000. Before I upgraded to 2003, I opened the file source by holding down 'shift' and double clicking the file. Now when I do that, it runs the application. How can I open the source file again.

Thanks

Anthony

View 1 Replies View Related

Access File Shared

Nov 9, 2005

Can an Access being shared and by multiple users concurrently?

View 1 Replies View Related

Opening PDF File From Access Is This Possible

Nov 24, 2005

Hi All

I'm not sure if this is even possible but I have a table which has a list of Categories(text) and another field named filepath(also text) which contains a file path which points to specific pdfs. So my question is Can I create a report which then prints the categories with a button next to them which if clicked on opens the coresponding pdf ?

Any help will really be apreciated I am a database novice but am really good at following instructions and copying code :)

Thanks in advance
Mel

View 3 Replies View Related

Access 2003 File

Dec 27, 2005

I am wondering if someone could save the attached access 2003 file as an access 2000 file so I will be able to open it. Thank You

Jeffsal

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved