Access 97 Printing - Microsoft Access / VBA

Ancdgp

I am having trouble with printing from Access 97 on a network.

Win 98se peer to peer network
Comp A has the mdb file and the HP printer connected to LPT1

Comp B opens mdb file on Comp A and prints to shared HP on Comp A.

Comp A crashed and I installed a new hard drive and reloaded all app's and
backed up data, including the mdb file.

Now when I open the mdb file from Comp A it wants to print using the shared
network printer address that Comp B uses.

Is there a way around this problem? Can I use a different print config for
each workstation?

Thanks.

Nov 12 '05 #1

Subscribe Post Reply

1935

Tom van Stiphout

On Tue, 27 Apr 2004 16:04:04 -0700, "Ancdgp" <an**********@yahoo.com>
wrote:

Control Panel / Printers / Make your local printer the Default
printer.

-Tom.

I am having trouble with printing from Access 97 on a network.

Win 98se peer to peer network
Comp A has the mdb file and the HP printer connected to LPT1

Comp B opens mdb file on Comp A and prints to shared HP on Comp A.

Comp A crashed and I installed a new hard drive and reloaded all app's and
backed up data, including the mdb file.

Now when I open the mdb file from Comp A it wants to print using the shared
network printer address that Comp B uses.

Is there a way around this problem? Can I use a different print config for
each workstation?

Thanks.

Nov 12 '05 #2

James Fortune

"Ancdgp" <an**********@yahoo.com> wrote in message news:<10*************@corp.supernews.com>...

I am having trouble with printing from Access 97 on a network.

Win 98se peer to peer network
Comp A has the mdb file and the HP printer connected to LPT1

Comp B opens mdb file on Comp A and prints to shared HP on Comp A.

Comp A crashed and I installed a new hard drive and reloaded all app's and
backed up data, including the mdb file.

Now when I open the mdb file from Comp A it wants to print using the shared
network printer address that Comp B uses.

Is there a way around this problem? Can I use a different print config for
each workstation?

Thanks.

If you want to get under the hood take a look at:

Print Programming in Windows
Potts, Jeff
ISBN: 0-87930-585-1
R & D Books, Miller Freeman, Inc.
Copyright 2000

He has lots of sample code in both C and VB.

James A. Fortune

Nov 12 '05 #3

Similar topics

Access for Company Identification Cards

by: Lumpierbritches | last post by:

Thank you in advance for any and all assistance. I recently purchased an Ink Dye Sublimation printer and I'm looking to do something with Access for my employee ID Cards. I know I shouldn't store...

Microsoft Access / VBA

Printing a Word doc from Access

by: Stefania Scott | last post by:

I am trying to print a word document from Access. The code I've written works well in my computer but does not in the one were it is needed. Here the piece of code: 'doc path strObjectPath =...

Microsoft Access / VBA

Systemically OutPut Access Report To PDF

by: Mark C | last post by:

All, I have exhaustingly been looking through the newsgroups in search of a way to systemically output an Access 97 report to a pdf file using the full version of Adobe Acrobat. I want the user...

Microsoft Access / VBA

How do I create pdf reports from Access?

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...

Microsoft Access / VBA

MS Access

by: bborden | last post by:

I am considering writing a database program that contains text and images with an easy to use interface for my friend's dermatology physician practice. Basically Patient information that links to...

Microsoft Access / VBA

Access expoert reports to PDF using PDF writer 6.0 issues

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...

Microsoft Access / VBA

HOWTO: Automate Printing of Access Reports to PDF files

by: cyranoVR | last post by:

This is the approach I used to automate printing of Microsoft Access reports to PDF format i.e. unattended and without annoying "Save As..." dialogs, and - more importantly - without having to use...

Microsoft Access / VBA

Printing a photo from my form - Access 2003

by: Frank.Sebesta | last post by:

I have a employees database with a picture that shows on a form with employee information. Similar to the Northwinds sample database. When I print the record, my output is only the data and does...

Microsoft Access / VBA

Access not showing image on the form just the filename

by: needin4mation | last post by:

Hi, I have an Access 2002 - 2003 database. I am using Access 2003. Whenever I link an image all it shows is the filename. Not the image. Other versions of Access can link the image just fine. ...

Microsoft Access / VBA

Printing labels from Access

by: Ron | last post by:

Hi, I know Access allows for easy construction of a report setup to print labels from a table/query, etc. I've done that one. It works pretty well for what I need. However, is there an...

Microsoft Access / VBA

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

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,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp