Over 1 million tech questions and answers.

Access 2003 : Word Docs inside an Access Report

Q: Access 2003 : Word Docs inside an Access Report

I've read postings from OBP, Cristobal and others about the down sides of OLE, how it bloats a database and so forth. With that under my belt, I nevertheless have a need to inlcude Word docs in the Reports created by my Access 2003 database.

The spec is as follows:

The application is to provide a sales quotation tool. Users will add a quote by choosing the customer, adding parts to the quote and choosing pricing mechanics, Thats all easy to do and in fact is nearly complete. The user can then, by selecting one or more tick boxes, choose from a range of pre-formatted product literature which will be included in the output quote that is created as a report (then spooled to PDF). The pre-formatted product literature content is not needed to be visible in the form.

The product lit files are Word docs.There are about 30 or so of these different Word docs and they are stored on a central server (same path for each doc), so I see no problem in having a table containing the filenames as text file names with full paths.

So, when the report is run, the quote is produced, with full pricing and ALSO with the chosen word documents in all of their glory.

What is the best way to do this? Can it even be done at all?

Suggestions on a post card!

Chris

RELEVANCY SCORE 200
Preferred Solution: Access 2003 : Word Docs inside an Access Report

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Access 2003 : Word Docs inside an Access Report

Read other 9 answers
RELEVANCY SCORE 101.2

Hi there

I am using Access 2003 and have 200 clients I am adding field names and data types at present to set-up a database and want later on to be able to use the sub-form in forms to up-load each individuals personal word .doc CV to there personal sub-form record. Do I set this early on in data type or field properties or use OLE to look up there record on the server depending on the clients name or automated client number? If so how exactly can I do this if it can be done. I only have basic college knowledge of Access so do not know any programming. I realise this can be done in Excel but my boss wants if possible to have the information at hand in a sub-form personal record ready possibly by accessing it via a control button so once clicked the CV will appear for that client and every client once viewing their record details.

Thank you
 

A:Access 2003 how do i Add personal word docs to data type or field properties

Read other 6 answers
RELEVANCY SCORE 100.4

I have created a report in Access 2003 which shows each customer's invoice on a separate page. I want to transfer this to Word 2003 so I can use the mail-merge facility to email it to customers. However, when I use the Office Links icon & select Publish It with Microsoft Word (the only option for reports) it puts all the invoices simultaneously into the document rather than retaining the separate pages.

Does anyone know a way around this, please.
 

A:Access 2003 Publishing report to Word

Read other 7 answers
RELEVANCY SCORE 91.2

HOW DO I CONVERT AN ACCESS 2003 REPORT INTO AN ACCESS 2007 REPORT?
 

Read other answers
RELEVANCY SCORE 85.2

Here's a rundown of my issue:

Last night, I had two Word files opened that are contained in my USB drive. Unfortunately, the program froze. Other programs began freezing as well, and so I decided to restart my computer. However, when I loaded up my computer again (Windows 10), the USB would not be recognized.

I inserted the USB stick into my laptop (Windows 7), same problem, except it recognized a removable disk (F) with no media. I also encountered the same result with another computer (also Windows 10). So my USB drive was damaged internally.

Does anyone know what steps I can take to retrieve my files? I don't care about this USB drive anymore, I just need my Word docs. I wish I could offer more details about the drive I'm using. It's a signature thumb drive of some company (which provides databases for researchers).

Any assistance would be greatly appreciated.
 

Read other answers
RELEVANCY SCORE 85.2

Hi All! I have a form where the user can select several Word docs to print (using a Y/N datatype. Once all the selections are made, I want the user to be able to click the cmdButton and print all the selected docs at once. I have the following but it only prints the active Word doc. Can someone give me some direction please.
Private Sub cmdPrtComSheets_Click()
Dim wrd As Word.Application

Set wrd = Word.Application
wrd.Visible = True
If Me.Ctl001 = True Then
MsgBox "Word is printing your document."
wrd.Documents.Open FileName:="S:\PUR\COMMON\FRONT DESKS\vendor\Commodities\Comm001.doc"
ElseIf Me.Ctl002 = True Then
wrd.Documents.Open FileName:="S:\PUR\COMMON\FRONT DESKS\vendor\Commodities\Comm002.doc"
wrd.ActiveDocument.PrintOut
Do While wrd.BackgroundPrintingStatus <> 0
DoEvents 'Let Word print the document
Loop
wrd.Quit

Else
MsgBox "There are no documents to print"
End If

End Sub
 

A:Access 03 - VBA Printing Word Docs

Read other 16 answers
RELEVANCY SCORE 84.4

Well it seems like I encounter the strangest problems.
My environment is Windows 98SE
I've used WORD extensively and EXCEL occasionally.
Then today I could not open a document for either program, nor could I activate the programs. I received an Illegal Operation message, followed by a Restriction error message:
"This operation has been cancelled due to restrictions in effect on this computer." Surprise!
Everything else seems normal on the computer (Gateway SOLO 9300 laptop with big specs). No problems with internet access, nor running other large programs.
Has anyone out there encountered this error? How do I find out what these supposed "restrictions" are, and how to get rid of them.
Thanks for any suggestion. This is a great site.
Charles
 

A:Suddenly cannot access WORD or EXCEL docs

Read other 8 answers
RELEVANCY SCORE 81.6

Hi all,

I'm using Access 2003 and I'm generating a report.

1) I'm taking a number data type field and I want it to display 5%. But everytime I enter 5, it'll display 500.00%, instead of displaying 5%. It's already like that when I entered into the table.

2) How can I display (5%*variable) and always display the result in bracket to indicate that it's a negative number?

Thx!
 

A:Access 2003 Report Problems

Read other 14 answers
RELEVANCY SCORE 81.6

Hi,

I have a report in Access 2003 that I am basing off of a query. I would like to use grouping in the report. For some reason, when I open the grouping box, not all the fields show up from the query. Does anyone know why this is?

Thanks,
 

A:Solved: Access 2003 and Report

It may be that some fields do not contain the correct data structure to be able to be used for grouping.
 

Read other 3 answers
RELEVANCY SCORE 81.6

I have created a report in Access 2003. I would like for the report to display the data in columns. I have went to File -> Page Setup -> Columns Tab. I changed the number fo columns to 2, but when I view the report there is still only one column an dthe remaining data is not visible.

Does anyone know how to fix this issue?
 

A:Solved: Access 2003 Report

Did you set the column widths?
 

Read other 3 answers
RELEVANCY SCORE 81.6

Hi guys,

i'm using access 2003, i have 107 forms filled out but i want to email 1 single form to my boss. I've setup a macro using the sendobject command but that emails him an html doc with all forms in it. Any ideas?
 

A:Access 2003 Emailng report

If you use a Command Button with VBA to send it, it is quite simple
Look at the VBA Editor's Help for Domcd.sendobject
 

Read other 3 answers
RELEVANCY SCORE 81.6

Hi,

I have a Vat Report and a Turnover Report. On each report i need to get the total but i keep getting #Error.

I created a text box in the reports footer and set the control source to =Sum([Vat]) an changed the running sum property to over all but i keep getting #Error

I have looked everywhere but cant seem to get it working, i hope one of you will help me out.

Thanks in advance.
 

A:Solved: Access 2003 Report Help

Read other 6 answers
RELEVANCY SCORE 81.6

Hi,

I have just created a query to feed data to my report. The query consists of;

Orderdate Between [start date] and [End Date]
Orderid
Ordertypeid [Enter Order Type ID]
Goodstotal

This works fine but i need all 3 order types to be in 1 report but each id seperate. The ID's are:
1= Postal
2= Telephone
3= Web

Could anyone help me with this please? Any help will be appreciated.
 

A:Access 2003 Report/Query Help

Read other 9 answers
RELEVANCY SCORE 81.6

I have a report that is displaying a number field. I want to sort on the report by the numbers, but the sorting is not working properly.

For example, I have numbers: 1,2,3,4,5,6,112,200. Here is how the report is sorting the numbers:

1
112
2
200
3
4
5
6

Why will it not sort in a series?
 

A:Solved: Access 2003 Report

Read other 16 answers
RELEVANCY SCORE 81.2

I am sure that most readers of this post will have experienced the situation where an Access report is saved as an RTF file and opened later in Word only to find that some of column widths do not come out the same. It appears as though some strings of characters come out wider (or narrower) in Word than they do in the open report.

I've had this happen often but now I'm being called upon to actually do something about it. Any suggestions for making the Report and Word versions look more alike? (And no I, cannot use a fixed-space font.)
 

A:MS Access Report Looks Different in Word

Read other 11 answers
RELEVANCY SCORE 80.4

Hi;

I need to prepare a list of registration code for my students. The code will start with MA233 and followed by three digits number starting with 001. So the registration code will be MA233001, MA233002, MA233003 and so on.

What I did so far is I made a label with caption MA233 followed by text box. I used the same method of numbering a report list with initial number of =001. However the number automatically change to =1.

FYI, the code is not being used in the database but only in the report. So I hope anyone here can help me how to make it possible on the report.

Thanks in advance.
 

A:Access 2003: Need help on how to numbering a report list

The autonumber is a numeric value and your wanting to present as text to display leading zeros. This can be accomplished by something like this.
RegistrationCode: "MA233" & Format([autonumber],'000')
 

Read other 1 answers
RELEVANCY SCORE 80.4

Hi,

is there a way of saving a report as a PDF? I need to do this because i need to email the client the invoice in PDF format.

Can this be done in access?
 

A:Solved: Access 2003 saving a report as a PDF

Read other 7 answers
RELEVANCY SCORE 80.4

I am trying to get the report in Access 2003 to open maximized and at 100%.

If I use the code:
Code:
DoCmd.Maximize
The report opens maximized as it should be with a property of 'Fit".

I tried use the code...
Code:
DoCmd.RunCommand acCmdZoom100
but I get the following error message "The command or action 'Zoom 100%' isn't available now."

All the codes have been entered in the Report_Open event procedure.

Any suggestions?
 

A:Solved: Access 2003 and Open Report

Read other 10 answers
RELEVANCY SCORE 80.4

Hi. I have built a parameter query and constructed a form and a report based on that query, so everytime I open one of those, access prompts for that parameter, a date to be more precise. The form is designed to show me some records for that specific date and to offer me the posibility to send the report for that specific date attached on an email, by clicking a "send report" button. My problem is: how can i pass that specific date to the report in VB code so that Access doesn`t prompt me again for the parameter (date) when I click the "send report" button. It should use the date I already typed in to see the form.
 

A:Solved: Access 2003 Report parameters

Read other 11 answers
RELEVANCY SCORE 80.4

I added a report to the switchboard manager in Access 2003. The report does not open at 100%. How can I make the report open in 100% view?

A:Opening a report in 100% view - Access 2003

I moved this to Microsoft Office Support -they should be able to help more

Good luck,

-Coolfreak

Read other 1 answers
RELEVANCY SCORE 80.4

Does anyone know if it is possible to setup an Access 2003 database to e-mail a report automatically at the end of the month if records have been added?
 

A:Solved: Access 2003 and E-Mail Report

Read other 16 answers
RELEVANCY SCORE 80.4

The title says it all. I'm trying to draw circles in an Access 2003 report. I can draw rectangles, but not circles.

Thanks in advance for your help!

Pete
 

A:Want to draw a circle in Access 2003 Report

Read other 6 answers
RELEVANCY SCORE 80.4

I am very new to access. I have created a single table. About 150 rows, all looks well. I created a report using the report wizard. Nothing fancy just print all the reconds (all the fields). First 100 records look wonderful. Then no more records in the report.

There must be some control somewhere that I have accidentally set or is on by default. Can anyone point me in the right direction?

Thank you!
 

A:Solved: Access 2003 report limit

There isn't any limit, is there more than 1 page?
 

Read other 2 answers
RELEVANCY SCORE 80.4

Does anyone know if there is a way to have Access e-mail a report at the end of the month on the last working day of the month (Monday - Saturday)?
 

A:Solved: Access 2003 E-Mail Report

Read other 8 answers
RELEVANCY SCORE 80.4

Okay, I'm working on a report now, to view a mileage report of each of my vehicles.

The Form that I'm basing this Report on is simple. It has the AutoNumber/Key, one text box for the vehicle ID, two text-boxes for beginning and ending odometer reading, a text-box to input all mileage in my home state (TX), and subform with a combo box to input other states travelled through and a text-box to input the number of miles in each of the states. Simple.

I'm now creating a report that will report on each truck, the different trips that each truck has made, the OD reading of each truck... THEN I have a list of all 50 states. The idea is to have the mileage that was reported on each state, via the combo boxes, and have them fill the appropriate amount of mileage in the itemized report. So, my confusion is how to build an expression in the "text-box/properties/control source" to extract the mileage from the right state.

For each trip, there will be several states with the number zero. For example Hawaii: I'm very much aware that none of my trucks will ever drive to Hawaii. BUT, I put it on my report/form, just for the thoroughness and just for kicks.
I don't know if I'm making sense.
 

A:Access 2003: Report Expression Builder

Read other 7 answers
RELEVANCY SCORE 80.4

HI. I can`t find a way to repeat a record in a report for a given number of times. I have a basic Order form and for every product ordered i want to create a shippment label. So .. i have product A in a quantity of .. let's say 50 units. I need to create a report that reads the quantity ordered and generates 50 labels for that product, arranging them on the page. ( I don`t want a label on each page). Can anyone help?
 

