Solved

Problem with naming a pdf file and setting criteria

Posted on 2011-09-23
7
191 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

734 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