Reports :: Cannot Remove Graphic From Report

Jul 18, 2013

On a report I have an image. Its properties are:

Name: OLEUnbound9
OLE Type: Embedded
OLE Type Allowed: Either
OLE Class: Microsoft Photo Editor 3.0 Photo
Class: MSPhotoEd.3

When I try and delete it I get an error message: The OLE server isn't registered. To register the OLE server, reinstall it

How do I reinstall it, or better still how do I simply delete the image?

View Replies


ADVERTISEMENT

Reports :: Graphic Object Display Error

Apr 4, 2015

We have a ms graph object in the report. All the programming code relating to it is perfect and the graph displays correct too. But in some circumstances, the graph displays with different mold than it should be.

When we preview it in a single base, it works fine. Sometimes, in this way too the graph has a display error.

I have used the maximum potential solution to this, but all failed in vain.

1. Setting delays and refreshing the form and re-querying the graph data
2. Created a new database and imported all the objects and tried to run
3. Compact and repair database
4. Tried with re-creating the report from scratch.

why this type of error display is coming up with the ms graph object.

View 3 Replies View Related

Reports :: Remove Prompt While Running Report

Apr 8, 2015

I have a report that is created from the following query (qryTotalProjectHours). What I am trying to do is get the total hours spent on Tasks within a given time period.

Code:

SELECT TasksEntries.Project, TasksEntries.Task, Sum(TimeTracker.WorkHours) AS TotalHours
FROM TasksEntries INNER JOIN TimeTracker
ON (TasksEntries.EmployeeId = TimeTracker.EmployeeId) AND (TasksEntries.TaskID = TimeTracker.TaskId)
GROUP BY TasksEntries.Project, TasksEntries.Task;

I accept the start and end dates in a form and pass it like shown below. WorkDate is a column in the TimeTracker table and is not present in any other table.

Code:

strWhere = "WorkDate BETWEEN #" & txtMgrRptStartDate & "# AND #" & txtMgrRptEndDate & "#"
DoCmd.OpenReport "rptTotalProjectHours", acViewPreview, "qryTotalProjectHours", strWhere, acWindowNormal

When the report is invoked, I get a box where it says
"Enter parameter value" for Workdate..

Is there anyway I can get rid of the prompt? I never thought you needed the column name in the SELECT statement to be able to run this.I should add the I tried the query with the WorkDate hardcoded in there and it worked fine and returned the correct results

View 5 Replies View Related

Reports :: Remove Restore Window Icon On Report Menu Bar

May 2, 2013

I have created a custom menu used on my reports which contains all the icons I need and anchored them to the right side of the report. I have been able to remove the min, max and the close icons from the default report menu bar at the top right hand side as well as the "Ask A Question" dropdown. But I am not able to remove the "Restore window" button that comes with the report print preview.

How do I remove the "Restore Window" icon from the report's menu bar?

I'm using Access 2003...

View 3 Replies View Related

Placing A Graphic On A Label

Dec 1, 2005

I have rcently produced a label report for my Xmas cards, and I would like to add a picture to the label in the form of Father Christmas. Can anyone help me on this subject.

View 1 Replies View Related

Graphic Design In The New Access 2007

Apr 14, 2006

Has anyone heard if they have improved the rather dismal graphic design portion of form and report editing in the new Access?

I was hoping for an interface more in keeping with standard graphic design programs.

View 2 Replies View Related

Reports :: Remove Characters Before 1st Space

Mar 11, 2013

What forumla could I use in a report field to remove all characters before the first space in a text field e.g.

32A Bank Street --> Bank Street
19 Alder Street --> Alder Street

I've tried =Right([JLADD1],Len([JLADD1])-2) but this obviously doesn't work for the first example above.

View 5 Replies View Related

Reports :: Hide Subreport If No Data And Remove Blank Space

Sep 11, 2013

I have a report which contains 3 subreports. Now I require to do the following:

1. Hide the subreport if there is no data.
2. Remove the Blank space created when the data in subreport is null.

I tried to Set Can Grow and Can Shrink to Yes but still the blank space was not removed.

When I reduced the height of the subreports in the design view the blank space was reduced but it was still there.

What can be done so that the complete report auto adjusts itself if any sub-report is null? Something like the whole page auto fits itself in the available space?

The option of reducing the size of sub report in design view to minimum is there but it makes the report very un-handy for future reference.

View 3 Replies View Related

Modules & VBA :: Remove Prompt While Running Report

Apr 9, 2015

I posted this within the Reports as well, but since this has a little bit of VBA decided to ask this here as well.

I have a report that is created from the following query (qryTotalProjectHours). What I am trying to do is get the total hours spent on Tasks within a given time period. A given Task can we worked on by multiple individuals and hence I need to find a way to aggregate the hours spent.

Code:
SELECT TasksEntries.Project, TasksEntries.Task, Sum(TimeTracker.WorkHours) AS TotalHours
FROM TasksEntries INNER JOIN TimeTracker
ON (TasksEntries.EmployeeId = TimeTracker.EmployeeId) AND (TasksEntries.TaskID = TimeTracker.TaskId)
GROUP BY TasksEntries.Project, TasksEntries.Task