A:Access 2003 Repeat Record on Report

Read other 10 answers
RELEVANCY SCORE 80.4

I know my way around Access enough to create simple things, so I need some help with a report.

I have a database to track employees along with their hours worked, hourly rate, along with mileage and mileage rate. I have one table with the employee information only. I have a second table with the information for each week where the information is entered for hours worked, hourly rate, mileage and mileage rate.

I have two reports setup so that I can run a summary report showing all information by each employee, sorted by week end date. I also have another report based on just a summary of YTD wage total for each employee.

I don't know if this is even possible, but I would like to be able to, through a switchboard, to be able to have a detail report run on one employee only. Ideally I don't want to go in and set up a report for each person because the people change. Is it possible to use a combo box somehow so that when you select the employee's name, the report is generated for that employee and to be print only? And have that through the switchboard?

If this is confusing I will try to make more sense, or provide additional information.

Thanks!
 

A:Solved: Access 2003 Report by Selection

There are many ways to do this.

One of the simplest would be to set up a swithcboard form as you've suggested
let's call the form"

fEmpReportSwitchboard

Now on this form, you can place buttons for running all your reports.

Now on this report you put a combo box from which you choose tht name fo the employee. Lets name the combo box:

cboEmployeeName

Now take your existing report that currently runs for emm employees and make a copy of it that will be used to run for just one employee only.

In the regular report (for all employees) the data source might be something like
SELECT [tEmployee Data].[Emp Name], [tEmployee Data].[Emp ID], [tEmployee Data].[Emp Department], [tEmployee Data].[Emp Etc]
FROM [tEmployee Data];

Now in the copy that you want to run for just one employee, you introduce a where cause in the data source that uses as its criterion, the value of the cboEmployeeName combo box:
SELECT [tEmployee Data].[Emp Name], [tEmployee Data].[Emp ID], [tEmployee Data].[Emp Department], [tEmployee Data].[Emp Etc]
FROM [tEmployee Data]
WHERE
((([tEmployee Data].[Emp Name])=
[Forms]![fEmpReportSwitchboard]![cboEmployeeName]));

See?

Note that if you try to run the report when the fEmpReportSwitchboard form is not open, you will get an error.
 

Read other 3 answers
RELEVANCY SCORE 80.4

Hi again team

I have one report layout but, depending on option boxes selected in the loading form, I wish to base the report that is displayed on one of a number of queries (or SQL statements). I'd rather not have a load of reports!!

Is there a way to do this? All I need is the syntax for the DoCmd.OpenReport ..... command so that I can plant it in a Select Case Statement.

Not found anything around this idea so far so hope someone can help?

Thank

Chris
 

A:Solved: Access 2003 - One report - many queries

