Special Report I Need To Make
Jul 27, 2006
Hi, I'm running Microsoft access version 10 and i need help with a report i need to make. I need to print out a roster report showing what students show up on what days. I have boolean variables in the table for each day and it is quite easy to make a report of the students i want with the days of the week and a check under which day the student comes in. What I want however, instead of a check to show up under Monday (or any day) for the students, i want that students name to appear. So i teacher can just go down the list and on any given day see the students names very easily. when a student does not show up that day that row and column can just be blank
Here is a very crude sample of the report a have. a slash is a check
Monday Tuesday Wednesday
Jack / /
Brian /
Kelly / / /
Here would be the exact same report but formated the way i want it
Monday Tuesday Wednesday
Jack Jack Jack
Brian Brian
Kelly Kelly Kelly Kelly
thanks for any help.
Keith
View Replies
ADVERTISEMENT
Jun 3, 2014
I'v looking for since a couple months a go to make a report direct from access form using crystal report but i havent found it yet. I'v tried this code and its giving me errors. " run time error 1004 method range of object _global failed "
how to make a report using crystal report direct from ms access as front end application ? is it possible to use crystal report ?btw i use database sql server 2008 and MS Access 2007 as my frontend application.here's the code that i'v found and gives me an error
Dim CR As New CRAXDRT.Application
Dim rep As CRAXDRT.Report
Set rep = CR.OpenReport(Range(" ??? ")) * i getting error in this line, what should i do to fill it ??
rep.ParameterFields(1).AddCurrentValue "Boston"
rep.ParameterFields(2).AddCurrentValue "Cars"
rep.Database.Tables(1).SetLogOnInfo "tool", "db_tsel"
rep.ReadRecords
rep.PrintOut promptUser:=False, numberOfCopy:=1 ' promptUser:=True doesn't work
View 2 Replies
View Related
Jun 15, 2006
Does anyone know how to make a report have lines in it like excel can do when you print out. My boss likes to read this data with lines seperating stuff. Thanks.
View 3 Replies
View Related
Jul 7, 2006
Ive been trying to make a form that has a report list for filtering. Everything I research and do just isnt working for me. Ive followed a video about it and visited these sites.
http://www.fabalou.com/Access/Reports/filterreport.asp
http://www.fgcu.edu/support/office2000/access/
http://www.access-programmers.co.uk/forums/showthread.php?t=110337
I think the code just isnt working in 97...
View 1 Replies
View Related
Jul 7, 2006
Ive been trying to make a form that has a report list for filtering. Everything I research and do just isnt working for me. Ive followed a video about it and visited these sites.
http://www.fabalou.com/Access/Reports/filterreport.asp
http://www.fgcu.edu/support/office2000/access/
http://www.access-programmers.co.uk/forums/showthread.php?t=110337
I think the code just isnt working in 97...
Any Ideas? Maybe I just need more help or the code needs edited!?!?!
Thanks.
View 3 Replies
View Related
Oct 31, 2005
How can I get a make-table query to run in a report?
View 6 Replies
View Related
Apr 1, 2015
i have the following code to make the PDF form a report. but i want to make the PDF in landscape mode and also each time with a new name.
If Me.Combo3.Value = "" Or IsNull(Me.Combo3.Value) Then
MsgBox "Please enter order number!", vbExclamation, "Order number required"
' ElseIf Me.cmb_AuftragNummer.Value Like "*[a-z]*" Or Len(Me.cmb_AuftragNummer.Value) <> 6 Then
'MsgBox "Invalid order number!", vbExclamation, "Invalid order number"
Else
DoCmd.OpenReport "rep_CQAReport", acViewPreview, , "[Fehlercode] = '" & [Combo3] & "'"
DoCmd.Close acForm, "frm_rep_cqaReport_filter"
DoCmd.OutputTo acOutputReport, "rep_CQAReport", acFormatPDF, "O:ApplicationsCQA ReportingPDFTest01.pdf", False
End If
View 12 Replies
View Related
Aug 2, 2006
Hello,
I have a query that prompts the user for input to generate a report.
I would like to in essence copy that same record set and append it to a different table (archive table).
Not quite sure how to go about it.
Thank you
View 5 Replies
View Related
Aug 13, 2005
I want my fields on the report to show up if there is data to show and to disappear if no data is avaliable. Also, will the fields format together or will they still stay apart? I need them closer together for the report.
Here we go.
In the report are months 1, 2 and 3 as well as the label box for each. I need the label box and the data(text box) to disappear when the data box is null. This is where I had started:
Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
If Not IsNull(Me.Ctl1_Month) Then Me.Ctl1_Month.Visible = True
Else
Me.Ctl1_Month.Visible = False
End If
End Sub
But when I try and run the report I get this error:
Can't Execute Code in Design Mode.
Can someone help as to what I have done wrong or where I should place this type of format?
Many thanks.
View 8 Replies
View Related
Feb 5, 2008
Not sure if this is possible but here goes (even if I make a fool of myself for asking).
I have a report that lists data based on criteria set in a form. The main criteria is Month (Month4Report) and Year (Year4Report).
The report lists all jobs that started that month and also any jobs that had work done during that month - even if they started in the previous month.
What I would like to do is highlight any job that has an actual start date prior to the current searched month (Month4Report). By making it bold or other way.
Is this possible?
Thanks.
Martin
View 8 Replies
View Related
Feb 20, 2014
I am making a football database for my sixth form project. It consists of 6 teams and i need to make a top scorers report for each team. I am attempting to make a query for each report which will consist of the fields needed, under the field 'Team Name' i need to validate it for each team so that each query only shows their specific team, then i can make it into a report. But i do NOT know how to validate it. In human words i want it to say something like this " Only include this player if value of the team name if it is equal to 'St.Albans city east' (one of my teams)".
View 1 Replies
View Related
Aug 19, 2004
Background:
I have a database with one main table that contains info on a variety of organizations and the services they offer. Another table lists regions these organizations are located in. The services they offer are listed in 11 different categories, each with its own field in the main database.
The end product of the project will be several reports. In particular, I need one report that lists by zipcode, each organization, its contact info, and any details about its services. The data for each organization will appear on several lines, as shown below:
---------------
Org name Region
Address Driving Directions
Contact Name
Phone
Comments
Food bank: details of hours, etc.
Hot meals: details.... [any services not offered does not appear or take up any vertical space]
---------------
The problem:
Since the reports will be printed and put into booklets, we need to eliminate any blank lines caused by empty fields. In many cases an organization will only have one or two categories, so the other 9 or 10 lines would be blank and take up too much space on the page.
What I've tried:
First I tried creating SubReports so I could use VBA scripts on the On Print event on the Detail section to make the SubReport invisble if it didn't have any data (HasData is false). That did make the SubReport not print, but it still took vertical space.
I struggled with various combinations of Can Grow and Can Shrink, but kept having problems with multiple lines appearing where there should hav been one line, and sometimes they were blank lines (especially if I didn't allow duplicates and there were several entries exactly the same). Whenever I got that undercontrol, the fields with no data took up space. Frankly, I'm not convinced I ever got them to NOT take up vertical space. (Maybe I didn't get it right. I'm open to trying again.)
Then I tried concatenating fields onto one TextBox, like this: Code:=("Food Purchase: "+[Food Purchase]+Chr(13)+Chr(10)+Chr(13)+Chr(10)) & ("Utilities: "+[Utilities]+Chr(13)+Chr(10)+Chr(13)+Chr(10)) & ("To Prevent Eviction: "+[To Prevent Eviction]) That works, but it seems like an ugly hack. The Chr(10)+Chr(13) create new lines. The + instead of the & makes it so that if any of the elements inside the parentheses are null, none of them print. So I can eliminate both the label and the new line, too.
Isn't there a better way to eliminate the vertical space when there's no data?
View 4 Replies
View Related
Dec 1, 2012
i have made table to store mcq questions. i need to know how can i select random mcqs from table and print using reports to take tests..
View 1 Replies
View Related
Mar 26, 2013
I made a report with following crosstab query.
TRANSFORM Workersdetail.workername AS CountOfedate
SELECT Workersdetail.[attendance], Count(Workersdetail.[edate]) AS [Total Of edate]
FROM Workersdetail
GROUP BY Workersdetail.[Workername], Workersdetail.[attendance], Workersdetail.[workerhourenter]
PIVOT site+Cstr([workerhourenter])
I wanted to know that, is there any option through which my report gets autoupdate or refresh incase of addition in SITE field (as mentioned with PIVOT)?
View 1 Replies
View Related
Aug 28, 2014
I have a form with a Yes/No checkbox. Sometimes a data entry person will use this, sometimes an associated report is printed and a technician in the field will be required to fill check the box by hand and return the report for data entry. what I have tried to format the check box, if the box isn't already checked, I can't get it to show up clearly on the printed report. It's set to Visible, width 6pt, solid, black, always display, yet it still is barely visible. Ive tried increasing the grid line thicknesses, making it shadowed, nothing seems to work. Is there anything I can do?
View 9 Replies
View Related
Jul 16, 2013
I am using mail merge to add info from my database to my word document template. I want to make it the same as my form I have set up which gives me a patient name, dob, GP details as head of main form then a subform (continuous) of their medication. When I try a mail merge it comes up right but only shows one medication on each page. I want it to add all their medications to the body and have the patient info in the heading. Do-able?
View 3 Replies
View Related
Jun 22, 2014
i have a database. the database have a table called CardDetails in this table there is like 1000 rows.The table have a field named MedicalId. and i have a folder . it's destination (D:CardPic) . this folder contains 1000 pic has the same names as the medical ids....i need to make a report and show on it these pic's the database doesn't have a afield that contains the path.i need to auto display the images on the report depending on the medical id.
View 10 Replies
View Related
May 10, 2014
I'm working on a report. I have a text box that contains directory path for a picture which is showed in a image box on my report which works great. I have now created a label called "nopiclb" that has "no Pic "entered in it but I want to set the label to not visible if path1 has a file path in it but visible if path1 is empty
I put the code below in onformat event in the detail section, but is not working
Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.path1) = True Or Me.path1 = "" Then
Me.Nopiclb.Visible = True
Else
Me.Nopiclb.Visible = False
End If
End Sub
View 3 Replies
View Related
Oct 10, 2013
I have a table that shows "DONE" and "REMAIN" for each "AREA" like below:
Code:
AREADONEREMAIN TOTAL
AREA1100200300
AREA2200300500
AREA3200700900
Now I like to make a report that shows "DONE" and "REMAIN" in each AREA with pie chart, now I have problem how I have to do this job for the graph, how should be "row source" of chart control. What query needs on this table?
View 1 Replies
View Related
May 26, 2005
I am wondering if anyone can recommend shareware or free ware Utilities/code to make Form & Report Creation/Edits easier?
I'm thinking of something like Cub Editor http://www.peterssoftware.com/ce.htm or SmartForm+ http://www.aadconsulting.com/smtfrmplus.html
but alas .... I can't do anything that will edit the registry (company politics says Access and it's Wizards is plenty 'perfect' http://www.dbforums.com/images/smilies/frown.gif maybe I will convince the powers that be but not in short time)
Also the code (or forms / reports built) need to work on Access 2000, 2002 and 2003. or well-commented on how to modify as I'm only modest with writng VBA code.
Any ideas? Thanks!
Mark
View 1 Replies
View Related
Jun 16, 2014
I have a database and one of the functions is to track the purchase of fuel. Part of purchasing fuel is registering what the current odometer reads. My query gets the Vehicle ID, Date of Transaction and Odometer reading. I want to show a report that shows how many miles the vehicle is has traveled for a certain amount of time. If it's for 2013 then I'll put the criteria for 2014 in the date. This will give me a list of all vehicles and their odometer readings. I then sort the date by ascending.
In the report I group on vehicle ID and then I want to show all their transactions and add up how many miles were driven.
Vehicle 1
1/2/201
1/5/2013
1/15/2013
ETC...
Total Miles Driven in 2014: XXXXXX
View 1 Replies
View Related
Aug 22, 2013
I have a main report / subreport relation, just want to have a fixed length of each printout. e.g the total number of lines of the subreport should be 8 lines. However, lots of subreports contain records less than 8. I would like to know how to insert of blank line in the subreport depending on the records with content at each print, in order to make the total number of lines in each subreport is 8 each print!!
View 1 Replies
View Related
Dec 16, 2013
I am building a report that has a header with several details followed by a detail section.
What I need to do is make the entire entry not visible on the report if one of the dates is null.
So it looks like this
last first title id memb # date a date b
1. smith , john fng 8521 2356224
5/12/2012 6/20/2013
10/2/2013 (is null)
2. neckbone, jim dude 2548 85858412
6/20/2013 5/5/2014
8/5/2013 2/31/2013
On the report i want the 1st entry (smith john) not to be visible due to the null (B) Date.... but i want it to be visible once the date is entered...
View 2 Replies
View Related
Aug 23, 2013
I am trying to improve my code by making it more readible. The following code works, but it is certainly not the most efficient way. I`m trying to write a loop to make certain elements in an Access report visible/invisible, but I can`t address the visibility property of these items while iterating over i.
Code:
DoCmd.OpenReport "tblInterval subreport", acViewDesign, , , acHidden
Reports![tblInterval subreport]!BoxInsp1.Visible = False
Reports![tblInterval subreport]!BoxInsp2.Visible = False
Reports![tblInterval subreport]!BoxInsp3.Visible = False
[code]...
View 2 Replies
View Related
Dec 29, 2005
Hello,
I need your help.
in a budget application I'ma making, I have a table with all the budgets names, a table with the 12 months of the year, and a table with the budget, the months and the amount allocated for every budget topic for every month.
In order to facilitate the yearly view, i would like to build a special form that shows all the budgets for every month. Each column would be a diffetent month, the fist one being filled by the budget topics (a bit like an axecl sheet).
How can I build this form?
It is very helpfull for the application because it helps the user to fill the budgets month by month, but with keeping a yearly view (instead of having a long list of 3 columns, 1 for the budgets names, one fir the monthes, and one for the amounts).
Thanks in advance for your help.
View 6 Replies
View Related
Jul 23, 2007
Hi guys,
I have a question regarding special characters that access doesn't like to see.
When passing a string to be absolved via html, if I set myHtmlBody = "<font color="#000FF"></font> it will throw a syntax error because of the # character.
How can I solve this? Thx for any help.
View 2 Replies
View Related