473,583 Members | 3,563 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Reports with lots of fields not otherwise in database

As the subject above hopefully makes clear, I want to do several reports,
"with lots of fields not otherwise in database". These reports also have
variable-length text. I have defined the following options (all users have
Office 2000):
1. All Access solution. This appears to involve creating forms to enter
data that is just put into a report, and never saved - an exercise in wasted
development time, to my thinking. Also, the variable-length fields create
formatting issues. But theere are plusses.

2. Push into Word. This seems to involve the same amount of extra form
creation time, and even more coding, since each individual field needs to
have the data pushed into it. This is particularly time-consuming for a
printed five-page document made up of five forms, each with the top 1/3 page
the same identical data. This would handle variable text well.

3. Pull the info into Word using print merge. I haven't tried this yet. It
does seem to offer less coding, but I am concerned that there may be other
issues - like does it work well? This solution would alos handle variable
text.

4. I have seen somewhere that you could use software to convert the report
to a Word document post-data-import. This may help with the variable-length
text, and allow for the relatively faster coding of doing a report. But
will it require extra software?

Others must have handled this kind of issue. So far, having tried #1 and
#2, I'm not happy with either. Is there a better way?
Darryl Kerkeslager
Nov 13 '05 #1
2 1910
I don't recall ever having a requirement to put in Reports "lots of Fields
not otherwise in the database". I have done Reports that simply picked up a
few fields from an open Form into which the user had entered the information
into unbound Fields. But, every user's requirements are different.

Perhaps with more details on where you plan to display the typed-in
information, and, at least a rough overview of what is from the database and
what is typed in, we could be more helpful. If it is some Fields that apply
to the whole Report, to be displayed in the Report Header/Footer, that's one
thing; if it is some Fields to be entered separately for each Record Detail,
that's another.

I have, frankly, not had good results with formatting carrying through
properly into Word when I export as RTF ("Save as Microsoft Word"). You
would, perhaps, have better luck if you used COM Automation to manipulate
Word from Access -- that isn't "rocket science" but it does require learning
the Word object model.

On the other hand, maybe if the reports are _mostly_ user-entered
information, they would be best done IN Word, and queries used to retrieve
the information from the Access database?

Larry Linson
Microsoft Access MVP

"Darryl Kerkeslager" <Ke*********@co mcast.net> wrote in message
news:S7******** ************@co mcast.com...
As the subject above hopefully makes clear, I want to do several reports,
"with lots of fields not otherwise in database". These reports also have
variable-length text. I have defined the following options (all users have Office 2000):
1. All Access solution. This appears to involve creating forms to enter
data that is just put into a report, and never saved - an exercise in wasted development time, to my thinking. Also, the variable-length fields create
formatting issues. But theere are plusses.

2. Push into Word. This seems to involve the same amount of extra form
creation time, and even more coding, since each individual field needs to
have the data pushed into it. This is particularly time-consuming for a
printed five-page document made up of five forms, each with the top 1/3 page the same identical data. This would handle variable text well.

3. Pull the info into Word using print merge. I haven't tried this yet. It does seem to offer less coding, but I am concerned that there may be other
issues - like does it work well? This solution would alos handle variable
text.

4. I have seen somewhere that you could use software to convert the report to a Word document post-data-import. This may help with the variable-length text, and allow for the relatively faster coding of doing a report. But
will it require extra software?

Others must have handled this kind of issue. So far, having tried #1 and
#2, I'm not happy with either. Is there a better way?
Darryl Kerkeslager

Nov 13 '05 #2
"Larry Linson" <bo*****@localh ost.not> wrote
I don't recall ever having a requirement to put in Reports "lots of Fields
not otherwise in the database". I have done Reports that simply picked up a few fields from an open Form into which the user had entered the information into unbound Fields. But, every user's requirements are different.

I have, frankly, not had good results with formatting carrying through
properly into Word when I export as RTF ("Save as Microsoft Word"). You
would, perhaps, have better luck if you used COM Automation to manipulate
Word from Access -- that isn't "rocket science" but it does require learning the Word object model.

On the other hand, maybe if the reports are _mostly_ user-entered
information, they would be best done IN Word, and queries used to retrieve
the information from the Access database?


The particular report that is most bothersome to me at the moment is this:

- Five printed pages
- The header of each page consists of about 15 fields identical demographic
information that is already in the database.
- The remaining 2/3 of each page varies.
- On 3 forms, the information is mostly placing two different state names in
the proper places in the text - no big deal
- The other two pages have address information, short blocks of text,
variable-length of text, check-marks, etc, etc. There is no practical
reason for storing most of this information in the database; the chance of
it ever being used again is slim, and most of the data is of no practical
ben3fit other than to fill out this one-time paper form.

I received the forms in Word, so I left them there. The Word docs already
had form-fields placed.
So I used Word automation:

Dim mWord As Object
Set mWord = CreateObject("W ord.Application ")
Set cnxn = CurrentProject. Connection
Set rs = New ADODB.Recordset
mWord.Documents .Add oDOCS & "TransReq.d ot"
With mWord.ActiveDoc ument

For data already in the database:
.Bookmarks("off _ssn").Range.Fi elds(1).Result. Text =
Format(rs.Field s("off_ssn"), "000-00-0000")
.FormFields("se x_offender").Ch eckBox.Value =
rs.Fields("off_ sex_offender")

Other "throw-away" data was entered in an Access form, then just placed in
Word:
.FormFields("tr f_verified").Ch eckBox.Value = Me.chkVerified
.Bookmarks("trf _ver_date").Ran ge.Fields(1).Re sult.Text =
Me.txtVerDate

I didn't want to fill in the form 90% and leave the users to hunt in fuve
Word docs for the remaining fields to fill out, knowing that this would lead
to missed fields.

My complaint is that this method seems overly cumbersome - for each field, I
need a line of code to insert the data into Word, and the total fields in
the five Word docs is about 120. Contemplating 30-40 such documents (no
more 5-pagers though) makes me ask - is there a better way?

BTW, I cannot alter the document layout or data in any way.

Darryl Kerkeslager


Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2936
by: Joris Kempen | last post by:
Hi people, I know that the question has come around sometimes: How to open an Access Report using ASP and export it to for example RTF. I'm trying to implement the first method of David Cline: http://www.15seconds.com/issue/981216.htm
1
3323
by: Richard Hollenbeck | last post by:
Hello Newsgroup. You have all been very helpful in the past and I thank you. I try to ask relevant questions so that they don't just benefit me, but also benefit the group. I'm currently overwhelmed by useless examples across the web on how to make "dynamic crosstab reports" without myself having a basic understanding about how to retrieve...
4
1647
by: sparks | last post by:
We have a database that reads in and formats raw data. We were using queries to format the data per person and outputing reports. The other database has the persons personal information. I changed the queries on the raw data to maketables, copied the reports into the personal info database and they have the reports from the raw data available...
7
8841
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...
5
4017
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...
11
6578
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...
1
7713
by: warlord | last post by:
In order to save typing, I've borrowed the text from a post of nearly 12 months ago.....but the problem still exists. I've been banging my head all day with this, so I'm hoping someone has some suggestions for me: I'm trying to either print or export some Crystal Reports in asp.net web application. The reports were made with CR 9.0, get...
7
10125
by: greywire | last post by:
So I need to load lots of data into my database. So I discover LOAD DATA INFILE. Great! This little gem loads my CSV in blazing times (compared to parsing the file and doing INSERT for each row). Its still slow on large files, but just barely acceptable. Only one problem. It truncates fields to 256 characters, even on a text field.
6
4135
by: Josetta | last post by:
Access 2003 I've been experiencing some problems with my "monster" database the last couple of days. I imported all objects into a new database yesterday, which pretty much stopped the crashing problems, but here's something weird: Whenever I copy an object (reports so far), I am able to open it and make changes, but when I try to save it...
0
8172
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. ...
0
8320
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...
1
7929
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5697
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5370
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...
0
3814
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...
1
2328
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
1
1424
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1152
bsmnconsultancy
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...

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.