I accept the start and end dates in a form and pass it like shown below. WorkDate is a column in the TimeTracker table and is not present in any other table.

Code:
strWhere = "WorkDate BETWEEN #" & txtMgrRptStartDate & "# AND #" & txtMgrRptEndDate & "#"
DoCmd.OpenReport "rptTotalProjectHours", acViewPreview, "qryTotalProjectHours", strWhere, acWindowNormal

When the report is invoked, I get a box where it says
"Enter parameter value" for Workdate..

Is there anyway I can get rid of the prompt? I never thought you needed the column name in the SELECT statement to be able to run this.

I should add the I tried the query with the WorkDate hardcoded in there and it worked fine and returned the correct results

I have attached the cut down version of the database that I am working on.Open up the frmManagerReport Form
Leave the Employee drop down empty
Enter the start and end dates ( I have used 4/1/2015 and 4/30/2015)
Select the 3rd option "Generate Tasks by Total Hours"
click on Run
When you do that you will see the prompt come up. Enter any date and you will see the report. The report generated uses the results from the query and does not filter on the date selected in the form. This is what I have been struggling to fix since yesterday but have reached nowhere..

View 11 Replies View Related

Modules & VBA :: Create A Simple Report But Remove Duplicates

Nov 4, 2013

I have a simple spreadsheet:

Ref# Rev
97 b
98 c
99 c
99 e
100 c
100 b
101 a
102 b

