Solved

Problem with naming a pdf file and setting criteria

Posted on 2011-09-23
7
188 Views
Last Modified: 2012-05-12
I am having trouble generating pdf file based on a criteria set in a query.  Currently the file name is as listed below;

Plan 92 Provider #1 07.08.2011

Plan 92 = is part of the that on the report (this is what I need to add based on that field in the table)
Provider #1 = Reference
07.08.2011 = DraftDate

I need to add the PlanType at the end of the file name based on the criteria set in the query.  This is where I am having trouble, the PlanType is in the “tluFundsImport” table.  I tried setting the criteria in the “qryRPT1” query to generated just those PlanType 92, but it is creating pdf for all files, and disregarding the query.  

I need to create a separate report for each Reference Number, and having a pdf file for each Reference, but only if there is a record:  an example of what I need is as follows:

Reference, PlanType, DraftDate, it should look like this: Provider #1 Plan 92 07.16.2011

I will be creating a different report for each Plan Type, and will need to generate just the records with these Plan Type for each Reference.

I file is attached.  Thanks in advance!

Test-EFT-08-24-11--5-New-2.accdb
0
Comment
Question by:Delores_C
  • 4
  • 2
7 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 36589488
is the recordsource of your report the query "qryRPT1" ?

0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 36589782
Why is qryRPT1 a "Group By"  query...

In a general sense the recordset and the Report recordsource should be basically the same.

Also note that the pound symbol ("#") is a *restricted* character in Windows file names...
http://support.microsoft.com/kb/177506
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36589844
..and so is the period (".")
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36589869
This "Kinda" works OK for me.
(it runs without errors, and produces 3 PDF files, all with *valid* file names)

If it is not what you wanted, then pleas state what is wrong with it.

Jeff
Test-EFT-08-24-11--5-New-2.accdb
0
 

Author Comment

by:Delores_C
ID: 36590159
Answer for Capricorn1:  Yes the qryRPT! isw the record source

Answer for boarg2000:  Problems:

1.  The file is still using the title, which is part of the script in the SQL, not the actual PlanType in the filename
There are 3 differenct PlanType in the table. I  should have deleted the Plan 92 from the script

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36590429
So what are the *Exact* results you are looking for, based on the DB you posted?

In other words don't describe what is, or is not happening like you are doing above...

Literally list the *EXACT* results you are expecting.
Ex:
I need ____ files created
The first file should be named _____ and should have ____ records, ...etc
The second file should be named _____ and should have ____ records, ...etc
...etc
0
 

Author Closing Comment

by:Delores_C
ID: 36897305
The answer was part of the answer
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now