Printing Letters To Specific People Through Access

Feb 23, 2005

Dear All:

I have created a from containing names and address. On This form I have a checkbox called "MailLetter" and a command button called "Sendletter".

I place a check in the box corresponding to specific people, then using a command button a letter is printed to ONLY THOSE WHO ARE CHECKED.

The letter is a Word document that resides on the desktop.

Here is the code behind a command button to print. Not sure if it is correct:


Private Sub Command2600_Click()
Dim WordObj
Set WordObj = CreateObject("Word.Application")
WordObj.Visible = True
WordObj.documents.Open "C:Documents and SettingsUserDesktopLetter.doc"
End Sub

I assume this can be done through some sort of mail merge?

Thanking in advance.

Regards,

Dion

View Replies


ADVERTISEMENT

Stop People Printing Forms

Mar 22, 2006

Hi all,
I have a form that i use for data input, I have limited all of the menu's how ever the print option is still available. This leads to muppet users printing out the form and using it.
There is a print button on the form that prints a report out that lays out the form into a useable item.

So the question is... How can I stop people being able to print out the form?

Thanks in advance

Steve

View 14 Replies View Related

General :: Letters Missing When Printing Report

Sep 11, 2014

When I print a report from Access, it prints fine. When a colleague does it to the same printer, it misses out lots of letters. Another colleague does it, and it prints fine. The font is standard (Calibri). My IT dept. say it isn't the printers fault. Is it something wrong with my report ?

View 3 Replies View Related

Forms :: Group Membership - Select Which People Belong To Specific Groups

Mar 11, 2013

I need to create a simple database where I have a list of people, a list of groups and all I want to do is select which people belong to specific groups.

All I need is to create a form where I have a list of my people and a tick box next to the groups to show who belongs to which group.

View 5 Replies View Related

Printing To Specific Printer

Apr 20, 2004

Does anyone know if there is a way to setup a button on a form that when pressed, will print to a specific printer (that's not the default)? For example, I have one button on my form that prints 2 copies to the default printer, then I want the other button on the form to print on another department's printer.

Thanks!

View 4 Replies View Related

Printing Parts Of Records In A Specific Format

Oct 27, 2005

i've created a database for city permits to be issued (which works perfectly thanx to alll your help), but now i need to be able to print out 1 permit at a time when it is issued (immediately after the data has been entered into the forms). i have 3 tables & 3 forms: contractors/owners, permtOrders (which has tabs for the different types of permits), and permitOrderDetails. the problem is the forms are set up for data entry (and only open in add mode for obvious reasons)...i need to be able to print an actual permit (like the carbon copy, landscape kind that usually tears out of a book). once the user enters the information into the forms, i need a little bit of that info from each form to be carried onto the actual printable permit. i'm not really sure how to accomplish this. :confused: i don't really know if i explained this right, but any suggestions are greatly appreciated.

View 6 Replies View Related

Reports :: Printing Multiples Of Specific Pages

Mar 28, 2013

How would I go about printing multiple pages of a certain page in a report. My goal is to get them to collate together. Please see example below:

I have 7 operation codes (A-G), but I need multiple copies of each within a set:

Below is how I would like to print it out:

A, A, B, C, D, D, A, E F, G

Also, not sure if it matters, but the report has a subreport to print the appropriate rework code on the back of every sheet (2 sided printing)

This will be the same every time, and I have made a tbl in the db with the order I require.

View 1 Replies View Related

General :: Printing Specific Records Displayed In A Form?

Jul 18, 2015

How do I go about printing specific records displayed in a form? I basically just want to add a print button on my form to do this

I have a main form with a button that displays/opens a form

I then want to print the records displayed in the opened form

(See attached pictures)

View 3 Replies View Related

Letters In Access

Aug 31, 2005

We are in the process of converting from Lotus Approach to MS Access.
In Approach we could create letters that would add the fields we told it to.
We do not want to have to use the mail merge to Word. Can letters be created in Access?

View 2 Replies View Related

General :: Does Access Recognize Capital Letters

Jun 15, 2012

When enforcing referential integrity, does access get angry about capital letters?Or just in general, if an address gets put in with a capital letter in one instance and then without in another does it make a difference?

View 14 Replies View Related

Using Access To Maintain Client Data And Generate Standardized Letters

Jul 31, 2013

I'm not sure if Access is the right program to use for this scenario as I only know the basics on creating the database.

I want to be able to create a client database and then be able to generate a number of standard template letters at any particular time for selected clients.

I don't want a mail merge!!

Can access be used for this?

Ideally I would like to create a form for administrators to use to input new client info and update existing clients info and then just be able to click a button (or the like) to generate the standardized letter for a particular scenario.

View 1 Replies View Related

Modules & VBA :: Printing Code Slowing Down Printing Reports?

Feb 25, 2014

I was having trouble just setting each report with a particular print method - for some reason they just kept forgetting their individual settings and resorting to default on the machine.

This meant reports were printing on the wrong paper, or the wrong size paper, the wrong orientation and some times refusing to print if it couldn't find the paper (which is useful in runtime as it doesn't display error messages)

