472,352 Members | 1,576 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,352 software developers and data experts.

multi-page, multi-filter access report problem


this is my question --

I need to create a multi-page report. each page is about a product
selected during runtime. the number of products is also decided at

right now, i loop thru a recordset. in each iteration, i get the field
from the recordset, and pass it as filter to openReport with
acViewNormal. but I prefer to have the report opened in preview first.
I tried to use openReport with acViewPreview. However, access doesn't
allow me to do that, giving a warning like "you can't make changes once
the report starts printing". So the report in preview has only the
first page.

I wonder if someone knows anything about this. Your suggestions are
greatly appreciated! Thank you so much!


Nov 13 '05 #1
0 1374

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Mike MacSween | last post by:
tblCourses one to many to tblEvents. A course may have an intro workshop (a type of event), a mid course workshop, a final exam. Or any...
by: Prakash | last post by:
Hi, In my Access Report ... If there is "NO" entry i.e. (no corresponding CODE) in my Data-File, then even the Master-File entry does not show...
by: Mike | last post by:
I have a report that is called from a form. I can noarrow the report to the correct data, however I receive two sets of detail sections. I beleive...
by: Hemant Trivedi | last post by:
Hi I am Hemant Hello to everone Now I want to discuss a problem I am facing in Ms-Access report and I want solution of it can U help me? My...
by: rmfoley | last post by:
All, I would like to create a professional looking cover sheet with information loaded from an MS Access Report. I created the cover sheet in...
by: DeniseY | last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it...
by: harley.mcnerthney | last post by:
I have an Access 2007 problem and I would just like to know if there is some sort of solution out there. The problem is, when I build a report...
by: jmartmem | last post by:
Greetings, I have an Access report that contains a Page Header, Detail, Page Footer and Report Footer, My problem is that the subreport in the...
by: mchang | last post by:
I have a query that show in a report a date column. running the query the date column is populated correctly but the report show it wrong. query:...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.