Over 1 million tech questions and answers.

Access 2003 report to access 2007 report

Q: Access 2003 report to access 2007 report

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

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Access 2003 report to access 2007 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.)

RELEVANCY SCORE 115.2

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
 

A:Access 2003 : Word Docs inside an Access Report

Read other 9 answers
RELEVANCY SCORE 109.2

I am trying to make a report in access 2007 but I need a little help. I want the report to only have entries that have a particular answer. I have a field that asks "Dues paid?" with a combo box that has the answers yes and no. I want the report to only list the people with the answer no. How do I do that? Thank you!
 

A:Access 2007 Report Help

Supply the report's data using a Query, in the query's Criteria row for the "Yes/No" field enter 0, that is a zero.
Queries normally use -1 for yes and 0 for no.
 

Read other 1 answers
RELEVANCY SCORE 109.2

If I have a description (memo) type field on a report. Is there a way to have the field auto expand based on the contents of the description field?
 

A:Access 2007 Report

You need to set both the Details Section to "Can Grow to Yes" and the Memo Field as well.
I would also set the Can Shrink to yes as well.
 

Read other 1 answers
RELEVANCY SCORE 109.2

Hi im having a little problem hopefully someone can help me.

I have a form, it has a subform in it. In the form i have a drop down box where i pick a client and the form and subform filters based on the client picked. In the main form i also have textboxes, that show numbers based on the client picked.

I like to have a button in the main form, that when i click it, i want it to take all this information (main form and subform) and show it in a report like an invoice.

Please help
Thank you
 

A:Access 2007 Report. Help

Read other 6 answers
RELEVANCY SCORE 108

Good morning. I found this forum this morning and I hope someone can help me out. My company is looking for a report that will list purchase orders and invoices paid against them. The PO amounts and invoice amounts are housed in the same table but in separate columns. There are multiple invoices paid against every PO. In order see which invoices were paid on each PO, there is a column for PO number. The PO number gets entered in on every line. I have tried to set up a query that will deduct the invoice amount from the PO. The problem I am running into is when the query runs the PO amount pulls in for every time an invoice is paid against it. For example PO123 is $30,000 and the following invoices are paid against it: INV 3 - $5,000, INV4 - $5,000 and INV5 - $5,000. The query will return $90,000 for the PO amount and a cumulative total for the invoices of $15,000. What do I need to do? Any help would be greatly appreciated. Thank you.
 

A:Solved: Access 2007 AP Report

Read other 16 answers
RELEVANCY SCORE 108

Hi All,

I'm having difficult getting a VBA report filter to work.
The code is based data within a form.

I can get the data filter to work properly but I can't get the combo box part to work. I just get "Error 438"
I could really use some help.

Here's the code....
Private Sub Preview_Click()
On Error GoTo Err_Handler

Dim strReport As String
Dim strDateField As String
Dim strFilterLevel As String
Dim strWhere As String
Dim varWhere As Variant
Dim lngView As Long
Const strcJetDate = "\#dd\/mm\/yyyy\#"

strReport = "Members Detailed"
strDateField = "[Member Entered]"
strFilterLevel = "Account Level"
lngView = acViewPreview

If Me.cboFilterLevel > 0 Then
cboFilterLevel = varWhere & "Account Level = " & Me.cboFilterLevel & "AND"
End If

If IsDate(Me.txtStartDate) Then
strWhere = "(" & strDateField & " >= " & Format(Me.txtStartDate, strcJetDate) & ")"
End If
If IsDate(Me.txtEndDate) Then
If strWhere <> vbNullString Then
strWhere = strWhere & " AND "
End If
strWhere = strWhere & "(" & strDateField & " < " & Format(Me.txtEndDate + 1, strcJetDate) & ")"
End If

If CurrentProject.AllReports(strReport).IsLoaded Then
DoCmd.Close acReport, strReport
End If

Debug.Print strWhere
DoCmd.OpenReport strReport, lngView, , strWhere

Exit_Handler:
Exit Sub
Err_Handler:
If ... Read more

A:Access 2007 VBA report filter

Read other 11 answers
RELEVANCY SCORE 108

Hello,
I am trying to narrow fields by Month, Quarter, and Year for several reports. Month and quarter work, but for some reason, when I try to set my dateEntered criteria for Year I do not receive any results. Here is what I am using so far for the dateEntered field criteria:

