Solved: Access report...elusive code!?!!

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Erm

Thread Starter
Joined
Jul 30, 2003
Messages
298
Attached is a simple database which involves rather complicated reporting and searching! I have a search form (displayed by clicking Produce Key Dates Report on the Main Menu), specifying a start and end date and either a Fee Earner or Office and clicking Search, should run a macro and produce a report (rptKeyDatesReport). The report is based on qryCaseDetails and this incorporates qrySearch.

The problem is that when I click Search I get a data entry box requesting the start date and then the end date...suggesting I have [Enter start date] and [Enter end date] somewhere in the queries. As it should just take the dates from the Search form. I have searched high and low for the elusive code to no avail! Please help.

The attachment was zipped using zip central.
 

Attachments

OBP

Joined
Mar 8, 2005
Messages
19,895
Hi Debs, I thought we had this one working quite well. I will take a look.
You are opening the correct Report?
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Debs, the problem is the Other Important date SubReport on your Report. It uses the Query called qryLimitationDates for it's data source which has the old Input Dates method.
It is odd because the actual stand alone Subreport uses the QueryqryPrintFilteredOther as it's data source.
 

Erm

Thread Starter
Joined
Jul 30, 2003
Messages
298
Sorry for the delay, I've been unwell. Ah ha! Right sorted that one and I have now creteted several subreports with different data sources for different purposes.

Still not getting data on the report produced through the Search Form though...Any ideas? New version is attached.
 

Attachments

Erm

Thread Starter
Joined
Jul 30, 2003
Messages
298
When you click on Produce Key Dates Report from the main menu and specifiy an office and a date range.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
OK, before I look at this one thing that you have to check is that where you have more than one Table in your Search Query that you want to find data on is that the data actually exists in all the Tables that are linked in the query.
For instance if you have 3 tables linked then the required data linking them must be in all 3 tables, even though you may only be searching 2 tables.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Debs, the File Numbers in the Case Details and the Other dates Tables do not match.
 

Erm

Thread Starter
Joined
Jul 30, 2003
Messages
298
Apologies...lost internet at home...will look into this?! Thanks!
 

Erm

Thread Starter
Joined
Jul 30, 2003
Messages
298
ok sorted the numbers...but what do i do if they have court dates and not other dates or vice versa...both tables will not always be populated...how can i resolve this without a default 'none' record?
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Have you tried it with No records in the table to find out what happens?
 

Erm

Thread Starter
Joined
Jul 30, 2003
Messages
298
Yes, I get a blank report when trying to produce the key dates report. No information pulls through at all?!
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Can you post the latest version with corrected case numbers in the respective tables please?
 

Erm

Thread Starter
Joined
Jul 30, 2003
Messages
298
Been off this task for a while...wish I could ditch it all together! Anyways...apologies for being so rude and not keeping you informed OBP, your help is much appreciated!

So the issue is...I have a report that uses info from the 3 tables, which is printed without data if either of the tables are blank...but on most departments only use other dates or court dates...rarely both. What are my options to get around this?

I have attached the database...but it has minimal test data.
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top