So I used Reports(rpt).printer properties (I forgot where I found this) to hard code the printer properties into each print command... this meant I had to use another function to insert the variables.

So all I had to do was say:

Code:
PrintMe("Invoice","InvoiceID",iID)

and a report would print to exactly how I wanted... but it's just too slow!

See attached for full code, I have a niggling feeling it may be the function: PrinterOK, to make sure the printer exists or not.

Code:
Function PrinterOK(sPrinterName As String) As Boolean
Dim MyPrinter As Printer
PrinterOK = False
For Each MyPrinter In Printers
If MyPrinter.DeviceName = sPrinterName Then
PrinterOK = True
Exit Function
End If
Next
End Function

I know it's the printing code, because if I stop the printing and just preview then it shows up almost instantly.

View 1 Replies View Related

Printing From Access

Jul 25, 2005

Hello,
I have one machine that gets this error when trying to print or e-mail a report:
the microsoft jet database engine could
not find the object

Any other machine can print from this db.
Access 2003. XP Pro, SP2.

View 7 Replies View Related

Printing In Access

Nov 18, 2004

Hi

Anyone who can help me out?


I have a report in access.
I have designed the report such that. When a user wants to print
there is a prompt for the user to enter the order number.The report displays
all the orders for that order number.A number is assigned for that print out.This
number is unique for every order number the user enters.

How do i capture the generated print out NUMBER, store it in a table so that when
there is another printing for the same order number No NEW PRINT OUT NUMBER is
displayed.The user should also be prompted that he/she is printing an already printed orders.
However in case of a new order number, the generated print out number should be differnt which
should also be stored for future refencing.

Please help

View 3 Replies View Related

Printing With Watermark In MS Access

Aug 29, 2005

I want to be able to create a background image as a watermark for Access Reports when they are printed. Now, as I can figure, the Report has a "Picture" property which I can use to set this.

The catch is, the contents of the background image is not static, it must be generated on-the-fly. (for example, it can contain the date of report generation) So, I think, that's ok. I'll need to create an ActiveX object that will generate the image, then I'll assign the image to the picture property using VBA.

Now, my concern is, can I set it up such that even if users create a new report in the database, this behavior can still be automatically done? Is there a way?

Also, would it be possible to set a background image for query results also?

View 2 Replies View Related

Access Printing Woes.

Mar 19, 2007

Here's a weird problem I've had develop in the past couple months, before I upgraded to 2007, and now since I upgraded to 2007.

I've had the same Access database since 1997, and just recently upgraded it to Access2007, but as I said the problem occurred before and after the changeover.

I have two servers at the office. Server #1 (where the database is located) has attached to it is a dot matrix printer, used for printing our 4 part invoices/packing lists. I have another server (#2) which has a laser printer attached to it. The laser printer on server #2 is the default printer for all computers in the office. I have a lot of reports in Access where the printer to be used is the default printer. I have a single report in Access where I specified in the page design and layout to use a specific printer - the dot matrix on server #1.

Both servers are always on. Both printers are always on. I can go for weeks and weeks with no issues in printing the invoices. Then suddenly I'll get a

"This document was previously formatted for the printer (printer name) on (server #1), but that printer isn't available. Do you want use the default printer (\server#2laser printer) ?
OK CANCEL SETUP... HELP

It worked fine for 9+ years, and now I am getting this error. No new computers in the last 2 years. No new printer installs in the last 2 years.

I've gone through, uninstalled the printer, reinstalled the printer, both on the server and remote machines, and now I can't even get the report to "remember" that I want it to always print to the dot printer.