Month:
Between [Forms]![Individual Time Card Report Form]![Combo15] & "/01/" & [Forms]![Individual Time Card Report Form]![Text19] And [Forms]![Individual Time Card Report Form]![Combo15] & "/31/" & [Forms]![Individual Time Card Report Form]![Text19]

Quarter:
Between [Forms]![Individual Time Card Report Form]![Text29] & "/01/" & [Forms]![Individual Time Card Report Form]![Text34] And [Forms]![Individual Time Card Report Form]![Text32] & "/31/" & [Forms]![Individual Time Card Report Form]![Text34]

Year:
Between "1/01/" & [Forms]![Individual Time Card Report Form]![Text25] And "12/31/" & [Forms]![Individual Time Card Report Form]![Text25]

The text boxes refer to user input from an already open form (which works fine for Month and Quarter) What am I doing wrong with year? Or is there an easier method for searching for only records from a specific year? Thanks
 

A:Access 2007 Report Query

Read other 15 answers
RELEVANCY SCORE 108

Hi, I have are report which displays results from a search that includes all of my tables.
I am currently testing the report and upto now it is displaying the correct results but is repeating them.

For example, a search i am running should return two results, but is repeating them over and over.

Any help would be great.

cheers
Lewis
 

A:Repeating Report in Access 2007

Read other 12 answers
RELEVANCY SCORE 108

I have a query that pulls the data I need from some tables. I built a report based on that query. Now I want to create another report using the same query, but filtered by criteria in 1 filed. Can I do this without creating another query? Nothing I put in the data tab of the properties window seems to work.
 

A:Access 2007 - Report Filter

I am not sure why you don't want to just copy the Query & report.
But as you don't you could try adding this to the 1st Criteria Row of the Field you want to filter
Like "*" & [Input Selection] & "*"
When you leave the Input message box blank it will sho all the records.
Even better is to have a form with a Combo box to make the filter selection with, as that prevents typing errors.
 

Read other 3 answers
RELEVANCY SCORE 108

I am using Access 2007. I created a report and added my fields now I want to change how they appear - move them around on the form. When I click on one and move it it brings the whole line with it. What am I doing wrong? Thanks
 

A:Access 2007 Report Design - Help!

Carla, is it a Report or a Form?
I do not have Access 2007 so I can't really help you directly.
 

Read other 2 answers
RELEVANCY SCORE 108

Is there a way to send a report automatically from Access 2007 via Outlook 2007 to someone at a certain time - let's say 11:00 pm - without having to open the application or Outlook. If not, what is the best way to automate the process so the report is emailed automatically at a certain time during the day without user intervention? Thanks
 

A:Automate a Report from Access 2007

Read other 10 answers
RELEVANCY SCORE 108

I have created a report in Access 2007. The table that the report is based off of does not have any duplicates. However, my report is showing multiple duplicates. My report is grouped by Provider Name with a title header. Then in the detail section of the report I have the following fields: Measure, Member name, Member ID, Address, City, State, Zip. Since the report is grouped by provider, the member could have different measures listed by their name. In which case, I would expect to see them on the report more than once. However, the report is currently showing multiple members for the same measure; therefore, resulting in duplicate information. How can I get rid of the duplicates in the report?

Thanks,
Tonya
 

Read other answers
RELEVANCY SCORE 108

I am trying to design a Access Report using Access 2007. I find that the report defaults to 22". I've tried to change this, but Access will not allow me to do this. How do I change the height to around 35"?

Dennis Gehris
 

A:Access 2007 Report Setup

Read other 8 answers
RELEVANCY SCORE 108

I have a Access 2003 application which has many reports.

When I am using 2003 and in the report view right clicking the mouse is giving me options one on that is "export" where I can export the report to Excel, DBF, CSV etc.,

But this feature is not available when I try my application using Access 2007

Any help please?
 

A:MS Access 2007 Report Export not there

Maybe I'm missing something, I created a dummy report>>right clicked and got these options....(see attached)
 

Read other 3 answers
RELEVANCY SCORE 108

