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 Replies


ADVERTISEMENT

Reports :: Select Data For Continuous Records In A Report

Feb 26, 2015

For the report in question all data is taken from one table named "Completions ". The fields I will be using are as follows:

Code:

[Surname]
[Firstname]
[Branch]
[Quarter1_A]
[Quarter1_T]

When the records are added, the Branch is added using a combo box. There can be several rows of data with the same Firstname and Surname but with different Branches.The report layout must look something like this.I have tried using DLookup to select the data based on the data in the Name text box, but this just gets the first result and duplicates it.

View 2 Replies View Related

Reports :: Save Report As PDF And Auto Populate File Name

May 8, 2013

My reports are saved as a PDF at the moment I click the print report button, select cutePDF Writer then manually add the Quote number stored in Field from the Table or form into the file name, then select the location to store the PDF file

Can I make this process automated when I click the print report button to auto select PDF Print, then auto populate the file name with the quote/Inv Number and then save to nominated directory.

View 6 Replies View Related

Reports :: DLookup - Populate Textbox Based On Value That Is In Another Field On Report

Oct 20, 2014

I have a textbox on a report that I wish to populate based on the value that is in another textbox/field on the report, and I thought DLookup was the way to go - however, I cannot seem to get it to work.

I have a table (ComplaintsResponses) that has two fields, both text

[ShortDescription]
[ResponseText]

The text from [ShortDescription] is saved in a field on another table that contains all the other relevant information that is used in the report, and whilst this short description is mostly fine, I have one report where I need the data from the larger [ResponseText] field.

I have tried the following code:

Code:
=DLookUp("[ResponseText]","[ComplaintsResponses]","[ShortDescription='" & [Reports]![PublicComplaintsArea]![txtSAPCRMResponse] & "'")

and

Code:
=DLookUp("[ResponseText]","[ComplaintsResponses]","[ShortDescription='" & [SAPCRMResponse] & "'")

Both of which return a #Error in the text box.

The field that contains the text that is used for the lookup is SAPCRMResponse, and the textbox on the report itself is called txtSAPCRMResponse.

View 2 Replies View Related

Reports :: Populate Table With Price From DLookup In Form To Total In Report

Apr 25, 2013

I am working with a database that I downloaded and am trying to modify to fit my needs.

This is an inventory database. The products table contains a description and pricing. I want the description and pricing to populate in the Purchase Order form, so I added Dlookup fields in the Purchase Order form. I was happy.

However, the pricing information is not populating to my Inventory Transactions Table from the Purchase Order form by way of this Dlookup feature, and therefore will not show on my report, and in turn does not show in my Total of my Purchase Order report.

As a work around, I tried creating a calculation in the purchase order report, of =[UnitsOrdered]*[Products.UnitPrice], and the pricing totals show fine on my report, but the subtotal doesn't work.

I was unable to upload my file...so a few notes of info...

There are no queries set up in the database for this report.

I had tried a sorting grouping thing (in the Report) by Subtotal, but now can't get rid of it.

When I show the field list for the report, across the top of the window reads:

SELECT DISTINCTROW Employees.*, Products.*, [Inventory Transactions].*, [Purchase ORders].*, Suppliers.*, nz([Inventory Transact

Looks like it runs out of space

I am trying to attach a couple of images to support my comments.

Since this issue crosses both reports and forms (and tables!), I am not sure where to properly post. The end result I am looking for is on my report.

I am using Access 2003...

View 1 Replies View Related

Reports :: Filter A Report By Using A Multi-select Box

Oct 3, 2013

I'm using the following code to filter a report by using a multi-select box.

Code:
Private Sub cmdOpenReport_Click()
On Error GoTo Err_cmdOpenReport_Click

Dim strWhere As String
Dim ctl As Control
Dim varItem As Variant

[code]....

I have a report that contains a subreport. The report is simply an image of a word document. The subreport will contain the actual data.When I open the subreport, the IN query works perfectly. When I open the main report, I only get the first record listed in the IN query. I have the master/child links set properly.

View 14 Replies View Related

Reports :: User Select Data For Report

Aug 22, 2013

How to proceed and what is the "accepted" version of events.I have created a report, a dynamic method statement actually, and want my user to be able select some data to appear in the report. Report is rptMS01, it is fed from a query and has some fields to automatically populate [Company], [Site], [Postcode] etc. All of the static text is in CanGrow textboxes to sidestep the report height limit. The report is opened by a button on a form which uses a macro to open only for the current site. All OK so far.

My boss would like a section/text box/subreport to select the personnel involved in each method statement and this to appear on the report. So, on clicking the button on the form which would usually open the report directly, some kind of intermediary selection form opens instead with a list of all personnel. User can then select which personnel to involve and on clicking OK this appears in the designated box on the report. A CanGrow/Shrink textbox would be ideal!

Do I need to include this in the current query which feeds the report? I know a listbox can have multiple selections but how would I reference this? How do I keep the other fields as well? Should I create a table with the personnel list?...

View 2 Replies View Related

Reports :: Report With Date Select / Search And Other Variables

Sep 26, 2014

I have a report reporting events that occurred today, using =Date() in the query.I want to have a control/box on the report which shows today's date by default, but enables me to select a different date with the outcome that the report refreshes and shows the events on the selected date instead.

Maybe I need a form for this although I would like to do conditional formatting so a report is better.It would also be good to be able to sort by column values, as in a table on a webpage with sort controls in the column headings which work just by clicking.

View 2 Replies View Related

Reports :: Filter Report By Multi Select Listbox

Oct 10, 2014

I'm using pbauldy's code to filter a report by a multi-select listbox. The only issue is..how do I include more (7 to be exact) listboxes to the code? It seems the OpenReport vba is only allowing 1 where clause?

Code:
Dim strWhere As String
Dim ctl As Control
Dim varItem As Variant
'add selected values to string
Set ctl = Me.VP_ListBox

[Code] .....

View 7 Replies View Related

Reports :: Select 4th Slice Of Pie Chart In Access 2003 Report

Nov 4, 2013

I've got a simple dataset that will ALWAYS have 4 rows, against which I have assigned the colours Green, Amber, Red, Grey. So I made a simple pie-chart to go on the report, but I can't work out how to assign the same colours.

Please see 3 attachments showing the current layout, the preferred layout (which I mocked up in Excel) and the chart settings screen.

The chart is working OK i.e. 4 slices appear and they are the right size, but when I open the chart, I see only East, West, North. So I am unable to manually set the colour for the 4th slice.

View 10 Replies View Related

Modules & VBA :: Report With Only Select Records In Table?

Dec 17, 2014

I have a master table located on the backend of the server with about 3 fields:

Software
Version
Description

I have 4 databases, one for each software on the front end accessing this master table.

So far I have in the master table a dropdown to select 1 of the 4 software's, the version number and a brief description.

One the front end I have a button that when pressed will bring up the report based on the master table.

Can I have the report just select the software that it refers to. For instance if the datebase is Sony when I click on the report it only grabs the records with Sony on it. For my next database when I open up Sharp's database it only makes a report for the Sharp records.

How would I do this? Is this something I have to code or something I can do in criteria or do I create a query?

View 2 Replies View Related

Counting Records In Report From Select Field

Aug 22, 2015

there are 3 options Yes Somewhat and Not really I want to count the records that only have Yes.

View 5 Replies View Related

Forms :: Open Report Button To Select Data From 7 List Boxes And Present In A Report?

Aug 13, 2015

I have a form with 7 List boxes linked to 7 Query's which in turn are linked to a table. Each list box if for a particular trade.

I am trying to select a person or persons from each List box and then have them sent to a report. I have Code to do one list box, but do not know how to link all boxes with code to a 'Open report' button.

The code I am using is as follows:-

Private Sub cmdOpenReport_Click()
On Error GoTo Err_cmdOpenReport_Click
Dim strWhere As String
Dim ctl As Control
Dim varItem As Variant
'make sure a selection has been made

[code]....

View 9 Replies View Related

Reports :: Can't Sort Records In Sub-report

Oct 29, 2013

I am using Access 2007.I have a report that has 2 subreports within it.One of the sub reports input is from a table (Work Order Parts) whose records have a field called "DisplayOrder". This is a numeric field that I use to enable the user to specify the exact order that they want the records to be displayed in a form or report...well that's the plan anyway.

I can't seem to get the subreport to sort on the "DisplayOrder" field.

I have tried to set the Property value "Display Order" to "[Workorder Parts].DisplayOrder" but this doesn't seem to make a difference. The "Order By on Load" is set to "Yes".

Here is the "Record Source" value : SELECT DISTINCTROW [Workorder Parts].*, Parts.PartName, [Workorder Parts].Notes FROM Parts INNER JOIN [Workorder Parts] ON Parts.PartID = [Workorder Parts].PartID;

What am I doing wrong?

View 5 Replies View Related

Reports :: Not Count Duplicate Records In Report

Mar 30, 2015

I have a simple report which looks as given below:

ID Number Products
122 Cups
133 Pencils
122 Cups
133 Pencils

When I use the count function I get the total count of the record as 4.what I want is count the product varieties which should be 2

View 5 Replies View Related

Reports :: How To Display Subform Records On Report

Feb 20, 2014

How do I pull information from a subform (more than 1 record in subform at times) to put on my report?

I have added the subform to the report and set Visible property to No,

I know the syntax to refer to the subform and its fields but I don't understand how to get all records in the subform for the main record to be displayed.

View 3 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 :: Create A Report And Only Show Records With Exception

Feb 19, 2014

I have a field on a form (exception) that is also a column in a query. I would like to create a report an only show those records that had an exception in it. I am not sure what criteria in the query to use, but it would seem creating a report off of this query would work.

View 1 Replies View Related

Reports :: Counting Number Of Distinct Records In Report?

Oct 11, 2013

I'm creating a report for an imaginary "medical clinic's database", the intended function of which is described as follows: "Create a statistic that shows the total number of distinct drugs prescribed to a patient."

Where I'm at:

I've created a query called UniqueDrugs containing drug and patient info. The SQL is:

Quote:

SELECT DISTINCT Drugs.Drug_Name, Patients.[Patient _ID]
FROM Patients INNER JOIN (Drugs INNER JOIN Prescriptions ON Drugs.[Drug_ID] = Prescriptions.[Drug_ID]) ON Patients.[Patient _ID] = Prescriptions.[Patient_ID]
GROUP BY Drugs.Drug_Name, Patients.[Patient _ID]
ORDER BY Patients.[Patient _ID];

The results of this query seem to be what I need. All I need is for the count formula that I use to return the number of distinct drug names there are that are related to a patient's ID.

I've created a report and I've put the following formula into a text box:

=DCount("[Drug_Name]","[UniqueDrugs]","[Patient_ID]=[PID]")

Where PID is the name of another text box in the report that contains the Patient ID that I want to compare to the drug names returned by the query.

However, this *always* results in #Error, no matter how I change the formula.I have been led to believe that syntax is not the issue, as the following formula worked as intended for a different task:

=DCount("[Prescription_Date]","[UniqueYearQuery]","[Patient_ID]=[PID]")

How do I use a DCount to return the number of different drugs that have been prescribed to a patient?

If it did not require the number of different drugs, I would simply use the following formula, which works just fine:

=Count(Drug_Name)

View 6 Replies View Related

Reports :: Display 50 Records In A Report Field In Two Columns Of 25

Nov 9, 2013

How to display in a report a field with 50 records in two separate columns of 25 records.Is this possible or am I completely off the reservation?

View 2 Replies View Related

Reports :: Auto Generate Report Or Records From Table

Nov 5, 2013

I have a table called bookings, three records within that table are;

arrivaldate
departuredate
breakfast

This Table (Bookings) is linked to the guest table via GUESTID..Assuming that a guest arrive on the 5th and leaves on the 10th, I am trying to create a breakfast voucher for the guest for each day of their stay.

So 5 vouchers, 1 each for the 6th, 7th, 8th, 9th, and 10th.I have created the breakfast voucher as a report and a query to include data but I dont know how to propagate the new data to actually create the vouchers. All I can get is data for the arrival or departure fields.

View 2 Replies View Related

Reports :: VBA Checkbox Code Ticking All Records On Report

Nov 13, 2013

I have the following code in the On Load of a report which shows multiple records:-

Code:
If Me.PaymentType Like "Debit/Credit Card" Then
Me.Check94 = True
Else
Me.Check94 = False
End If

This ends up checking all check boxes in the report if any have "Debit/Credit Card" in the PaymentType field.What I wanted was to tick Checkboxes for those records where the statement was true, and not tick those where it is false.Do I need the code in the On Current event? Or do I need more sophisticated code?

View 3 Replies View Related

Reports :: Hiding Null Records In Report With IIF Statement

Dec 29, 2014

I have a report based on a query with 3 fields (Tested, RMA, OpenRMA). The query searches all the tables in my database and gives me a count of the equipment tested, RMA reported and open rma.

The report has two fields (Equipment, NumberTested) with a total below and also a total of the RMAs and OpenRMAs. I'm trying to hide RMAs and OpenRMAs from appearing in the body and only showing below the total. All three totals are showing correctly, but I am still seeing RMA and Open RMA with a null in the count in the body.

So in the report's Equipment.control I wanted to put

Iif([NumberTested] is null, null, [Equipment])

Meaning if the numbertested field is null the equipment field will be blank, if it is not just leave what is in the equipment field there, but it returns a #Error in the printout. It seems to handle the two null records correctly. Trying Equipment.Value also returned the same error.

View 6 Replies View Related







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