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...
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?
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!
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.
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.
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)?
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.
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.
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
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.
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.
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?
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...
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.
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?
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.
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 :)