Dears,I have designed a database with many reports of certain importance. basically a report in my DB is one of two types; a Daily Report (requires a single criteria which is the date) and the second is a History report. To view or print a report, I have designed a Filter form to fill in with the report criteria and clicking a button to open the report.The first type (Daily R) work fine without problems. The second type (History R)has a problem. In this report, the criteria are two or three because a history report will retrieve data within a period, so I have to input (FromDate) and (ToDate)and may be adding another criteria which is called a company.In all history reports, the report header will accomodate the two input values of date and extract the rest of report items into the reprot detail area.The problem is, the desigened system doesnot respond well as expected. When I load the filter form to fill in criteria for a history report, I have input the FromDate and ToDate and selected the third criteria (if any), then, the reprot opens without data in it.on the other hand, I tried to load the report directly form opening it, inputing criteria, and it has worked fine without probelms.Would someone expect a key reason for this problem or dirtecly can solve this problem?Appreciate youtr support.Thanks in Advance.mhegazy
 

A:Solved: MS Access report load from a form having report criteria

Read other 16 answers
RELEVANCY SCORE 108

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 108

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 108

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 108

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 108

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 108

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 108

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 106.8

I have a group done in a report, This causes the grouped on field to appear in the line above the details that belong to it. How do I make this appear on the first detail line of the group? This is to save space in a report that could be overly long with all the 'blank' lines between groups. (I know this should be a problem)
 

A:Access 2007 Report layout question

You can drag the Group Header text down on to the Details and close up the group header.
But you will then have the text on every record.
It might be best to make the Header Font smaller and reduce any spare vertical space to a minimum, the same does for the Details.
 

Read other 1 answers
RELEVANCY SCORE 106.8

I havn't been able to find a solution for a problem like this, so here it is..

I have alot of data displayed on a form. When i click a button on that form, it's supposed to open a report with the information that is displayed on the form. (basically it's a "review form before submitting" functionality) I need this report to show the information on the form the button is on, and also some information that is inside a subform on that form.

I am having issues having the report display this information when the button is clicked.. It's asking me to enter parameter values that it shouldn't be asking me for. Has anyone made a function like this before that has a solution? Any example code would be great
 

A:MS Access 2007 / Report Filter not working

Read other 15 answers
RELEVANCY SCORE 106.8

I have an access 2007 report that prints the totals from three different fields using three different queries. 1. Total number of businesses, 2. Total number of Inspections. 3. Percentage of Businesses that were inspected, 4. The total number of inspectors.

Because there are dates on the inspections, I have a parameter to enter the year that I want totals for. My problem is that I want the year I have selected to print at the top of the report so it will be evident what period the figures represent. Any ideas?
 

A:Print Parameter on Access 2007 Report

Margo, if you use a Form for the Parameter Input like the one that we used on your first database that I helped with you can then create columns with the Form fields as Headings to include on your report using -
Forms![Formname]![Fieldname]
 

Read other 1 answers
RELEVANCY SCORE 106.8

I am trying to produce a report in an outline format as follows:

Employee Name
Employee Name
Employee Name

Client

Heading 1
Subheading
Subheading
Subheading

Heading 2
Subheading
Subheading

There may be more than 1 employee doing a particular service for a client. They each input their service seperately as a new record. I need to be able to pull out the information for headings and subheadings to display as above. I also need to be able to pull out the information associated with the client. My fields are Department, Employee First Name, Last Name, Client, Heading, Subheading. How do I display this in a report. Have tried many options. Please Help!!
 

A:Solved: Access 2007 Report Formatting

Read other 15 answers
RELEVANCY SCORE 106.8

Hi,

I am looking to highlight the report entity i.e. Date if Null, becomes highlighted as RED.

Private Sub Report_Current()
If IsNull([Report Date]) Then
Me.[Report Date].BackColor = RGB(255, 0, 0)
Else
Exit Sub
End If

End Sub

The above work on the report only when i click on the report field and it turns it into RED.

I want it to automatically turn RED if the Date results on the report are NULL.

I have also tried with Report on Load , on Open etc but results remain the same.

I hope this is clear.

Regards,
aejaz
 

A:MS Access 2007 Report results Highlight as red

Read other 11 answers
RELEVANCY SCORE 106.8

Hello,

First time poster so please be nice . With that out of the way here is my question:

First some background info to help understand the problem:
I am have designed a report in Access 2007 that displays a list of programs on what servers they are installed (if any) and where they are missing.