Read other 6 answers
RELEVANCY SCORE 80.4

I have a form letter that I send out each month to parents of my students.
How can I make this a report in my database and have the info drawn in from the database (ie..students, name, date of birth, etc) Each of these fields are in my database
 

A:word documnet in access report

Read other 10 answers
RELEVANCY SCORE 79.6

Hi All,

I have a DB which has two reports which can be run depending on whether it is a single site or multisite.

I have added a yes/no tick box to show if a multisite, but what i need to do now, is to get access to run the correct report.

If Multisite not ticked to run Report A
If Multisite ticked to run Report B

I dont know enough about VBA to do this so any and all help would be helpful.
 

A:Solved: Access 2003- Report/Query (guessing VBA) Help

Read other 10 answers
RELEVANCY SCORE 79.6

I know that if anyone can do this, the intelligent members of this forum can do it. I have a number of people, who I am responsible for, that have appointments almost every day. I would like to have a report on my switchboard that gives me a list of appointments for the next few days. Is something like this even possible and how would I go about doing it. Thanks for your help.

-Josh
 

A:Solved: Access 2003 - Display a report on a switchboard

Josh, when you say "on your Switchboard", do you mean a Button to open a Query, Form or Report that shows appointments?
Next question is "Who's" appointments?

To answer your question, Yes of course it can be done.
 

Read other 3 answers
RELEVANCY SCORE 79.6

I have an inventory db... I'm attempting to have an image of each product load in a report upon viewing the respective record.

So far, I have it working correctly on my Forms... I used the code from the sample DB in this post.

However, I copied the Image1 from the sample DB report to my report and the image doesn't show. What am I missing? I checked the properties of the report in the sample DB and there's no extra code there.
* Edit - I edited my initial post because I realized the sample DB I linked to possessed a report as well.
 

A:Access 2003: Load Images In A Report For Each Record

Read other 11 answers
RELEVANCY SCORE 79.6

Hey everybody

I have created a report. For the record source, I have it pulling only records where their Active Status is "In-active". That works great.

I need to have it where when someone pulls this report, they can then do a search for certain dates. There are about 4 date fields on the report.

For example, if someone pulled up the report, and they needed to pull up a list of these agents that their Contract Mail date was between 4/11/2006 and 4/25/2006.

Is it possible to do this, to where they can put whatever criteria they need?
 

A:Solved: Access 2003 - How to search by criteria in a report?

Read other 16 answers
RELEVANCY SCORE 79.6

Hi Guys
Need a little help here.
I am using access 2003.
I have created reports which draw their information from queries.
Most of these reports need to be sorted according to alphabetical order of surname.
The queries all sort correctly as specified by my criteria, however the reports do not. Is their a way to add sort criteria to an existing form.
I realise it is helpful if I post a copy of my database but all the information is confidential and the thought of putting fake information scares me
Thanks
Cara
 

A:Solved: Sort criteria for access 2003 report

Read other 7 answers
RELEVANCY SCORE 79.6

I am trying to find a way to remove/hide/disable the "Restore Window" button on an Access 2003 Report.

I found the following code

Code:
Type Rect
x1 As Long
y1 As Long
x2 As Long
y2 As Long
End Type
Declare Function IsZoomed Lib "user32" (ByVal hwnd As Long) As Long
Declare Function ShowWindow Lib "user32" (ByVal hwnd As Long, ByVal _
nCmdShow As Long) As Long
Declare Function MoveWindow Lib "user32" (ByVal hwnd As Long, ByVal _
x As Long, ByVal y As Long, ByVal nWidth As Long, ByVal nHeight _
As Long, ByVal bRepaint As Long) As Long
Declare Function GetParent Lib "user32" (ByVal hwnd As Long) As Long
'Use following instead of GetWindowRect
Declare Function GetClientRect Lib "user32" (ByVal hwnd As Long, lpRect _
As Rect) As Long

Public Const SW_MAXIMIZE = 3
Public Const SW_SHOWNORMAL = 1

