make report work on access db form

I have an access DB with forms front end applicatiom and in the the test scenarios form has a button that when clicked triggers a report. It does not do anything - the preview pops up and then disappears empty. Can someone get it to work? All the guys at work couldn't and there are 400 techos there....
Autotest-forms-indev.zip
joeloyzagaAsked:
Who is Participating?
 
als315Commented:
Report "rpt_results_for_schedule" has recordsource:
SELECT sch_test_schedule_list.TestScheduleRef, sch_test_schedule_list.Order, sch_test_schedule_list.TestSuiteRef, sch_test_suites.TestSuiteName
FROM sch_test_suites RIGHT JOIN sch_test_schedule_list ON sch_test_suites.TestSuiteRef = sch_test_schedule_list.TestSuiteRef
WHERE (((sch_test_schedule_list.TestScheduleRef)=[Forms]![frmTestSchedule]![TestScheduleRef]))
ORDER BY sch_test_schedule_list.Order;

Open in new window

But I can't find field TestScheduleRef on form frmTestSchedule.
References to this field are commented. You should check this query.

You can also add No Data event to this report as it was recommended by LSMConsulting above:
Private Sub Report_NoData(Cancel As Integer)
MsgBox "There is no data for this report", vbOKOnly
Cancel = True
End Sub
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I can't open the Zip file - tells me the download is invalid/corrupt.

Note too that BEFORE zipping these up, please do a Compact and Repair on the database.

Also:

Exactly how do we test the database? What forms do we open, which buttons do we click, do we need to enter any text, etc etc. The more information you can give us the better off you'll be.
0
 
als315Commented:
Scott:I think it is rar archive renamed to zip.
But there are only tables and queries in uploaded DB.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I see ... normally WinZip can figure that out. I changed the extension to .rar but no joy either.

Might just be my machine, of course, and if there are only tables/queries then as you indicate we can't be of much help anyway.
0
 
als315Commented:
free 7zip and winrar open without problems. It also has 2 linked tables, so I think it is not backend DB.
PS.It is 7zip renamed to zip
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Ahhh ... I used 7Zip and it worked!

Still, as you said there are only tables and queries here, so not much to go on.
0
 
Helen FeddemaCommented:
Typically, a report opened from a form is filtered by some value selected on the form.  So you should check the code from the button or whatever control opens the report, as well as the report's record source.  Try opening the report independently, to see if the unfiltered record source is OK, then step through the code that opens the filtered report, to see where the error occurs.  You might also want to check whether there are any records in the filtered recordset, before opening the report.
0
 
joeloyzagaAuthor Commented:
helen, did all that and while theren are no records why doesn't it come up as an empty report?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Generally a report with no records will throw an error, but you can avoid that if you place code in the Report's NoData event - something like

Sub Report_NoData()
  Msgbox "There is no data for this report"
End Sub

However, if you still have other issues please UPLOAD THE FRONTEND DATABASE. The one you uploaded is just tables, with no Forms or Reports.
0
 
joeloyzagaAuthor Commented:
0
 
als315Commented:
@joeloyzaga:
1. You have two backends:
BackEnduploaded is only Autotest.db. Can you upload also Autoresults.mdb?
2. Please, explain what exact form should be opened, what should be selected and what button pressed.
0
 
joeloyzagaAuthor Commented:
if  you use the test scenario form - the button is on the middle menu row next to the export to excel button
0
 
als315Commented:
You are using "OTA COM Type Lib". Not sure anybody has it. I don't have. So I can't open  Switchboard. Not sure about other forms, but let's try.
Can you give exact name of problem form? If you open it in design mode, in upper left corner you will see form's name:
form
0
 
joeloyzagaAuthor Commented:
heres the db
Autoresults1.zip
0
 
joeloyzagaAuthor Commented:
cant see it on this pc will look at work
0
 
als315Commented:
Tables seems OK, what about form name (or at least sequence of buttons should be pressed)?
0
 
joeloyzagaAuthor Commented:
the form is the test suites form and the screen shot of button is attached
test-suites.JPG
0
 
joeloyzagaAuthor Commented:
I also had that problem which made me think that I could find a working one in the backups - and it did!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.