473,799 Members | 2,786 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access Report Issue - Really Need Help

69 New Member
Hello all...

My company generates reports in an Access database that are used as quotes for our customers. We have always then mailed (snail mail) the quotes to the customer.

Now my boss wants to send these quotes via email. I made it so that he can save the reports as snapshots and then send those to our customers, but not everyone can view them. I thought that the snapshot viewer from Microsoft would allow any Windows user to view the reports, thus fixing our little problem. However, I have some customers who can't get the viewer to work... long story short... I can't (and don't have the resources) to physically go to the customer's location and make their pc run the viewer properly. So....

My question is... does anyone have an idea for a way that we can send these quotes (Access reports) to customers without having to use a third party product like adobe creator? All of the other forms for saving an Access report just save the data, and not the report formatting. I need a way to create a jpeg, bitmap, or any other file format the is readily available in all version of Windows, without using anything from a third party.

I appreciate any ideas that anyone may have...

Thanks,
Rodney
Feb 7 '07 #1
4 1809
ADezii
8,834 Recognized Expert Expert
Hello all...

My company generates reports in an Access database that are used as quotes for our customers. We have always then mailed (snail mail) the quotes to the customer.

Now my boss wants to send these quotes via email. I made it so that he can save the reports as snapshots and then send those to our customers, but not everyone can view them. I thought that the snapshot viewer from Microsoft would allow any Windows user to view the reports, thus fixing our little problem. However, I have some customers who can't get the viewer to work... long story short... I can't (and don't have the resources) to physically go to the customer's location and make their pc run the viewer properly. So....

My question is... does anyone have an idea for a way that we can send these quotes (Access reports) to customers without having to use a third party product like adobe creator? All of the other forms for saving an Access report just save the data, and not the report formatting. I need a way to create a jpeg, bitmap, or any other file format the is readily available in all version of Windows, without using anything from a third party.

I appreciate any ideas that anyone may have...

Thanks,
Rodney
From what I understand, the only way to accomplish the E-Mailing of Reports while retaining all their original formatting is to either have the Snapshot Viewer or Microsoft Access installed on the recipient's PC. You do state whether or not you are on a Intranet. If you are, simply install the Snapshot Viewer on the Server and have the Clients view the Reports via this route.
Feb 8 '07 #2
MSeda
159 Recognized Expert New Member
I know you said you don't want a third party application but pdf print drivers work very well for what you need. I like cutePDF (its free). the user has to name the file and can change the location is my biggest complaint. but I like to print reports like invoices and quotes to the server. It serves a backup for important documents and is easy to search.
I've been meaning to do a search for an activeX pdf print driver that works well and is in my price range (free) but I haven't gotten around to that yet, Maybe someone knows of one.

http://www.cutepdf.com/
Feb 8 '07 #3
narpet
69 New Member
Thanks very much for all of your input. I tried the cutepdf and it works great. I am going to use that as a solution to our problem.

Thanks everyone!
Rodney
Feb 8 '07 #4
MSeda
159 Recognized Expert New Member
I'm Glad it worked for you.
I'd still be interested if anyone knows of any activeX controls that let you create pdfs programmaticall y.

Megan
Feb 8 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2662
by: intl04 | last post by:
I am getting strange print-related error messages when trying to create (not print!) reports. For example, when I click 'new' to create a report then choose 'design view', I get an error message that says: 'There was a problem retrieving printer information for this object. The object may have been sent to a printer that was unavailable.' When I choose 'report wizard', I can go through all of the steps but then I get an error message...
49
14364
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The application is relatively big: around 200 tables, 200 forms and sub-forms, 150 queries and 150 repports, 5GB of data (SQL Server 2000), 40 users. I'm wondering what are the disadvantages of using Access as front-end? Other that it's not...
7
8874
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I want my users to be able to select a report, click on a command button on a form, which will then automatically create the report as a pdf file and save it to the user's machine. I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
11
6604
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on where the job is running, the job runs sucessfully, PDF files got generated, everything is good. If I scheduled the job to run at the time that I am not logged into the server, Access is not able to print to the printer. The error is pretty...
20
3351
by: Olav.NET | last post by:
I am a .NET/C++ developer who is supposed to do some work with Access. I do not know much about it except for the DB part. Questions: *1* I am looking for INTENSIVE books to get quickly up to speed. I like books with practical exercises, and also with test questions (like cert books) *2*
14
2469
by: Crimsonwingz | last post by:
Need to calculate a sum based on a number of factors over a period of years. I can use formula ^x for some of it, but need totals to carry over in the sum and have only been able to do this thus far with a loop in a form. Basically, I have key sums Current savings Current Salary Current deposit amount
22
2232
by: Deano | last post by:
Hi, I have a finished Microsoft Access app that we are distributing using an Access runtime. This works fine (mostly) but I'm sold on the advantages of dot.NET and upgrading to vb.NET seems like a good idea for the future. I'm also keen to develop new software in vb.NET as soon as possible. I will work out how to port the app and how to use ado.NET etc, however I'm not certain about all the things I need to consider hence the...
4
6413
by: alexandre.brisebois | last post by:
Hi, I am using access 2003, I would like to know if there is an option to reorganize the tables in a maner that is readable, as we can do in sql sever 2000 or 2005. I have been given a database to look a and I am loosing tremendious amounts of time trying to organize it so that I could view it. Regards, Alexandre Brisebois
4
4237
by: lupo666 | last post by:
Hi everybody, this time I have three problems driving me nuts :-((( (1) I have a report with 20 or so Yes/No "squares". Is there a way to either hide/show the "square" or change the yes/no relative textbox, depending on value? (2)
39
4295
by: Martin | last post by:
I have an intranet-only site running in Windows XPPro, IIS 5.1, PHP 5.2.5. I have not used or changed this site for several months - the last time I worked with it, all was well. When I tried it just now, I am getting the subject error message (specifically: PHP has encountered an access violation at 00F76E21). The error is NOT occurring on every page request (but it is on most of them) and, when I get the error, simply pressing <F5to...
0
9543
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
10488
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
10257
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10029
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...
0
6808
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5467
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
5588
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4144
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
2
3761
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.