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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Nov 9, 2005
Can an Access being shared and by multiple users concurrently?
View 1 Replies
View Related
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
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