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 Replies
ADVERTISEMENT
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
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
Feb 24, 2005
Hi Guys,
I wonder if there is any way we can fax a report just like we can print it on a printer or send as email. Any thoughts..
Thanks,
BinJos
View 4 Replies
View Related
Nov 3, 2005
i have a form, every post on this form is connected to a deliverer in a table, every deliverer has a faxnr.
I want to be able to push a button on a form and it will fax the form to that deliverer, how woud this be done?
Ive checked that microsoft page about send object and stuff but i dont get much and it doesnt seem to be what i want to do.
Is this thing even possible in access?
When i try a sendobject command, i get "coudnt start the mail software, check that the software works" translated from swedish.@@1@@1
View 1 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
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
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 3 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
Feb 23, 2006
hello,
I have faxing setup through the XP wizard, I setup my report in Access to use the Fax as specific printer. So When I select a record, it generates the Fax wizard which then prompts for the senders name Fax # etc. and away it goes.
that is ok but It would be nice if I could use the Fax number from the record I am sending, either current record or all. I guess the main trick is how would I pass the fax number to the Fax Printer interface?
Is it possible? I've read a few articles on Microsoft Fax for workgroups to work with Outlook, Outlook help says to go to Office update and download it but I can't find it there? Also do the newer versions of Outlook/Access have a better means of doing this? I am running office 2000, but I can get 2002 installed if that is the case.
thanks
Ziggy
View 1 Replies
View Related
Nov 30, 2006
Using A2002 or A2003, trying to convert an app from Jet to SqlServer
i am using DAO rather than ADO
this statement causes an error
Set rs = dbs.OpenRecordset("tblconstants", , dbSeeChanges)
the error is
error 3622 - must use dbseechanges on a sql server table with identitiy bit set
alternatively
Set rs = dbs.OpenRecordset("tblconstants", dbOpenDynamic)
produces error 3001 - invalid argument
(Note: i've got another app, in A97 that works with sql server tables without any additional parameters )
Set rs = dbs.OpenRecordset("tblconstants") works in A97
------------------
any idea what do i need to do please
View 3 Replies
View Related
Feb 18, 2007
Hi. hope you can understand my english.
I have 2 SQL Servers.
Is there some way to set to which sql server connect the .adp (or .ade) via code??
Now I have 2 sql servers (development and production).. but soon I will have more server at production in different cities. All SQL Servers have different names. Same databases names but the servername are all different.
So I have to configure the connection of the .ade in the the development server. Then when I want to send and upgrade to one of my clients, I have to go to his city and manually reconfigure the .ade to connect to his SQL Server.
This problem would be solved if all SQL Servers had the same name, but this is not my case.
It would be nice to have a config.ini file or something like that where the .ade could read the name of the server to connect to.
Is it possible to implement something like this.
Thanks in advance.
View 1 Replies
View Related
Sep 6, 2004
Hi, i am looking at making use of SQL Server which we have at work to run our access Database from, is this a good idea ?
what are the benifits, problems etc...
Andy
View 1 Replies
View Related
Nov 14, 2004
I am trying to insert a picture in a field OLE object, but after I have selected the picture I would like to insert, I get the following error message :
A problem occured while MS Access was communicating with the OLE server or ActiveX Control.
Can someone help me to resolve this problem ?
View 1 Replies
View Related
Apr 19, 2005
I've never dealt with SQL Server, and have no working knowledge of it. Is it possible to upsize my db without it? The server that we have uses Windows 2000 Server as it's OS, would this be capable of housing an upsized db? I was tols that MSDE is only capable of about 15 concurrent users, and I will be having +-100 concurrent users on this particular db. Is there another option?
View 1 Replies
View Related
Mar 25, 2007
Hi guys, its been awhile. I inherited a database thats an MDB and I need to get it on to sql server but I am having problem with this query, can anyone help please. Its suppose to give you the month and year when you click on it, you just put that in and up come the results on a query or report, now I have something similar to this but the code is very different.
SELECT DISTINCTROW Format$([Main Table].Date,'yyyy') AS [Date By Year], [Main Table].[Violation Type], Sum([Main Table].Loss) AS [Sum Of Loss], Count([Main Table].[Violation Type]) AS [CountOfViolation Type]
FROM [Main Table]
GROUP BY Format$([Main Table].Date,'yyyy'), [Main Table].[Violation Type], Year([Main Table].Date)
HAVING (((Year([Main Table].[Date]))=[Please Enter the Year]));
This gives them a dialog box which ask them for month and year and they enter it in and they get a generated report or form which gives them their results. But when I transfer this to SQL it gives me error message cause Jet SQL and SQL Server dont exatly speak the same language, I mean SQL server doesnt know what Format$ is I guess thats something ACCess comes up with on its own or something, I dont know. HELP PLEASE!!??
View 2 Replies
View Related
Jul 20, 2005
I've downloaded and installed the new SQL server 2005 express edition CTD (June ed.) along with the Express Manager.
How do i get an access database into SQL server?
Now that it's installed, what next? When i try to upsize, it asks me to choose a server, and gives 3 options, and i'm not sure where they come from. Where does this list come from? are they previous installations of the MSDE on my computer? are they servers that ar available over our LAN?
i read that the default name if an instance of SQL server express is SQLEXPRESS but that's not on the list...
do i need to create a new instance of SQL server on my computer to house the database?
I really just want to try it, to see if it's something we should do, but i can't get it to do anything at all. i don't know where to start...
I've done some searches, but nothing tells me where to start. I'm getting really frustrated with this....
Please help me...
View 2 Replies
View Related
Jan 31, 2006
Hi,
This is the first tim here, hope to find what I am looking for :D
I am developing a small form in MS Access for recording attendence. I made a form and a buton which get the time and store it in a table.
The problem happens when a user change the his computer time and click the button, the new time will be recorded.
The question is how to fix the time or get the time from a centeral computer or server?
Note the DB will be placed on a shared PC or on a server in the LAN.
Thanks,
View 2 Replies
View Related
Mar 16, 2006
I have A db that links to a SQL Server table via an odbc connection. The problem is that I have to set up the odbc datasource on each machine that needs to run the db. Can I set up an ADO connection to the table and use that connection as a record source through out the app to drive forms , reports, etc? (And this would eliminate the need to set up and odbc connection to the table on each machine...) :confused: :confused:
View 6 Replies
View Related
Apr 19, 2006
Oracle Express Edition, DB2 Express Edition-C, and SQL Server Express Edition.Which one would you develop for / work with if you had a choice (SQL Server, Oracle, or DB2)?I am thinking of making a database application with one of the above and the criteria is:Great support, communityRock Solid and stable; where some clients do not have a DBAFastEasy to back-up and restoreRelatively easy to program and developEasy to deploy and scaleThe general direction I am getting from a few people is leaning toward SQL Server Express. They say it is easier to work with than Oracle, (supposedly Oracle is not for the faint hearted especially when there are network issues) but Oracle is faster and maybe more stable than the others. Haven't really heard anything about DB2...MySQL is out, simply because of the price of an OEM for a desktop application that can be expanded later is too high for what I want to do.Thoughts?Thanks
View 1 Replies
View Related
Oct 11, 2006
I've been asked to assist a local non-profit transfer an Access DB to a new server. The DB was set up a number of years ago and the designers are no longer available.
The old server is set up as a workgroup server, and the new server is set up as a domain server. (I am completely unfamiliar with how networks are set up...I've never dealt with this end before.)
The designers set up a .mdw file which (I believe) controls permissions etc. After much wrangling, we finally uncovered the admin password. However, even signed in on a workstation as the admin w/ full rights, I still can't copy a functional version of the DB to removable media in order to move it to the new server.
The server does not have MS Access loaded....only the .mdb and .mdw files.
I *think* I have to replace the 'secured' .mdw file with a generic, clean .mdw. Do I need to do this on the server, or the workstations, or both?
What am I doing wrong????
Thanks!
View 1 Replies
View Related
Jan 30, 2007
Hi all,
I have an .adp that works fine on a number of people's laptops.
One of the users however, keeps getting an error message stating that SQL Server does not exist or access has been denied.
This particular user is definitely setup on SQL Server with dbo permissions. She can also ping the server.
I have tried creating a DSN and this doesn't work either.
I am at a loss as to why this error message is occurring given that she can see the Server and has definitely been setup.
Do you have any suggestions?
Thanks,
Kabir
View 1 Replies
View Related
Apr 20, 2007
I'm planning make a move from Access to SQL Server.
To be honest I never used it before, but I told to my bosses that I'm a Gooroo in it.:)
So can you guys give me an idea if it is really hard to make a move, to upload the existing databases and to get used to it.
How long it takes?
What books would you recommend?
Or what forum?
View 10 Replies
View Related
Jun 11, 2007
Dear All,
I have developed a full attendance and payroll system.
I want to make this system available for responding remotely as well through email and SMS.
Thus, I am planning to attach a GSM modem into the server hosting the system, and assigning a fixed telephone no. The client can send SMS to this server, which in turn respond to his request.
To make this, I should also install a third party software through which I can access to the Incoming and outgoing SMSs database using MS Access coding.
I have got such third party software called Activexperts SMS Messaging Server. However, the software license is $ 1,400 which is expensive for me.
Thus, can you suggest me another software name I can use to handle such job.
Thanks,
View 4 Replies
View Related