Any ideas?

View 1 Replies View Related

MS Access 97: Printing PDF Files

Sep 14, 2004

I would like to be able to print PDF Files from MS Access 97. I have a table with records containing all the information necessary to create full pathname of the file (i.e. strPathName). But how do I get it to print (not view) the file once the record is selected from a drop-down box. Do I have to create a module to do this? Or is there some simple trick? If anyone has come code for doing this, it would be much appreciated. Thanks!

Malcolm
Tulsa, OK

View 1 Replies View Related

Printing A Letter From Access

Aug 18, 2004

Dear All:

I have created a print command button on a form. When this button is pressed, It should print a Word document.

I have composed this document in Word already.

Any ideas on how to do this?

Many thanks in advance,

Dion

View 2 Replies View Related

Printing A Letter From Access

Aug 20, 2004

Dear all:

Code:

Private Sub Command167_Click()
On Error GoTo Err_Command167_Click
Dim objWordApp As Object
Dim objWordDoc As Object
Set oApp = CreateObject("Word.Application")
'make word not show up to user
objWordApp.Visible = False
set objWordDoc = objWordApp.Documents.Open(C:Documents and SettingsUserDesktopEXPRESS DIPLOMA LETTER.doc)
objWordDoc.PrintOut
'quits word
objWordApp.Quit
Set objWordDoc = Nothing
Set objWordApp = Nothing
Exit_Command167_Click:
Exit Sub
Err_Command167_Click:
MsgBox Err.Description
Resume Exit_Command167_Click

End Sub

I am trying to print a letter from access when a comand butting is pressed. It returns syntax error on this line:set objWordDoc = objWordApp.Documents.Open(C:Documents and SettingsUserDesktopEXPRESS DIPLOMA LETTER.doc)

HELP!!!

Many thanks,

Dion

View 2 Replies View Related

Printing Report To PDF In Access

Oct 22, 2015

I have an Access Database installed on a server that is accessed remotely by numerous users. I have a button to print out a specific report. The problem is that in order for a user to print the report their print driver must be loaded on the server. Due to the number of users, and the numerous types of printers available, this is impractical. The current code on the button is currently:

Private Sub Command PrintReport Click()
Dim strWhere As String
strWhere ="[Property Number] = " & Me.[Property Number]
DoCmd.OpenReport "RESERVE REQUIREMENT REPORT", acViewNormal, ,strWhere
End Sub

I would like to know if there is some code that would send the report to PDF, so that any remote user could then print the report from PDF.

View 2 Replies View Related

Printing Sequence Of Access Report

Sep 6, 2004

Hi,

I have 2 single-page Access reports. The first report has the following fields:
FirstName, LastName, StreetName, HomeNumber. The second report has the following fields:
MerchantA, MerchantB, MerchantC.

The data for the first report are taken from tblBuyers, the data for the second report are taken from tblMerchandise.

I need to print 2 copies of the first report and 4 copies of the second report for the first Buyer, then 2 copies of the first report and 4 copies of the second report for the second Buyer and so on. Can I help on this problem ?
Rgds

View 1 Replies View Related

General :: Printing Reports To PDF Access Only

Jun 30, 2014

I have limited users to not show the ribbon, but I need them to be able to print of reports or export them as pdf files how do I give them access only to do this ?

View 3 Replies View Related

How To View Access Report Before Printing It

Aug 20, 2014

I have an Access program that prints various reports with a button.I would like to view the report in full screen prior to printing, how do you do this?

View 6 Replies View Related

Printing From A Locked Access Database

Mar 4, 2013

I have an .accde database that will not let my print button to work. How do I print from an .accde database?

View 2 Replies View Related

Printing Text Files From Access 2003

Mar 6, 2006

Can anyone help? I need to find a way to send text to my printer in Access 2003. All I can find is information regarding printing reports.

View 1 Replies View Related

Printing Problem With Access Versions >2000

Mar 16, 2006

Hi, this problem came out of nowhere but looks like it's here to stay.

Our Access app generates various Access Reports.
Recently we installed a new version of our access app and since that version onwards, all pc's with Office XP/2003 print reports in black & white. Printing to PDF works fine though.

We can't find the reason for this. Which mean we had to go to all our clients to downgrade them from office XP/2003 to 2000!

We use mainly Xerox and HP printers.

Thanks!

View 2 Replies View Related







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