• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

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
0
joeloyzaga
Asked:
joeloyzaga
  • 7
  • 6
  • 4
  • +1
1 Solution
 
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
 
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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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
 
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
 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

  • 7
  • 6
  • 4
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now