CountyName ProgramName ProgramVersion Size
County1 BlackHole.exe 2.4.0.5945 1072KB
County1 DirtFarm.exe 2.4.0.5945 1072KB
County1 PlayGround.exe 2.4.0.5945 1072KB
County1 Gremlin.exe 2.4.0.5945 1072KB
County1 Water.exe 2.4.0.5945 1072KB
County1 Hydrogen.exe 2.4.0.5945 1072KB
County1 JustInTime.exe 2.4.0.5945 1072KB
County1 RogerRabbit.exe 2.4.0.5945 1072KB
County1 SuperMan.exe 2.4.0.5945 1072KB
County2 Hydrogen.exe 2.4.0.5945 1072KB
County2 JustInTime.exe 2.4.0.5945 1072KB
County2 RogerRabbit.exe 2.4.0.5945 1072KB
County2 SuperMan.exe 2.4.0.5945 1072KB
County2 Ironman.exe 2.4.0.5945 1072KB
County2 Gorgon.exe 2.4.0.5945 1072KB
County3 BlackHole.exe 2.4.0.5663 1064KB
County3 Astroid.exe 2.4.0.5663 1064KB
County3 Galaxy.exe 2.4.0.5945 1064KB
County3 SpaceMan.exe 2.4.0.5663 1064KB
County3 Clouds.exe 2.4.0.5663 1064KB
County3 Green.exe 2.4.0.5945 1064KB
County3 Ground.exe 2.4.0.5663 1064KB
County3 DirtFarm.exe 2.4.0.5663 1064KB
County3 PlayGround.exe 2.4.0.5945 1064KB
County3 Gremlin.exe 2.4.0.5663 1064KB

what I would like is a way to use conditional formatting on the report to highlight any Program version in red where the program name is the same as County1 but the Program Version i... Read more

A:Solved: MS Access 2007 Report Question

Read other 6 answers
RELEVANCY SCORE 106.8

Hi,

I am working for a small Hotel where we need to generate a report to watch the accounts. There would be around three types of reports viz. Daily, Weekly and Monthly. I know nothing about MS Access except the names like table, query and forms, other than this its like a rocket science to me.

Here is what i can describe best,
1. Daily transactions like bill number (awesome if automated), payment made, details of food or drinks ordered, date, mode of payment etc will be entered in the system OR may be extracted from the excel dump
2. This Hotel already have a software that helps them do the basic billing thing but is not good at reporting level so we are planning to find an alternative and my boss asked me to use Ms. Access (sorry i am loosing focus)
3. We'll be printing out the daily, weekly and monthly reports and filing them for records

I am attaching a sample excel here to help you understand what the data would be like. Can you please help me with a quick program in MS Access (great if its in 2007) that will serve the purpose.

Thanks in advance,

Vishal
 

A:Help to create Ms. Access 2007 report or form

Vishal, I can assist you with this.
Is the Excel "Input" tab the same as the "excel dump"?
 

Read other 1 answers
RELEVANCY SCORE 106.8

Can anyone tell me how I reduce the line spacing in a group in reports. Any help would be greatly appreciated.
 

A:Access 2007 report formatting in groups

Report Line Spacing is literally controlled by the layout on the Report, so reduce any space between lines and from the "Group Header & Footer".
 

Read other 1 answers
RELEVANCY SCORE 106.8

I was trying to create a report from scratch based on a parameter query in Access 2007. But my query did not show up in the "Fields List Box" where I could pick the fields I wanted for my report. I saw all the tables in my database with their associated fields in that box but no query. Is there anything I was doing wrong? Please help

Thanks
 

A:How to base a report on a query in access 2007

The easiest way to accomplish this is to highlight the query and Hit report - you can then strip it all out and start from scratch again but it will link the correct fields

Its strange i know but it jsut doesnt like to work with queries.

The alternative is, if you really do want to start from scratch is create the Text Box (unbound) and link it in properties to the relevant field. Like in the picture
 

Read other 2 answers
RELEVANCY SCORE 106.8

I have a report I run based on a query that works perfectly. I'm managing event registration for an association of school student councils. The report is a separate page for each school that summarizes the information I have for that school relative to its participation, i.e. school name, address, who is coming, how much they owe, etc.

It works fine when I want a page for all of the schools, but sometimes I just want a single school...not all of them. I copied my original query and set up a parameter in the copy [What school?] and it selects the school I want. However, when I run a copy of my original report I made changing the source to my new query, when I open the report, the parameter box opens, I put in the school name I want, and the box comes up again, and eventually my report opens with no data in it.

Help? I don't do VBA, but I get around Access pretty well.
 

A:Access 2007 - Report from Query with Parameter

Read other 9 answers
RELEVANCY SCORE 106.8

I'm having a problem getting an query right for this report. I've been using Access awhile and have gotten comfortable with SQL queries but I haven't any experience with VBA, modules and classes at this point. (I've managed to work around that so far but am trying to learn on my own)

I have a bond table and my monthly report should show Total Liabilty at the beginning of the month - activity during the month, and Total liability at the end of the month. Table fields needed for this report are:

[Date Bond Set Up] [Dollar Amount of Bond] [Date Bond Cleared]

I need to Count how many bonds were set up in the month. Total dollar value, Total number and amount of bonds cleared during the month and ending liability. Sounds simple right? Summing and counting is easy, but I have two date values and the two dates in the record are usually not the same month.

I have tried an input dialog where you enter month and year, and just set criteria for both the "set up" and "cleared" date fields in the query equal to the input dates for the report, which should in theory show at least activity during the month.(It returned "0" every time) But then I still have to figure totally liabilty at the end of the previous month and new total liability after this month's activity. I'm wondering if I should restructure my tables now. I'm up against a deadline and I'm not rational any more. HELP!
 

A:Solved: Access 2007 Report Nightmare

Read other 16 answers
RELEVANCY SCORE 106.8

I have a created a report that requires the following information.
It must pull repair data from an OrderID Table & OrderItems Table and calculate the totals of repairs per unit and per company. This all works fine (one small glich with null value)

OrderID Table has the fields "OrderNumber"(autonumber), "OrderDate"(default date), "CustomerName", "CoverallID#"
OrderItems Table has the fields "OrderNumber", "ServiceItem", "RepairQty", "detailID" (autonumber)

Input into these tables come from an OrderForm with a SubOrderForm.
The orderform inputs to OrderID Table and supplies the OrderNumber for the OrderItems Table.
The suborderform inputs to the OrderItems Table.

All Tables have a default value set for the Item, Rate, Qty...etc.
So when I pull up the report everything totals fine where an item on the subform has been entered

The issue I am having is this....
There are some orders where only info on the main form is needed ...the suborder form is only for repairs.
When repairs are entered the totals on the report are fine.
When repairs are not entered it does not create a record in the OrderItems table....only the Ordertable.
Therefore the repair total on the report thinks there is a null value and comes up with an error.
I have made sure there is a default value set on the OrderItems table for the OrderNumber, ServiceItem, RepairQty and DetailID.
So I am not sure how to correct this.

Any h... Read more

A:Access 2007 report trouble with null value

Read other 16 answers
RELEVANCY SCORE 106.8

Hello all,
I am using MICROSOFT OFFICE ACCESS 2007
I am having a dilema with this report I created to print cards. It is on preprinted 4 up card stock paper. I have designed the report to fit in the spaces it needs to be. The only thing is this database has almost 30k records. It is currently printing the same record 4 times on the same sheet of paper. It also prints a few extra blank sheets also afer each page.

I can reduce the database down to maybe 10-15 records if someone wants to take a look.

What I need to happen is print 4 different records on the page with no blank pages after.

Any suggestions would be greatly appreciated.

Thanks in Advance.
John.
 

A:Solved: Question about Access 2007 report

Read other 7 answers
RELEVANCY SCORE 106.8

Hello.

I have a report, with 3 sub-reports in. It collects all the data for a particular SiteID. in Each of the sub-reports, there is a cost value. One for Hardware, one for Mobiles, and one for Phone lines. I have fields at the top of report which reflects the values and totals them up. Works great, except:
When i have a SiteID with one of the subforms being empty; i.e no mobiles on the site it displays fine in the report view, but when i go to print or publish as a pdf it strips out the subform with no value, and throws an error in my calculation. I need the calculation there, which means i need it to stop striping out the subform with no value. I however cannot see how to do this...its just bugging me, its fine inthe report view, just when you send it to print.

Would grateful for some help,

Thanks Mike
 

A:Solved: Access Report removing sub-report when printing etc.

Read other 16 answers
RELEVANCY SCORE 106.8

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 106.8

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 106.8

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 106.8

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 106.8

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 106.8

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 106.8

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 106.8

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 106.8

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