I have Access 2013 but am new to Access and am learning as I go along!I am making a database of song lyrics so have made a table of the title of the songs with the lyrics for each verse as different fields. I want to be able to choose multiple songs by their title to then show the full lyrics on a report.
View RepliesI have a database that I use for keeping track of clients and printing invoices using a form/sub-form and report/sub-report. I want an image to be visible on my sub-report when I choose Received Payment in my sub-form. Right now I have my image set to visible = no.
View 14 Replies View RelatedI do not have the privileges to write code, but can use macros and Expression builder. I have written a bunch of queries and made reports for each of them. What I want to do is to be able to choose from the list of reports and view the chosen one. If that cannot be done without code, then to choose from a list of queries and then view the report made from the query. The user needs to be able to choose.
View 2 Replies View RelatedHi,
I'm trying to create a pop up form that asks userto select months for a report to preview. I've writtent he query and done the report. I can do the command button to get the selectmonth form to pop up, but not sure how I pass the selected months into query for the reports. Any tutorials on this or can someone help. I've been looking around but nothing quite fits. Quite new VB also, but have a good understanding programming generally.
Thanks.
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.
Hello,
Does anyone know how to create a form with a listbox that lets u choose reports and preview or print at the click of a button. I know you can do it wil tables and queries but I need it to do it for reports.
Thanks
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)
I have data from a survey with qualitative responses. For a single qualitative question, I moved the ID & responses into a new table and categorized the response according to a bucket/theme, where each column is a new bucket. I now have 10 columns. Each response is represented in 1 or more columns. I used an excel formula to copy the response data into the column itself.
Example:
A1 // B1// C1 // D1// E1//... L1
ID // Response // Cats // Dogs // Elephants //.... Column 10
1 // I like cats // I like cats //(null)//(null)// ... (null)//
2 // I like cats and dogs // I like cats and dogs // I like cats and dogs //(null)//..//
3 // etc.
However, now I'm realizing that Access always wants to show data for all records, or at most I can limit using a WHERE clause in my query.I want to use Access to generate this report:
1. Section 1: Show all responses from the Cats bucket where there is data
2. Section 2: Show all responses from the Dogs bucket where there is data
3. and so on
I know how to do summary values, and I know how to do filtering that apply across the whole report, but this seems like more advanced filtering, where I want to see selective details differently for each field.
I created a pop-up that appears when i open my report so that I can automatically sort through the report by date. However, the report will only allow me to choose one date and i need to be able to choose multiple dates. This pop-up is connected to a list box which has the multi select turned on. How can choose multiple dates through my pop-up?
View 1 Replies View RelatedI am new to access. What I want to do is to set up a button in where the value that I typed in a text box besides it, be transferred to the corresponding cell type.
Let's say I typed 100, and then I click Income or Expense, If I press Income it will be sent over to the cell containing the incomes and etc. A check box works too.
Next thing that I want is to create a sub category.
If I have a large categories list like in the personal account ledger template, I want to be able to select a main category and if it has a sub category, give me a drop down box to select the corresponding one.
I enter my value, choose whether its income or expense, date and etc, then if I choose the "Home" category, I want it to allow me to also select whether its "Phone", "Water" and so on.
I have a table tblMessages, with a yes/no column called Available I have a form with three checkboxes chk1, chk2, and chk3 the when i click chk1 the other two check should be checked which this code seems to do but what it is not doing is going to the table and selecting the data where the ID is 2. what am i missing here?
Private Sub chk1_Click()
Dim strSQL As String 'Holds the SQL statement for this command only.
If chk1 = True Then
chk2 = True
chk3 = True
strSQL = "UPDATE'[Available]' FROM 'tblMessages' WHERE '[ID]'= 2"
Else
chk2 = False
chk3 = False
strSQL = "UPDATE '[Available]' FROM 'tblMessages' WHERE '[ID]'=2"
End If
Me.Requery
End Sub
My employer is using Windows XP Pro and Office 2003 (a few machines have Office 2010, but not mine). Furthermore, the machines are running the Japanese language OS, which has caused some comparability issues with my English XP/Office 2003 at home.
I have a form containing an unbound textbox, with the name MIS. The form's Current event has the following code:
If IsNull([[ResignationDate]) Then
MIS = DateDiff("m", [NichiiGakkanStart], Date) + Int(Format(Date, "mmdd") < Format([NichiiGakkanStart], "mmdd"))
ElseIf [ResignationDate] > Date Then
MIS = DateDiff("m", [NichiiGakkanStart], Date) + Int(Format(Date, "mmdd") < Format([NichiiGakkanStart], "mmdd"))
[Code] .....
The calculates (correctly) the Months in Service of the employee who's information is being viewed.
Now, I am trying to create a report which lists the employees by work locations. The above , and other calculated information, is to be displayed in the report.
I used the wizard to create the report, using data from two different tables (employee & location).
I need to display the calculated information above for every employee at every location.
Example:
"Work Location"
"Employee Number" "Given Name" "Family Name" "Months in Service"
The report, as it is now, displays all work locations and the above employee info except the calculated data.
I've read up on using calculated fields in tables, and I'd prefer not to take this approach.
I posted the following code on a button (report to a first sergeant). I can't pull e-mail addresses from the report (rptLateByUnit).
=========
DoCmd.SendObject acSendReport, "rptLateByUnit", acFormatPDF, Me.CCF_EMail, Me.CCS_Email, , "FOUO: Open Personnel Data Discrepancies", "This document contains information which must be protected in accordance with AFI 33-332, Air Force Privacy Act Program, and DoD Regulation 5400.7R, DoD Freedom of Information Act Program; and Privacy Act of 1974 as amended applies. This document is For Official Use Only." & vbCr & vbCr & _
[Code]......
I've got a database written in Access 2010 that shows many reports. When the report is selected and data is available, it is shown as a full screen preview with the print dialog box displayed over it. However, I am having a problem in that when there is no data, a message box is displayed that's invoked from the 'on no data' setting but when it's dismissed the report is still displaying. How do I prevent this from happening?
View 8 Replies View RelatedIs it possible to mask data in a report? I have a report that contains a field for an ID number. Depending upon who is receiving the report only a partial ID number can be shown.
Example: Instead of showing ID#: 123456 the report can only show ***456.
I would like to create a text box in an existing report that uses data from another report. I create a new text box and go to it's control source and select the path.
In my case: =[Reports]![Radvantages members]![AccessTotalsAmount1]. When I run it, it sais "#Name?"
Is there another way to integrates data from another report? I don't want to use a subform becouse it doesn't work with my lay out
I am working on a project that is requiring me to hide a subreport that happens to be chart graph, when the chart has no data and my problem is that I cannot seem to get the report to properly hide and show the label behind it when the data is not there. I am in need of a SQL code that will read my blank record source as a zero instead of blank. I have tried Nz, IsEmpty, and IsNull and none of them seem to work.Here is the current SQL code:
SELECT DISTINCTROW Sum(Case_review.ID) AS SumOfID
FROM Case_review
WHERE (((Case_review.[Type of Issue].Value)="Clinical"));
Here is the current VBA code (which is in event on load) for the main report:
If Me.Rpt_Clinical.Report.HasData = -1 Then
Me.Label29.Visible = False
Me.Rpt_Clinical.Visible = True
Else
Me.Label29.Visible = True
Me.Rpt_Clinical.Visible = False
I am having trouble getting data to appear on my Report. The report is based of a Query, qryLabel. When I run qryLabel the correct data is displayed but when I try to use this data on the Report, I get an #Error or #Type. Here are the methods I have tried so far to get the data on my Report:
DLookUp
=DLookUp("[StoneLength]","Stones","[StoneName] = Forms![Product]![ProductID]")
Using The Query
=[qryLabel]![StoneLength]
Using the Table
=[Stones].[StoneLength]
I have a form where user can chose his own criteria for the report, like time period, ppl involved and other parameters. i open report filtered with these conditions. I also create a nice text (as public variable) bout what where the search criteria and put it in the header/footer. Then I export the report as xls file. it's nicely saved as column names and data, just what i need.how to add a field that would store the criteria, ie that string public variable that has it all neatly explained?
View 1 Replies View RelatedI have a database in MS SQL. The users connect to database via MS ACCES ADP applications.
Some tables (like a TV Station or Names of employees) in the database have fields that serve as the flags. If the flag has a value of one, then such a record is used in the query to create a report.
Because there are multiple users of the database, frequently happens that flags overlap. One user sets the flag to one, and second sets the flag to zero. Therefore, it often happens that the received report incorrect.
I have a REPORT containing 7 ('columnar') subreports. Each subreport is to show showing a days worth of medical doses.... to visually represent a wall planner.
When the report loads - user enters a week value # via Inputbox(). This value is written to a TEMP table. Each subreport accesses this same TEMP table to retrieve the week # value. In the Recordsource for each subreport I have the following code :
SELECT * FROM GETPATIENTREADINGS_WEEK WHERE (((Format([DateR],'ww'))=DLookup("WeekVal","[TEMPTABLE]")) AND ((GETPATIENTREADINGS_WEEK.DayVal)=1));
... where the DayVal goes from 1...7 corresponding to the columnar position of each subreport on the display ie. for each day of the week.
The problem I am having is that when the report runs - I see the display showing the data from when the report was previously run. ie. I have to run the report twice to see the data for the correct week value entered. All the SQL works as expected when I run from Query view but when I run through VBA..
I am creating a report that contains name andd birthdate on one line. I need to have up to seven lines in the report for some groups, but do not want to leave blank lines where no names exist. I am working in 2010 and have read about canshrink in 2007, is this approach availabel in 2010 and for date as well as text?
View 1 Replies View RelatedI have a report that generates the position of certain items. When I produce this report it doesn't put the data in order. All associated data with that position is correct, it is just not in numerical order. The attached screenshot shows the issue I am having. In the position column it should read 1,2,3,4 but in some cases the positions are not in order.
View 2 Replies View RelatedI Created a database that allows the user to create a jobsheet (Sign off Sheet) with inputting minimal information.I am having some problems accessing the data from my form to a report. I managed to get the full name of my AssignedTo and OpenedBy come up with this
=Trim(IIf([tblJobSheet] & " " & [tblJobSheet.AssignedTo] & " " & [Title] & " " & [FirstName] & " " & [LastName],[Title] & " " & [FirstName] & " " & [LastName]))
But this is only bringing up the information in my tblContacts and not actually assigning itself to the jobsheet. I have tried to just put in the "assigned to" but then this comes up as the ID number rather then the full name. And I have also tried to do this via the join table tblJobSheetContact but this only brings up Mr.
How can I pass data (an employee's first and last name) to a report ? I captured the employee's name from the listbox, but can't seem to pass it to the report. The desired report will only have the employee's name and records for related fields on the report. The table (contains emloyees' history data), form name, listBox (contains employees' names), and variable (contains the employee's name) are listed below.
Table_Employee_Detail_History
Form_Employee's Reports
Report_Attendance_Report
stremployee (variable
I've created a query that runs from a form and I would like the data to be shown subtotaled on a report.
Basically, I have Year Group, Behaviour Type, Behaviour Location and I would just like subtotals and %'s for each change. So, for example, there may be 1000 records in total 200 in Year 3, 500 in Year 4, 100 in Year 5 and 200 in Year 6. I would like to show this in a table with %'s as well as figures if possible (a pie chart is the eventual aim!)
Then I would like to subtotal the same records for the changes in Behaviour Type e.g. Bullying, Verbal Aggression etc to find out how many issues of each type have occured and the percentages.
I can get this information in a report using the group feature but it's a real mess and it's broken down far more than I expected.