Sub MaximizeRestoredReport(R As Report)
Dim MDIRect As Rect
' If the form is maximized, restore it.
If IsZoomed(R.hwnd) <> 0 Then
ShowWindow R.hwnd, SW_SHOWNORMAL
End If
' Get the screen coordinates and window size of the
' MDIClient area.
'This is the line which is different
GetClientRect GetParent(R.hwnd), MDIRect
' Move the form to the upper left corner of the MDIClient
' window (0,0) and size it to the same size as the
' MDIClient window.
MoveWindow R.hwnd, 0, 0, MDIRect.x2 - MDIRect.x1, MDIRect.y2 -... Read more

Read other answers
RELEVANCY SCORE 79.6

Hi!

I'm pretty much a newbie in Access, it's been years and it's gone totally out of my head. I've done alright setting up an intital database, but the scope of the project has grown more and more complicated and I'm having trouble keeping up.

Due to the large number of total fields associated with this database, I have created 5 seperate tables in which to house the data collected. I need queries which will pull information from all the databases, sort results alphabetically and then link to a report.

Here's what I need to do. User comes in through the switchboard, is provided the option to run a form titled something like "Find by Product Manufactured". He would select the kind of product he would like from a pull-down menu AND be given the opportunity to hand enter a value as one of those choices. He would click "Run" and the report would pull the desired information.

Right now, the product types are entered as True/False values (or nulls) in 19 fields, viewable in forms as a checkbox, the 19th field being an "Other" text field with hand entered text from clients. I would really, REALLY like to do this in some other way than creating 19 seperate queries showing all data based on one field - please tell me there is another way?

(I also have no idea, although I have read your tutorials, how to get the pull-down menu to show up in the first place)

HELP HELP HELP!!! This seems like a complicated request, thoug... Read more

A:Access 2003 Switchboard/Report/Query Dilema

Read other 16 answers
RELEVANCY SCORE 79.6

I have 3 queries that are run by entering a date range. I would like all three queries to be on a single report. I believe it is the date range that is stopping my report.
Can you help me?
 

A:Creating A report multiple queries in access 2003

Read other 16 answers
RELEVANCY SCORE 79.6

I'm creating a report based on queries that will list, say, total hours per consultant. To get a timeframe from the user, I made an unbound form, and put
Code:
Between [Forms]![frmDates]![cboStartDate] And [Forms]![frmDates]![cboEndDate]
in the query criteria so that it prompts them for the date range. So far so good.

However, my issue is that I'd like to add the results of more than one query to a single report, and only have the user prompted one time for the date range. So one rpt would have hours per consultant as well as hours per project, etc.

I would think that if the above-listed code were in the criteria of both queries, it would prompt for the date range twice, but when I try to build a report from more than one query, it says I can't do it anyway, giving me the error:

"You've chosen fields from record sources wizard cannot connect. You may have chosen fields from a table and from a query based on that table. If so, try choosing fields from only the table or only the query."

However, the sources are from two queries, so...
 

A:Solved: Access 2003 report w/ date range

Read other 7 answers
RELEVANCY SCORE 79.2

Hey,

In my vb code, i did like to automate opening a report , the report takes information from a table in my db and graphs the info into a bunch of graphs. when the user click a bttn i would like to open the report in word with the graphs shown.

(In the report view in access, when i clicked the 'print to word' bttn manually the report output the information in word without the graphs)

for starters i simply wanted to open the report and the code that i wrote ended up sending the report to the local printer ..
Code:

DoCmd.OpenReport "StaubGraphs", acViewNormal, , , acWindowNormal
Thanks for any help in advance.
 

A:Solved: Output access report in word or pdf??

It has always been like that when converting to WORD, not sure about the newser versions of ACCESS? But you can specify the report to print to a specific printer in page setup....choose your PDF printer. The only draw back is you have to save a filename.

I'm pretty sure there are other ways, but I have never explored them.
 

Read other 3 answers
RELEVANCY SCORE 79.2

hi guys,

this is my situation:

1. I created an application form using MS Access (reports).
2. I want to convert this to a word document, is this possible.

Reason: I want to post the application form over my website and make it downloadable.

If not, do you have any suggestions.
thanks
 

A:help in converting access report to word dcoument

Use the OutputTo method:

DoCmd.OutputTo acOutputReport, "Employees", acFormatRTF, "Employee.rtf", True
 

Read other 2 answers
RELEVANCY SCORE 78.8

please help!
i installed office pro 2003 (windows xp)
and i cant create a new report (it start one, but wont save it)
if i try to create a form with the wizard, it wont save it .

what is worng??
 

A:Solved: access 2003 can't create report or form from wizard

Read other 16 answers
RELEVANCY SCORE 78.8

I have a form that on the click of a button opens a report and keep doing some background work.

When the report previews, the form seems to go automatically on design view, so the operations to be performed on the background stop, and a message appears, indicating that nothing can be done, because the form is on design view.

If I send the report straight to the printer (normal view) then all works fine, but if there is an error on the report, there is no way to catch it until after it prints.

Is there a way to keep the report on preview and the form on form view, so everything wil work smooth as it should?

I do greatly appreciate your answers.
 

A:Solved: Access 2003: Form design and report preview

Read other 7 answers
RELEVANCY SCORE 78.8

Hi Group

I've got a problem in an Access 2003 report, trying to embed a chart.
If I just wanted to chart based on a field for ALL records in a query or a table it would be easy. But it's not quite that straight-forward.

Imagine this scenario ...
I have a report which groups records into blocks, and there is a summary value in the footer of each grouped block; the detail records are hidden so only the summary footer for each block is visible. Further, let's assume that this summary value field I want to chart is a 'derived' field, like '=Max([Attempt Start Date])'; i.e. I'm only showing the highest date in the preceeding hidden block of records. This summary value isn't in the table or in the report's underlying query; it only really exists in the report and is calculated at runtime. This is pretty standard Access reporting faire.

My problem is that I can't see how to include the 'derived' summary footer value into the chart. As I wrote at the top of the post, I could easily chart a value in the report's query or the table, but I can't see how to chart a value that is calculated on the report itself.

Any clues would be gratefully received.

Thanks.

PeteB
 

A:Solved: Charting A Report Group Summary Value In Access 2003

Read other 9 answers
RELEVANCY SCORE 78.8

I've created a couple forms, that will work harmoniously in creating awesome reports.
One of the forms is used to log all of the miles travelled by several different drivers through various states. So the driver's form has two lines to fill out. One is a combo box with all of the states listed so he can slect one, then in the next blank he can input the number of miles travelled in that state. Then, if necessary, he can select the next state and how many he travelled there. I can create a complete total, that's wasy.

I need to build an expression that isolates the total of just one or two states.

I'm not experienced in writing code, so if I need to, please be specific.
 

A:Solved: Access 2003 Expression building filter for a report

Read other 16 answers
RELEVANCY SCORE 78.8

Hi,

I need to generate a report by letting user select the month and year (From and to) using a combo box. After that, the input is used to produce a report with calculated fields.

E.g.: The user want the report from Jan 2007 - Jan 2008. After he/ she select on the 2combo boxes, it takes the fields from the table and perform calculation before presenting it as a report.

How can I do that? Must I use form or report? Any references or sample I can refer to?

Thank you!
 

A:Access 2003 Report (Allow user input & perform calculation)

Use a form with the fields you want to base the report on and a submit button that will fire off the report using those parameters. You will need to code the button using some VBA to pass those parameters to the report.
 

Read other 2 answers
RELEVANCY SCORE 78

Hey everybody

A report that I have in access messes up when I export it as an Excel spreadsheet. I export it, and then go to open the excel file. When I open the file up, I get the error message "File error. Some formats may have been lost."

When this happens, I look at the excel file, and the some of the dates I have are numbers like "38848". The dates should be dates like 5/25/2006.

The odd thing is, all the dates aren't messed up. Any ideas on what is going on?
 

A:Solved: Access 2003 - Exporting Report to Flash causes Formatting loss

Hey smooth, for an explanation of the dates turning into numbers, check my signature (Access Dates and Access Date Conversions both have info). I don't know why it would happen with only some, but there must be a common trait among the dates that get swapped.

chris.
 

Read other 3 answers