I need to create a simple report but remove the duplicates (ex. Ref# 99,100). I need to delete the older Rev's (Ex Ref# 99 Rev C, Ref# 100 Rev B).Is this done throughRecordsets? will an SQL query do the trick?

View 7 Replies View Related

Remove Unwrap Text After Exporting Report From Access To Excel?

Mar 14, 2012

How to remove unwrap text after exporting report from Access to Excel?

View 11 Replies View Related

Reports :: Print Only Report Matching Current Record In Form Among Multiple Reports

Oct 2, 2013

I have been an MS Excel man all along my career and I am a novice in MS Access.I have created a table, [Initial Customer Approval] which records data from a Form, [Initial Customer Approval]. Once the data is entered in the Form, I need to do some calculations based on the data entered in some of the fields in the form.I created 6 different queries for the six possible values in those fields. now for each of those queries I created respective reports.I placed a Print command button in the Form.

1. When I press the Print button it should open the report for the current record in the Form. (Currently It Opens all the reports simulatneously, with only one relevant report containing the current record; other opened reports being blank.)

2. If user presses the Print button before pressing Save button then system should prompt user.

Here is the code (Please note [reference number] is the unique ID generated for each record entered in the tabe through form):

Private bSaveClicked As Boolean
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Not bSaveClicked Then
MsgBox "You are trying to navigate away from the active record. Please either save your changes, or press ESC to cancel your changes.", vbOKOnly + vbInformation
Cancel = True

[code]...

View 5 Replies View Related

Reports :: Subtract Totals From 2 Sub-reports In Main Report Of Access?

Dec 28, 2014

I am trying to create a P&L statement in access. I know what I want to come out at the end. I am just starting to play with access and having trouble getting what I want to come out of it.

On the sales side I have a query that gathers all the revenue sources and calculates a total for each date. I then use a second query to just take out the data I want for the P&L report. I created a sub-report that displays the data I want. I use the grouping and grand total features to get the total into the report footer. So far so good.

On the expense side I created a form of a query to manage the one to many relationship to capture the data for expenses (one purchase with many line items). I created a query based of this query to get the relevant data for my expense sub-report. I created the sub-report and got everything looking and calculating the way I want it to. I use the same grouping and grand total features to display the data in the report footer. Still good.

I created a new main parent report with the two sub-reports (sales & expenses) on it and even was able to pull the totals from the sub-reports into the main (so currently the subtotals of the two sub-reports are displayed twice). Now when I try to use the textboxes I used to pull the sub-report totals into the main report to perform additional calculations (sales - expenses) I get #error. I have tried different things and gotten ?name.

Control source for the two textbox controls on the main that display correctly, but don't let me do any further calculations.

=[rptP&LExpensesOverview]![AccessTotalsAmount]

=[rptP&LSalesOverview]![AccessTotalsTotal Sales]

To do the subtraction I have tried using the references above, as well as just using the names of the unbound text boxes in the report that bring the totals into the main report.

As a work around, I tried to build one query with all the data from sales and expenses, but can't "filter" based on date and get the data I want in the query results because the two sets of data are not necessarily related. I either get a long list of records, or no records (I am currently only playing with about 5 days of data).

View 2 Replies View Related

Reports :: Filtering Report To Only Show Current Month Report?

Nov 16, 2014

The aim of what I am doing is to create a monthly statement to give to our intermediaries that shows the commission they will receive each month for the deals they have referred. I have managed to create this report, HOWEVER I can't figure out how to filter out which month I need, so I a report for Jan, Feb Mar etc... The idea is that at the end of each month I need to run the report so only the latest month shows...

View 3 Replies View Related

Reports :: Hide Report Footer Based On Report Data?

Dec 21, 2014

How do I hide the report footer based on the report's data ?

I'm trying to hide if number of users = 1

The report's data is a query built inside the report's RecordSource, not a self standing query.

View 10 Replies View Related

Reports :: Unfiltered Report Footer Totals On Filtered Report?

Apr 10, 2014

I've done this once entirely by accident and can't seem to duplicate it...

I have a report. It has the following:

Report Header: Logo and title
Department Header
Supervisor Header
Group Header
Detail
Department Footer: Totals
Report Footer: Overall Totals for all departments

Here's my question.
I have combo boxes on my main form that filter this report. The combo boxes are referred to by the query that runs the report. How do I get proper unfiltered overall totals in my report footer?

View 4 Replies View Related

Reports :: Join Smaller Report On The Back Of Main Report?

Apr 18, 2013

I have a report that displays incidents, their details, consequences and a photo. Among the details is a severity rating high medium or low, I have been asked to make the report shorten the records which have been given a low severity (because it takes up as much space as the more important/severe ones).

The only method I can think of is to use the onformat event, to shrink and make invisible all the fields that I don't want to see if the severity field shows 'low'.

View 3 Replies View Related

Reports :: Select Records From Report To Populate Second Report?

May 24, 2015

We have a shift log that includes both personnel actions during any given day as well as operational actions. (We recently switched from a word document to an Access Database to allow multiple users to input events while another has the logbook open already (which you couldn't do with Word))

At the beginning of each day, my manager reviews the previous days log and forwards up pertinent data (some personnel, some operational) to our higher authorities. Is there a way to allow him to select which records he'd like to include on that higher-authorities report straight from the local-level report?

I'm not a fan of allowing him a "Save As" feature because that kind of defeats the data integrity purpose of an events log where he could save as an RTF and then edit any of the log entries without any checks or balances.

View 2 Replies View Related

Reports :: Scrolling Down Report Changes Report Fields To Errors

Jun 26, 2013

I have an odd thing happening with my reports. There is a main report that gives class information (from query). There are two subreports (from queries also ) with scores (one for each type of test). There are some unbound controls on the main form that display a count of how many scores are recorded which are totals from the subreports. The controls all report the correct numbers however, when I scroll down to view each record, some of them change to #error, or #name, or similar for a moment. Sometimes they will stay in error form when I stop scrolling but change to correct if I scroll up just a bit. Is this because the controls won't calculate unless that report record has focus?

View 1 Replies View Related

Reports :: Hide Report Label If Sub Report Count Is 0

Dec 18, 2013

Is there a way to hide a label on a report if the sub report count is 0?

View 2 Replies View Related

Reports :: Getting Totals From Five Reports To Create One Report

Feb 18, 2015

Is there a way to have say five different reports that give out information and at the bottom the totals. I would like to take each of those separate reports to create one report with just the totals.

View 3 Replies View Related

Reports :: Pulling Data Into A Report From Another Report

Mar 20, 2015

So I have a text box in a report that I want to pull in data from a field in another report, so the 'control' for my text box looks something like this...

=[Reports]![rptSalesReceiptSub]![Text141] (i.e Text141 is the data I want to pull into my report)

...the path is completely correct but when I run my report I get.#Name? If I run the report that has the data I want, it's fine (in other words Text141 has valid data in it)

View 4 Replies View Related

Reports :: Possible To Send Report As XLS And Keep Format Exactly As Report Looks

Jul 11, 2013

I am wondering if it is possible to send a report as xls file and keep the format exactly as the report looks.When I try to send it now, it automatically changes back to the column names from the table, which I in the report have changed and want to keep in my excel output!

View 3 Replies View Related

Reports :: Unbound Report - Print Preview OK But None Of Fields Print When Report Directly Send To Printer

May 25, 2013

I have an unbound form with an associated report. When the user hits the 'print' button on the form/screen, the report is launched in the background. In the On Load event of the report I populate the report fields from the forms field as so:

Code:
Me.txtAddrMainLine2 = "NAME " & UCase([Forms]![frm_OrderRx].[txtPatientName])

This works like a charm as long as I call the report in Print Preview mode (i.e. with acViewPreview). But if I send the report directly to the printer, none of the fields print.

I've read about using other report events to populate the fields (e.g., On Format and On Print) and also something about using TempVars to pass the data. But I haven't read anything that's clear and definitive about the full answer.

View 3 Replies View Related

Reports :: IF ELSE SUM In Report

May 5, 2013

I have debit & credit column.

Which I use this in the report --> =IIf([PaymentMet_trans]=2,"",[Amount]) debit = 1 , credit = 2...

Now, i would like to have the total sum of it. according to the debit & credit separately instead of the whole total sum.

i did this : =Sum(IIf([PaymentMet_trans]=2,0,[Amount]))

error pop up : this expression is typed incorrectly or is too complex etc etc ...

View 1 Replies View Related

Total Of All The Reports In One Report

Jun 24, 2006

I have designed many queries in my db and report for every single query. Each report has count filed. =Count(*).

Now I want a report to show these count fields. Which will serve purpose to get overall summary report. I have tried using

[Report]![name of field]

but it does not work.

Could somebody please help?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved