I have a problem. I have an Access 2003 report that contains a number
of Word and Excel objects with fancy formatting and spreadsheets, etc.
I have about 20 records that I am having the database cycle through and
create one report per record (I need 20 individual PDFs for e-mailing).
When I use the 'DoCmd.OpenRepo rt "rptAnnualP kg", acViewNormal', Access
prints it before all the Word and Excel objects load and I have reports
with huge blank spaces.
Any ideas?
Thanks in advance,
Laura
1  1651 
I have an Access application which pulls data from an Excel worksheet
and pastes it into a Word document which then prints. It also inserts
an image file if there is one available for that record.
The code used to retrieve the data from Excel (and insert it into the
Word document) controls when my word document (report) prints. I can
retrieve data from a specific cell or copy an entire range of cells and
insert the data into my document. I don't have the name of the book
with me today, but I found a book on VBA and Excel as well as my Access
books that helped me to create the code I needed.
If you still want to use the Access report I am wondering if you have
code in your detail sections OnFormat property. It would seem to me
that any code in there that retrieves data from you Excel file should
hold the report from printing until the code has completed execution
(but we'll leave that from the real experts to determine).
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Ange T |
last post by:
Hi there,
I'm having pain with the VB behind an Access form. The form is used to
create reports in Excel based on the details entered in the form. This
has always worked without error on my machine (NT4, Access 2k),
however as soon as I attempt to create anything on another machine
(NT4, Access 2k) which most users will be working from, I receive an
automation error.
The problem line with the code is:
|
by: Bill Short |
last post by:
I would like to print a report (or reports) from Access based on the
Word document I have open. For instance, the Word doc I have open is
called 10-789-65.doc. From Word, I would like to open Access, and
print the reports for all records with 10-789-65 as the part number.
I've never ventured into Access from Word only the other way around.
Anyone know if this is possible?
Thanks,
Bill
|
by: Jerry Hull |
last post by:
I'm working with a database developed by an untrained person over
several years - and on a network that has recently been upgraded with
a new server installed and MS office upgraded from 2K (I think - it
might have been XP) to 2003. The database is impressive, both in what
it does and the obtuse and inconsistent ways it works. There are
several hundred queries, for example, with no indication of where they
are used or if they are in fact...
|
by: hari krishna |
last post by:
hi,
I am generating excel reports through vb.Net. After creating
excel.application and the report is generated, each report leaves Excel in
memory. I can see them in task manager in Process tab (as EXCEL). So the
memory has been taken by excel objects and memory is being full. i want to
delete or kill this objects which are in memory. i wrote the code as
'myexcel.quit()' , myexcel=nothing. but still it is in memory.
pls tell me how to...
|
by: Arno R |
last post by:
Hi all,
I need to document a database, and I do need output in Word so that I can edit the output.
I need to describe table and field structure, used objects, dataflow, workflow,
What are the options?
I can think of the 'documentor' build in Access or third party tools like Total Access Analyser (FMS)?
I tested the documentor and exported the reports as rtf to Word.
It is doable for the object descriptions but not nice to work with...
| | |
by: Doug Glancy |
last post by:
I got the following code from Francesco Balena's site, for disposing of Com
objects:
Sub SetNothing(Of T)(ByRef obj As T)
' Dispose of the object if possible
If obj IsNot Nothing AndAlso TypeOf obj Is IDisposable Then
DirectCast(obj, IDisposable).Dispose()
|
by: Inbox.Mirror.Orbisoft |
last post by:
In the last 1-3 weeks, we have had numerous users of Task Manager 2007
(www.orbisoft.com) complain that they can no longer export certain
reports (Task Manager 2007 uses a Sagekey.com Access 97 runtime) to
Excel 2003 or Word 2003 format.
They say they get an error message then both Task Manager 2007 and
Office 2003 shut down.
Any ideas why this is happening?
|
by: DeniseY |
last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it to automatically output to an Excel spreadsheet. Again, I have this part working. But the fields in the resulting spreadsheet are in a different order than the Access report. (Example: The fields in the Access report might go FirstName, LastName,Address,City--in the Excel spreadsheet, they come up...
|
by: webgirl |
last post by:
Hi everyone,
I have a weird problem with some Word/Excel automation code that I run from Access (not sure if I should therefore post this in the Access forum..? Thought I'd try here first)
Basically, the code either opens a document (if it exists) or creates it from a template if it doesn't. Docs can be Word or Excel docs.
The weird part is that the code was working earlier tonight. But now it's not, not properly, anyway. Now, what...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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,...
| | |
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...
|
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...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
